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密碼怎么辦”這篇文章對大家有幫助，同時也希望大家多多支持億速云，關注億速云行業資訊頻道，更多相關知識等著你來學習!