毛宏钢

导航

liunx忘记用户密码 

 1 1.vim /etc/my.cnf
 2 [mysqld]
 3 skip-grant-tables     ##追加此行，跳过权限表，
 4 
 5 2.重启mysql
 6 systemctl restart mysqld
 7 
 8 3.mysql 登陆mysql
 9 mysql> use mysql;
10 mysql> UPDATE user SET Password = password ( 'zha123456' ) WHERE User = 'root' ;
11 mysql> flush privileges ; 
12 mysql> quit
13 
14 4.恢复配置文件my.cnf
15 vim /etc/my.cnf
16 [mysqld]
17 skip-grant-tables     ##去掉此行，继续校验权限表，
18 
19 5.重启mysql
20 systemctl restart mysqld

 

posted on 2019-07-18 17:19  毛宏钢  阅读(188)  评论(0)    收藏  举报