1.修改配置文件my.cnf
vim /etc/my.cnf
在文件[mysqld]下添加
skip-grant-tables
2.重启mysql
service mysqld restart
3.无用户名密码登陆mysql
4.修改用户名密码
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'root';
5.注释skip-grant-tables,重启ok
6.如果发现无法修改"The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement",输入
flush privileges即可。