您的位置：宽带测速网 > mysql教程 > mysql忘记root密码怎么办

mysql忘记root密码怎么办

2025-06-24 08:09来源：互联网 [ 大 中 小 ]

1.关闭mysql 服务

点击(此处)折叠或打开

    net stop mysql57


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)

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

相关阅读