MySQL密码破解

修改配置文件
添加skip-grant-tables(跳过权限验证)

[root@host mysql-data]# vim /etc/my.cnf
[root@host mysql-data]# cat /etc/my.cnf
[mysqld]
datadir = /opt/mysql-data
basedir = /usr/local/mysql
datadir = /opt/mysql-data
socket = /tmp/mysql.sock
port = 3306
pid-file = /opt/mysql-data/mysql.pid
user = mysql
skip-name-resolve
server-id=1
log-bin=mysql_bin
skip-grant-tables

• 重启服务

[root@host mysql-data]# service mysqld restart

进入mysql进行修改密码
注意:这里修改的是mysql.user表中的authentication_string字段，老版本还需要修改password字段

[root@host mysql-data]# mysql
mysql> use mysql;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> update user set authentication_string = password('xialuo321!') where User = 'root' and Host = 'localhost';
Query OK, 1 row affected, 1 warning (0.01 sec)
Rows matched: 1  Changed: 1  Warnings: 1

再次修改配置文件
删除skip-grant-tables

[root@host mysql-data]# vim /etc/my.cnf
[root@host mysql-data]# cat /etc/my.cnf
[mysqld]
datadir = /opt/mysql-data
basedir = /usr/local/mysql
datadir = /opt/mysql-data
socket = /tmp/mysql.sock
port = 3306
pid-file = /opt/mysql-data/mysql.pid
user = mysql
skip-name-resolve
server-id=1
log-bin=mysql_bin

• 重启服务

[root@host mysql-data]# service mysqld restart
Shutting down MySQL.. SUCCESS! 
Starting MySQL. SUCCESS! 

• 进入mysql

[root@host mysql-data]# mysql -uroot -pxialuo321!
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.33-log 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>