1.windows+r ,输入cmd回车进入命令行
2.切换到mysql的bin目录
3.使用数据库;
use mysql
直接运行4,5这两步提示密码修改成功,但是会出现无法登录MYSQL的现象,然后根据其他方法尝试第6步会报错,就尝试7,8,9发现成功修改并可以登录,故建议先尝试7,8,9,不行在回头运行4,5,6,7
4. UPDATE user SET authentication_string="123456" WHERE user="root";
6. flish privileges;
7. ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456';
(会报错)
- 先密码置空
update user set authentication_string='' where user='root';
8.刷新
flush privileges;
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456';