I want to change the password of the User( which is root) in the table 'user' from the
I use the String sql = "update user set Password=password('somePassWord') where
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
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 !