mysql8.0 忘记密码如何重置 修改密码

vim /etc/my.cnf

在配置文件中新增一行代码，作用是登录mysql时跳过验证

[mysqld]
...
skip-grant-tables

启动mysql进入mysql

service mysqld start #启动mysql
mysql -u root #进入mysql

输入下列语句即可修改，先重置密码再更改密码

use mysql;  
update user set authentication_string='' where user='root';
flush privileges;
ALTER user 'root'@'localhost' IDENTIFIED BY 'root';