先把root账户的加密规则改回去
ALTER USER 'root'@'localhost' IDENTIFIED BY 'password' PASSWORD EXPIRE NEVER;
然后使用新规则设置密码
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password'; #更新一下用户的密码
然后每次新建账户,都需要这样操作
比如新建一个test账户,密码设置为123456
ALTER USER 'test'@'%' IDENTIFIED BY 'password' PASSWORD EXPIRE NEVER;
重设密码
ALTER USER 'test'@'%' IDENTIFIED WITH mysql_native_password BY '123456';
1