Re: new password will not be effective for connection immediately

[Dan Nelson]

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 really changed !

If you edit the mysql tables directly, you must use the "FLUSH
PRIVILEGES" command to tell mysql that they have changed.  A cleaner
alternative would be to use the "SET PASSWORD" command.

http://dev.mysql.com/doc/refman/5.0/en/user-account-management.html

-- 
	Dan Nelson
	dnelson@stripped