1.my.cnf 添加skip-grant-tables 并重启mysqld
2.use mysql; update user set authentication_string=password(‘123456’),password_expired=‘N’ where user=‘root’;
3.或者ALTER USER testuser IDENTIFIED BY ‘123456’ PASSWORD EXPIRE NEVER;
mysql5.7.22忘记密码
最新推荐文章于 2023-09-04 13:59:10 发布