解决Mysql ERROR 1045 (28000)“Access denied for user 'root'@'localhost'”

今天本地登入服务器的时候mysql提示：Mysql ERROR 1045 (28000)“Access denied for user 'root'@'localhost'”

解决方法：

1. 因为我用的yum安装的，所以路径可以不用指定

# /etc/init.d/mysql stop

# mysqld_safe --user=mysql --skip-grant-tables --skip-networking &

# mysql -u root mysql

mysql> UPDATE user SET Password=PASSWORD('123456') where USER='root';

mysql> FLUSH PRIVILEGES;

mysql> quit

# /etc/init.d/mysqld restart

# mysql -uroot -p

Enter password:

mysql>

2.如果是编译安装且安装路径为/usr/local/mysql，解决方法：

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

Enterpassword: ******

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

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

mysql> flush privileges;

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

mysql>