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
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
