解决方案：connect to server at 'localhost' failed error: 'Access denied for user 'root'

报错：

[[email protected] percona]# mysqladmin -u root password ‘root’
mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'root'@'localhost' (using password: NO)'

1. 停止mysql的服务
   [[email protected] percona]# service mysql stop Shutting down MySQL.. SUCCESS!

2. 安全模式进入mysql
   [[email protected] percona]# mysqld_safe --skip-grant-tables & [1] 13678
   

3. 修改密码
   mysql> use mysql;
mysql> update user set password=password('root') where user='root'and host='localhost';
mysql> flush privileges;
mysql> select * from user\G
mysql>quit

4. 成功使用root密码进入mysql
   service mysql start
mysql -uroot -proot