Cannot login to mysql

swmok · 06-20-2007, 08:33 AM

Hi:
I've just install mysql 5 in my system.
Later I set the root password by

mysql -u root
mysql> USE mysql;
mysql> UPDATE user SET Password='mypassword' WHERE user='root';
mysql> FLUSH PRIVILEGES;

Then I exit the mysql. However, I cannot login again.
When I type:

mysql -u root -p
[type in the mypassword]

It shows:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

What can I do?
How to reset the root password in mysql?

Thanks.

stickman · 06-20-2007, 03:18 PM

You should have done:
password = password("mypassword")

swmok · 06-20-2007, 07:02 PM

Do you mean
UPDATE user SET Password='mypassword' WHERE user='root';
is not correct?

It should be:
UPDATE user SET password='mypassword' WHERE user='root';
??

Thus, the password has not been set???
So, what should I do now??
Thanks.

stickman · 06-20-2007, 11:02 PM

The command you should have issued was:
UPDATE user SET password=password('mypassword') WHERE user='root';

This inserts the password hash into the user table. Unfortunately, the command that you issued set the hash to "mypassword". You might try doing a Google search for restarting with the --skip-grant-tables flag.