1.vim /etc/my.cnf[mysqld]skip-grant-tables ##追加此行,跳过权限表,
2.重启mysqlsystemctl restart mysqld
3.mysql 登陆mysqlmysql> use mysql;mysql> UPDATE user SET Password = password ( 'zha123456' ) WHERE User = 'root' ;mysql> flush privileges ; mysql> quit
4.恢复配置文件my.cnfvim /etc/my.cnf[mysqld]skip-grant-tables ##去掉此行,继续校验权限表,
5.重启mysqlsystemctl restart mysqld
转载于:https://www.cnblogs.com/songbao/p/11158702.html