MySQL8.0.16 忘记密码解决方法

1. 按下 【ctrl+alt+delete】打开任务管理器，停止MySQL服务
   

2. 使用管理员权限打开命令行窗口A，进入数据库的bin目录，然后输入以下命令：

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

D:\MySQL8\mysql-8.0.16-winx64\bin>mysqld.exe --console --skip-grant-tables --shared-memory
2022-01-26T11:50:12.302060Z 0 [System] [MY-010116] [Server] D:\MySQL8\mysql-8.0.16-winx64\bin\mysqld.exe (mysqld 8.0.16) starting as process 2300
2022-01-26T11:50:18.245586Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2022-01-26T11:50:18.325116Z 0 [System] [MY-010931] [Server] D:\MySQL8\mysql-8.0.16-winx64\bin\mysqld.exe: ready for connections. Version: '8.0.16'  socket: ''  port: 0  MySQL Community Server - GPL.
2022-01-26T11:50:18.526859Z 0 [Warning] [MY-011311] [Server] Plugin mysqlx reported: 'All I/O interfaces are disabled, X Protocol won't be accessible'

3. 使用管理员权限打开命令行窗口B，然后输入以下命令行：

mysql -uroot

C:\Users\user>mysql -uroot
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 7
Server version: 8.0.16 MySQL Community Server - GPL

Copyright (c) 2000, 2019, 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.

4. 在命令行窗口B，开始重置密码

ALTER USER 'root'@'localhost' IDENTIFIED BY '新密码'; 
flush privileges;