Mysql更改root密码

1.service mysqld stop
2.vim /etc/my.cnf
添加skip-grant-tables

3.service mysqld start

4.查看systemctl status mysqld

5.mysql -uroot -p;
6.use mysql;
7.SET SQL_SAFE_UPDATES = 0;
8.update mysql.user set authentication_string=password('mima') where user='root';
9.SET SQL_SAFE_UPDATES = 1;
10.vim /etc/my.cnf
删除skip-grant-tables

posted on 2021-05-18 14:46  让代码改变世界ha  阅读(72)  评论(0编辑  收藏  举报

导航