MySQL数据库忘记密码解决办法

SofM 2019-12-31 14:54:34

1、停止mysql服务

systemctl stop mysqld

2、修改配置文件/etc/my.cnf

在[mysqld]下添加skip-grant-tables

3、启动Mysql

systemctl start mysqld

4、修改密码

[root@localhost ~]# mysql

Welcome to the MySQL monitor. Commands end with ; or \g.

Your MySQL connection id is 3 to server version: 3.23.56

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> use mysql ;

Database changed

mysql> update user set password = password ( '新密码' ) where user = 'root' ;

Query OK, 0 rows affected (0.00 sec)

Rows matched: 2 Changed: 0 Warnings: 0

mysql> flush privileges ;

Query OK, 0 rows affected (0.01 sec)

mysql> quit

5、将/etc/my.cnf改回配置，重启服务

systemctl restart mysqld