CentOS 7下MySQL5.7root密码破解

配置过程

[root@localhost ~]# vi /etc/my.cnf   编辑配置文件添加如下一句话即可
skip-grant-tables   #跳过数据库权限认证 

重启数据库
[root@localhost ~]# systemctl restart mysqld 

使用任意账号和密码登陆MySQL数据库
[root@localhost ~]# mysql -uroot -p123
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.7.35 MySQL Community Server (GPL)

Copyright (c) 2000, 2021, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> 

然后修改root的密码（版本不同，要求的密码复杂度也不同）
mysql> use mysql;
mysql> update user set authentication_string=password('USERqwe123!@#') where user='root';
authentication_string 字段存放的是用户的密码信息
mysql> flush privileges ;
mysql> quit

把刚刚添加到配置文件里面那一条删除然后重启数据库
[root@localhost ~]# vi /etc/my.cnf
#skip-grant-tables
[root@localhost ~]# systemctl restart mysqld 

登陆测试
[root@localhost ~]# mysql -uroot -p 
Enter password: USERqwe123!@#
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.7.35 MySQL Community Server (GPL)

Copyright (c) 2000, 2021, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> 

登陆成功