在[mysqld]后面任意一行添加"skip-grant-tables"用来跳过密码验证的过程
vim /etc/my.cnf
重启mysql
service mysql restart
然后登陆mysql
mysql> use mysql;
mysql> update user set password=password("你的新密码") where user="root";
mysql> flush privileges;
mysql> quit
vim /etc/my.cnf
service mysql restart
mysql> use mysql;
mysql> update user set password=password("你的新密码") where user="root";
mysql> flush privileges;
mysql> quit
本文标题:mysql 忘记密码
本文链接:https://www.haomeiwen.com/subject/tlgboctx.html
网友评论