MySQL破解root账户密码,及多实例自动部署

最新推荐文章于 2024-03-14 12:48:57 发布

「已注销」

最新推荐文章于 2024-03-14 12:48:57 发布

阅读量290

点赞数

文章标签： mysql shell

本文链接：https://blog.csdn.net/weixin_50301100/article/details/109295974

版权

本文详细介绍了如何破解MySQL的root账户密码，包括编辑配置文件、重启服务和更新用户表等步骤。同时，文章还提供了手动和自动两种方式部署MySQL多实例的方法，涉及目录创建、实例初始化、配置文件设定以及服务启动等操作。

摘要由CSDN通过智能技术生成

破解Mysql管理员账户密码

1.进入配置文件/etc/my.conf,添加skip-grant-table:

[root@server ~]# vim /etc/my.cnf

[mysqld]
basedir = /usr/local/mysql
datadir = /opt/data
socket = /tmp/mysql.sock
port = 3306
pid-file = /opt/data/mysql.pid
user = mysql
skip-name-resolve

skip-grant-tables

2.重启服务

[root@server ~]# service mysqld restart
Shutting down MySQL.... SUCCESS! 
Starting MySQL.. SUCCESS!

3.更新mysql.user表,设置user=root,并且host=localhost的记录中authentication_string的密码

mysql> update mysql.user set authentication_string = password('tjp123') where User = 'root' and Host = 'localhost';
Query OK, 1 row affected, 1 warning (0.36 sec)
Rows matched: 1  Changed: 1  Warnings: 1

4.删除配置文件中的skip-grant-tables重启服务
5.重启服务

[root@server ~]# service mysqld restart
Shutting down MySQL.... SUCCESS! 
Starting MySQL.. SUCCESS!

验证

[root@server ~]# mysql -uroot -ptjp123
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 2
Server version: 5.7.22 MySQL Community Server (GPL)

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

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other nam