导航：首页 > 数据库 >

mysql忘记root密码怎么办

发表于：2026-11-01 作者：千家信息网编辑

千家信息网最后更新 2026年11月01日，这篇文章主要介绍了mysql忘记root密码怎么办，具有一定借鉴价值，感兴趣的朋友可以参考下，希望大家阅读完这篇文章之后大有收获，下面让小编带着大家一起了解一下。1.关闭mysql 服务点击(此处)折

千家信息网最后更新 2026年11月01日mysql忘记root密码怎么办

这篇文章主要介绍了mysql忘记root密码怎么办，具有一定借鉴价值，感兴趣的朋友可以参考下，希望大家阅读完这篇文章之后大有收获，下面让小编带着大家一起了解一下。

1.关闭mysql 服务

点击(此处)折叠或打开

2.执行mysqld

- 打开cmd窗口，切换至mysql安装目录

点击(此处)折叠或打开

cd C:\Program Files\MySQL\MySQL Server 5.7\bin
C:\Program Files\MySQL\MySQL Server 5.7\bin>mysqld --defaults-file="C:\ProgramData\MySQL\MySQL Server 5.7\my.ini" --skip-grant-tables

3.新开启cmd,登录root

-不用输入password，直接回车

C:\Program Files\MySQL\MySQL Server 5.7\bin>mysql -uroot -p
Enter password:

4.修改root密码

点击(此处)折叠或打开

mysql> use mysql;
Database changed
mysql> update mysql.user set authentication_string=password('root') where user='root' ;
Query OK, 1 row affected, 1 warning (0.01 sec)
Rows matched: 1 Changed: 1 Warnings: 1
mysql> flush privileges;
Query OK, 0 rows affected (0.02 sec)

5.使用新密码登录root

点击(此处)折叠或打开

C:\Program Files\MySQL\MySQL Server 5.7\bin>mysql -uroot -p
Enter password: ****
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 6
Server version: 5.7.19 MySQL Community Server (GPL)
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> show database;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'datab
ase' at line 1
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| fortress |
| mysql |
| performance_schema |
| python |
| stuman |
| stuman2 |
| sys |
| www |
+--------------------+
9 rows in set (0.00 sec)