You need to issue "FLUSH PRIVILEGES" or you must "RELOAD" Mysql for the changes to come into effect after you have changed your settings ....
Kishore Jalleda http://kjalleda.googlepages.com/ On 4/4/06, NanFei Wang <[EMAIL PROTECTED]> wrote: > > Hi, > I want to change the password of the User( which is root) in the table > 'user' from the database 'mysql'. > > I use the String sql = "update user set Password=password('somePassWord') > where User='root'"; > I see from MySql Query Browser the password really changed ! > > Before I stop the mysql from Service in Control Panel of my machine Window > Xp, > I can still make connection to the mysql database with the old password of > the user 'root'. > > Only when I Stop and Start again the mysql from Service in Control Panel , > the connection to the mysql database with the old password of the user > 'root' will fail, > and with the new password of the user 'root' will succeed ! > > My question is I hope the new password will be effective for connection > immediately > without ' Stop and Start ' the mysql Service. > > Thanks for your help ! > > NanFei > >