linux中忘记mysql用户root密码解决方案

it2022-05-05  150

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


最新回复(0)