mysql忘记密码

1.停止mysql服务

net stop mysql

2.打开cmd命令窗口输入mysqld --skip-grant-tables，注意这个cmd命令窗口不要关闭

3.重新打开一个cmd窗口，运行下面命令

C:\Users\Administrator>mysql

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

Your MySQL connection id is 4

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> use mysql

Database changed

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

Query OK, 0 rows affected, 1 warning (0.06 sec)

Rows matched: 1  Changed: 0  Warnings: 1