MySQL8修改root密码

# 更新root用户信息，把密码设置为空字符串
UPDATE user SET authentication_string="" WHERE user="root";

ALTER USER 'root'@'%' IDENTIFIED BY '123456' PASSWORD EXPIRE NEVER;
ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';

# 刷新权限表，使密码生效
flush privileges;