1.在my.cnf里添加“skip-grant-tables”(跳过密码验证)
2.重启mysql
3.[root@localhost ~]# mysql -u root -p
mysql> use mysql;
mysql> update mysql.user set authentication_string=password('cy7m0ypu8CpLFperzI45') where user='root' and Host = 'localhost';
mysql> flush privileges;
mysql> quit
4.去掉添加的“skip-grant-tables”
5.重启mysql服务
6.用刚才的密码登录
[root@localhost ~]# mysql -u root -p
MySQL忘记密码(免密登录)
最新推荐文章于 2024-08-05 03:56:11 发布