mysql8.0忘记密码后重置密码

1. 免密验证
   修改配置文件vim /etc/mysql/mysql.conf.d/mysqld.cnf在配置文件中添加一行skip-grant-tables
2. 重启mysql systemctl restart mysql
3. 登录mysqlmysql -u root -p，提示输入密码直接回车即可
4. 将密码清空,然后退出

   use mysql;
   update user set authentication_string = '' where user = 'root';
   quit;
   

5. 删除步骤一配置文件中添加的免密验证skip-grant-tables
6. 重启mysql systemctl restart mysql
7. 修改密码

   mysql -u root -p //提示输入密码直接回车即可
   ALTER USER 'root'@'%' IDENTIFIED BY 'mimashi123';
   flush privileges;