The error shows that the passwords doesn't match. You just must have
made some mistake when resetting the password. But this can be fixed:
1) You can start the server with the --skip-grant-tables option that
disables password checking, then you log in as root, set the password,
and the restart the server without the --skip-grant-tables.
or
2) Use the --init-file option to run a file that resets the password.
Bith methods are described here:
http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html
It is a rare occurence, but the problem might also be this:
http://dev.mysql.com/doc/refman/5.0/en/password-too-long.html
Best regards
Anders Karlsson
Cornelia Menzel wrote:
Am 16.10.2006 um 13:08 schrieb Dominik Klein:
Unfortunately, that is not the reason, why I get this message. I
have tried 'mysql', 'mysql -uroot', mysql -u root', 'mysql -uroot
-p', 'mysql -uroot -pMY_PASSWORD', but anything fails.
When I am using the password option, the error message is like this:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
password: YES)
Any ideas?
Did you restart the server after you set the password? Did you
execute "flush privileges"?
Yes, I did, but it did not work. I have no idea, what the problem is.
And I cannot understand, why I cannot login after having reset the
root password.
---------------------------------------------
Cornelia Menzel
Spanien / EspaƱa / Spain
e-Mail: [EMAIL PROTECTED]
http://www.corneliamenzel.com
--
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Anders Karlsson ([EMAIL PROTECTED])
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Sales Engineer
/_/ /_/\_, /___/\___\_\___/ Stockholm
<___/ www.mysql.com Cellphone: +46 708 608121
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]