Linux里mysql忘记密码怎么办，4条代码解决

1. 编辑文件，跳过验证

vi /etc/my.cnf

skip-grant-tables

2.重启，进入并刷新

systemctl restart mysql

flush privileges;

3.修改密码

ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';

4.删除skip-grant-tables然后重启用自定义密码进入

5.允许远程访问

 GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '远程访问的密码' WITH GRANT OPTION;
 flush privileges;