MySQL 8.0.28 忘记密码,重置密码

use mysql;
-- 将root用户的密码置为空
update user set authentication_string = '' where user = 'root';
quit;
1
2
3
4

use mysql;
-- 查询root用户的host
select user,host from user where user = 'root';
-- 修改密码
ALTER USER 'root'@'%' IDENTIFIED BY '新密码';
-- 	刷新权限
flush privileges;
-- 退出登录
quit;
1
2
3
4
5
6
7
8
9