解决Mysql ERROR 1045 (28000)“Acc..

时间：2010-09-06 来源：非你不可

[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

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)