[EMAIL PROTECTED] wrote: >>Hi Paul >> >>Got it this time! Now its working. >> >>Commented out the 'sqlsocket'. Then gave host as 'localhost', instead of >>IP Address. >> >>Changed user to 'root'. >> >>So this means I may not be able to connect from network? >> >>My question is, why doesnt 'user=nataraj' work when I have given >> >> GRANT ALL ON nataraj.* TO [EMAIL PROTECTED] identified by 'mypasswd' ; >> >>in Mysql client ? >> > > > Did you do a 'flush privileges;' after the grant command?
that is not required. flush privileges is only needed when you update the privilege tables manually. -- ________________________________________________________________ Paul Stevens paul at nfg.nl NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 The Netherlands________________________________http://www.nfg.nl