vim /etc/my.cnf
在[mysqld]后面任意一行添加“skip-grant-tables”
service mysqld restart
mysql
flush privileges;
grant all privileges on . to [email protected]’%’ identified by ‘123456’ with grant option;
quit;
service mysqld restart
or
mysql> use mysql;
mysql> update user set password=password(“你的新密码”) where user=“root”;
mysql> flush privileges;
mysql> quit
最后
去掉刚才添加的内容
skip-grant-tables
更多内容请见原文,原文转载自:https://blog.csdn.net/weixin_44519496/article/details/120181993