mysql忘记root密码怎么办

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

1.关闭mysql 服务

点击(此处)折叠或打开

1. net stop mysql57

2.执行mysqld

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

点击(此处)折叠或打开

1. cd C:\Program Files\MySQL\MySQL Server 5.7\bin

2. 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密码

点击(此处)折叠或打开

1. mysql> use mysql;

2. Database changed

3. mysql> update mysql.user set authentication_string=password('root') where user='root' ;

4. Query OK, 1 row affected, 1 warning (0.01 sec)

5. Rows matched: 1  Changed: 1  Warnings: 1

6. mysql> flush privileges;

7. Query OK, 0 rows affected (0.02 sec)

5.使用新密码登录root

点击(此处)折叠或打开

1. C:\Program Files\MySQL\MySQL Server 5.7\bin>mysql -uroot -p

2. Enter password: ****

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

4. Your MySQL connection id is 6

5. Server version: 5.7.19 MySQL Community Server (GPL)

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

7. Oracle is a registered trademark of Oracle Corporation and/or its

8. affiliates. Other names may be trademarks of their respective

9. owners.

10. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

11. mysql> show database;

12. ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that

13. corresponds to your MySQL server version for the right syntax to use near 'datab

14. ase' at line 1

15. mysql> show databases;

16. +--------------------+

17. | Database           |

18. +--------------------+

19. | information_schema |

20. | fortress           |

21. | mysql              |

22. | performance_schema |

23. | python             |

24. | stuman             |

25. | stuman2            |

26. | sys                |

27. | www                |

28. +--------------------+

29. 9 rows in set (0.00 sec)

感谢你能够认真阅读完这篇文章，希望小编分享的“mysql忘记root密码怎么办”这篇文章对大家有帮助，同时也希望大家多多支持亿速云，关注亿速云行业资讯频道，更多相关知识等着你来学习!