List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:April 4 2006 3:33pm
Subject:Re: new password will not be effective for connection immediately
View as plain text  
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
Thread
new password will not be effective for connection immediatelyNanFei Wang4 Apr
  • Re: new password will not be effective for connection immediatelyDan Nelson4 Apr
  • Re: new password will not be effective for connection immediatelyGabriel PREDA4 Apr
  • Re: new password will not be effective for connection immediatelyKishore Jalleda4 Apr
RE: new password will not be effective for connection immediatelyJay Blanchard4 Apr