Linux(centos7)下忘记MySQL8密码

进入my.cnf

# vi /etc/my.cnf

在[mysql] 下添加 skip-grant-table
重启MySQL：

# systemctl restart mysqld

进入MySQL,修改密码

# mysql -u root -p
Enter password: //回车进入
mysql>use mysql;
mysql>select host,user from user;
+-----------+------------------+
| host      | user             |
+-----------+------------------+
| %         | root             |
| localhost | mysql.infoschema |
| localhost | mysql.session    |
| localhost | mysql.sys        |
+-----------+------------------+
mysql> flush privileges;
mysql> alter user 'root'@'%' IDETIFIED BY '新密码';
mysql> exit;

(密码要包含大小写、数字、特殊符号)
删除文件my.cnf中的 skip-grant-table
重启mysql服务：

# systemctl restart mysqld

之后就能用新密码登录MySQL。