1.修改 /etc/my.cnf
在[mysqld]下面加上一句:
skip-grant-tables
2.重启mysqld
/etc/init.d/mysqld restart
3.登录并修改MySQL的root密码
mysql
USE mysql;
UPDATE user SET Password = password ( 'newpassword' ) WHERE User = 'root' ;
4.从/etc/my.cnf 移除skip-grant-tables 配置
5.重启mysqld
/etc/init.d/mysqld restart
mysql root 忘记密码
最新推荐文章于 2023-10-09 17:25:55 发布