'
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
[snip]
My question is I hope the new password will be effective for connection
immediately
without ' Stop and Start ' the mysql Service.
[/snip]
Instead of stopping and starting the service you should do the following
query;
FLUSH PRIVILEGES;
That will cause new passwords to take effect
In the last episode (Apr 04), NanFei Wang said:
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
Only if you run this SQL statement:
*FLUSH PRIVILEGES*
That will make the new password effective.
--
Gabriel PREDA
Senior Web Developer
' 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