You need to issue "FLUSH PRIVILEGES" or you must "RELOAD" Mysql for the
changes to come into effect after you have changed your settings ....
On 4/4/06, NanFei Wang <nanfeiwang@stripped> wrote:
> 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
> 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
> without ' Stop and Start ' the mysql Service.
> Thanks for your help !