I wrote; mysql> UPDATE mysql.user SET
Password=OLD_PASSWORD('the_new_password') WHERE User='root';
mysql> FLUSH PRIVILEGES;
mysql> \quit
Then; shell> mysql -u root -p
Enter password: the_new_password
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)
Is this 'cause I didn't kill mysqld_safe before trying to login again?
N.P
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
