一、破解mysql数据库密码步骤
1、修改mysql配置文件/etc/my.cnf
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
|
[mysqld]
port = 3306
socket =
/tmp/mysql
.sock
skip-external-locking
key_buffer_size = 256M
max_allowed_packet = 1M
table_open_cache = 256
sort_buffer_size = 1M
read_buffer_size = 1M
read_rnd_buffer_size = 4M
myisam_sort_buffer_size = 64M
thread_cache_size = 8
query_cache_size= 16M
# Try number of CPU's*2 for thread_concurrency
thread_concurrency = 2
datadir =
/mydata/data
skip-grant-tables
#加入此项
|
2、重新启动mysqld
1
2
3
|
# /etc/init.d/mysqld restart
Stopping MySQL: [ OK ]
Starting MySQL: [ OK ]
|
3.登录并修改MySQL的root密码
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
|
# /usr/bin/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 ;
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 Password = password (
'new-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
Bye
|
5.将MySQL的登录设置修改回来
1
2
3
|
# vi /etc/my.cnf
将刚才在[mysqld]的段中加上的skip-grant-tables删除
保存并且退出
vi
。
|
6.重新启动mysqld
1
|
# /etc/init.d/mysqld restart Stopping MySQL: [ OK ] Starting MySQL: [ OK ]
|
图示:
修改如下:
重设密码:
本文转自chengong1013 51CTO博客,原文链接:http://blog.51cto.com/purify/1855250,如需转载请自行联系原作者