mysql忘记root密码怎么办

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

创新互联是一家专业提供常山企业网站建设,专注与成都网站设计、成都网站建设、H5开发、小程序制作等业务。10年已为常山众多企业、政府机构等服务。创新互联专业网站制作公司优惠进行中。

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密码怎么办”这篇文章对大家有帮助,同时也希望大家多多支持创新互联,关注创新互联行业资讯频道,更多相关知识等着你来学习!


本文标题:mysql忘记root密码怎么办
标题来源:http://scyanting.com/article/jjhesd.html