MySQL 忘记root密码

1. 找到mysqld_safe的启动命令，记录下来

ps aux | grep mysqld_safe

// /home/soft/mysql-5.7.25-linux-glibc2.12-x86_64/bin/mysqld_safe --datadir=/home/soft/mysql-5.7.25-linux-glibc2.12-x86_64/data --pid-file=/home/soft/mysql-5.7.25-linux-glibc2.12-x86_64/data/localhost.localdomain.pid

2. 关闭mysql服务

service mysql stop

3. 以--skip-grant-tables命令重新启动mysql

./bin/mysqld_safe --skip-grabt-tables --datadir=/home/soft/mysql-5.7.25-linux-glibc2.12-x86_64/data --pid-file=/home/soft/mysql-5.7.25-linux-glibc2.12-x86_64/data/localhost.localdomain.pid &

4. 用空密码的root连接mysql

mysql -uroot

5. 修改root密码

update user set password=password("xxx") where user=‘root‘ and host = ‘localhost‘;

6. 刷新权限表

flush privileges；

7. 手动杀掉mysql进程

ps aux | grep mysqld

kill -9 xxx 

8. 正常启动mysql

serice mysql start

MySQL 忘记root密码

原文：https://www.cnblogs.com/ghx-kevin/p/12651727.html