MySQL密码破解

第1步：停止MySQL进程的运行

[root@mysql-2 mysql]# service mysqld stop
Shutting down MySQL.. SUCCESS! 

第2步：修改配置文件

[root@mysql mysql]# vim /etc/my.cnf
[mysqld]
user=mysql     #指定启动MySQL进程的用户
skip-grant-tables  #跳过密码验证

在其中插入这两条

第3步：启动MySQL进程

[root@mysql mysql]# service mysqld restart  启动MySQL进程
Starting MySQL. SUCCESS! 

第4步：登录MySQL，不接密码

[root@mysql-2 mysql]# mysql  -uroot -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.7.25 Source distribution

Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.

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.

第5步：刷新权限

mysql> flush privileges; 
Query OK, 0 rows affected (0.01 sec)

刷新权限（会加载原来没有加载的权限表–>用户名和密码所在的表user等）

第6步：修改密码

mysql> set password for 'root'@'localhost' = 'Sanchuang1234#';
Query OK, 0 rows affected (0.00 sec) 

修改密码，指定用户名为root@localhost
也可以用alter命令修改

root@(none) 10:35  scmysql>alter user  'root'@'localhost'  identified by 'Sanchuang123#';
Query OK, 0 rows affected (0.00 sec)

第7步：重新修改mysql的配置文件

[root@mysql mysql]# vim /etc/my.cnf
[mysqld]
socket=/data/mysql/mysql.sock
#user=mysql    -->注释掉
#skip-grant-tables     -->注释掉

第8步：刷新服务

[root@mysql-2 mysql]# service mysqld restart  #重新刷新服务
Shutting down MySQL.. SUCCESS! 
Starting MySQL. SUCCESS! 

第9步：验证修改密码是否成功

[root@mysql-2 mysql]# mysql  -uroot -p'Sanchuang1234#'
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.25 Source distribution

Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.

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>