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

 [root@localhost ~]# /usr/local/mysql/bin/mysql -uroot -p password

Enter password:

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

 

解决：

[root@localhost mysql]# /usr/local/mysql/bin/mysqld_safe --user=mysql --skip-grant-tables --skip-networking &

     [root@localhost mysql]#/usr/local/mysql/ bin/mysql -u root mysql

 

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

 

mysql> update user set password=PASSWORD(123456) where user='root';

Query OK, 3 rows affected (0.00 sec)

Rows matched: 3  Changed: 3  Warnings: 0

 

mysql> flush privileges;

Query OK, 0 rows affected (0.00 sec)

 

[root@localhost mysql]# /usr/local/mysql/bin/mysql -uroot -p

Enter password: ******

Welcome to the MySQL monitor.  Commands end with ; or \g.

Your MySQL connection id is 2

Server version: 5.1.50-log Source distribution

 

Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.

This software comes with ABSOLUTELY NO WARRANTY. This is free software,

and you are welcome to modify and redistribute it under the GPL v2 license

 

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

 

mysql> show databases;

+--------------------+

| Database           |

+--------------------+

| information_schema |

| mysql              |

| test               |

+--------------------+

3 rows in set (0.00 sec)

 

 

from: http://feinibuke.blog.51cto.com/1724260/388025