On Thu, 5 Apr 2001, Kris Gonzalez wrote:
> when adding a new user or changing the authentication information for
> existing users, the changes often do not take effect unless i take down
> and restart 'mysqld'. example: changing root's password and exiting
> the mysql client, i cannot log back in to the mysql client using the new
>
> password...i must use the old password until i restart the database
> daemon.
You have to reload the grant tables (the 'mysql' database)
mysqladmin reload -u <DBA_user> -p
Give your password when prompted and the new changes will take place.
regards,
thalis
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php