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( w
Only if you run this SQL statement:
*FLUSH PRIVILEGES*
That will make the new password effective.
--
Gabriel PREDA
Senior Web Developer
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 pass
[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.
--
My
