win10下重置MySQL8密码
- 停止mysql服务
net stop mysql
- 通过安全模式登录
cd D:\common\mysql-8.0.27-winx64\bin
mysqld --console --skip-grant-tables --shared-memory
-
打开新的CMD窗口，输入
mysql登录。 -
【忘记密码】重置密码
use mysql;
ALTER USER 'root'@'localhost' IDENTIFIED BY '新密码';
flush privileges;
- 【账号被删除】添加用户
mysql> use mysql;
Database changed
mysql> select user,host from user;
+------------------+-----------+
| user | host |
+------------------+-----------+
| root | % |
| mysql.infoschema | localhost |
| mysql.session | localhost |
| mysql.sys | localhost |
+------------------+-----------+
4 rows in set (0.00 sec)
CREATE USER 'root'@'%' IDENTIFIED BY 'password';
GRANT ALL ON *.* TO 'root'@'%';
flush privileges;
