centos mysql 5.7+ 忘记密码

1. 停止mysqld 进程:

systemctl stop mysqld

2. 修改mysqld 运行环境参数，跳过密码输入环节:

systemctl set-environment MYSQLD_OPTS=“–skip-grant-tables”

3. 启动mtsqld 进程:

systemctl start mysqld

4. root 免密登录:

mysql -u root

5. 重置密码:
   方式一、

mysql> UPDATE mysql.user SET authentication_string = PASSWORD('MyNewPassword')  WHERE User = 'root' AND Host = 'localhost';
mysql> FLUSH PRIVILEGES;
mysql> quit

方式二、

mysql> use mysql;
mysql> update user set host ='localhost' where user = 'root';
mysql> flush privileges;
mysql> exit

6. 停止mysqld进程:

systemctl stop mysqld

7. 取消mysqld免密登录相关参数:

systemctl unset-environment MYSQLD_OPTS

8. 启动mysqld进程:

systemctl start mysqld

9. 尝试用新设置的密码登录:

mysql -u root -p