Mysql Access denied for user'root'@解决办法

1、打开并编辑vim /etc/my.cnf

2、在[mysqld]下方加一行代码Addskip-grant-tables

3、重启mysql/etc/init.d/mysql restart

4、使用命令行连接mysqlmysql -u root -p

5、mysql> flush privileges;

6、ALTER USER 'root'@'localhost' IDENTIFIED BY '新密码';

7、quit退出mysql命令行

8、返回编辑my.cnf，删除或注释skip-grant-tables行vim /etc/my.cnf

9、重启mysql/etc/init.d/mysql restart