Mysql数据库忘记密码找回方法

最新推荐文章于 2025-04-28 23:29:51 发布

dbi8241

最新推荐文章于 2025-04-28 23:29:51 发布

阅读量161

点赞数

CC 4.0 BY-SA版权

文章标签：数据库

原文链接：http://www.cnblogs.com/HByang/p/9121091.html

本文详细介绍了一种在忘记Mysql数据库密码时的找回方法，包括停止服务、使用--skip-grant-tables参数启动以绕过权限验证、修改root用户密码及重启服务的全过程。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

Mysql数据库忘记密码找回

a 停止mysql服务

/etc/init.d/mysql stop

b 使用--skip-grant-tables启动mysql，忽略授权登录验证

mysqld_safe --skip-grant-tables --user=mysql &

mysql -u root -p ---登录时以空密码登录

c 登录mysql，修root密码

mysql

update mysql.user set password=password("123") where user='root' and host='localhost'

flush privileges;

d 关闭重启mysql

/etc/init.d/mysqld stop

/etc/init.d/mysqld start

演示

[root@db02 ~]# mysqld_safe --skip-grant-tables --user=mysql &

[1] 1390

[root@db02 ~]# 170428 23:26:25 mysqld_safe Logging to '/application/mysql-5.6.34/data/db02.err'.

170428 23:26:25 mysqld_safe Starting mysqld daemon with databases from /application/mysql-5.6.34/data


[root@db02 ~]# mysql -u root -p

Enter password:

Welcome to the MySQL monitor.  Commands end with ; or \g.

Your MySQL connection id is 1

Server version: 5.6.34 Source distribution
 

Copyright (c) 2000, 2016, 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>

mysql> update mysql.user set password=password("123")  where user='root' and host='localhost';

Query OK, 1 row affected (0.00 sec)

Rows matched: 1  Changed: 1  Warnings: 0

mysql>

mysql> flush privileges;

Query OK, 0 rows affected (0.00 sec)

mysql> quit

[root@db02 ~]# /etc/init.d/mysqld stop

[root@db02 ~]# /etc/init.d/mysqld start

[root@db02 ~]# mysql -uroot -p123

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 1

Server version: 5.6.34 Source distribution


Copyright (c) 2000, 2016, 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>