Windows MySQL8密码忘了解决办法

1、在windows services 中停止mysql8 服务。

2、进入mysql8 安装目录，D:\Program Files\mysql-8.0.16-winx64\bin

以免密方式启动数据库：

mysqld --console --skip-grant-tables --shared-memory

3、以免费方式登录数据库：

D:\Program Files\mysql-8.0.16-winx64\bin>mysql -udev001 -P13306

注意此行命令不能加 -p，

-P为数据库端口

4、

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.mysql> SELECT ssl_type From mysql.user Where user="dev001";
+----------+
| ssl_type |
+----------+
| X509     |
+----------+
1 row in set (0.01 sec)mysql> update user set ssl_type='' where user='dev001';
ERROR 1046 (3D000): No database selected
mysql> use mysql;
Database changed
mysql> update user set ssl_type='' where user='dev001';
Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.03 sec)mysql> ALTER USER 'dev001'@'%' IDENTIFIED BY '密码';
Query OK, 0 rows affected (0.01 sec)mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)mysql> exit
Bye

5、关闭免费登录窗口

6、启动windows service 中的mysql服务

7、使用新密码登录数据库。