原因
MySQL8之前和之后的加密规则不同导致;
解决(依次执行下面SQL)
- ALTER USER ‘root’@‘localhost’ IDENTIFIED BY ‘password’ PASSWORD EXPIRE NEVER; # 修改加密规则
- ALTER USER ‘root’@‘localhost’ IDENTIFIED WITH mysql_native_password BY ‘password’; # 更新用户密码
- FLUSH PRIVILEGES; # 刷新权限
- ALTER USER ‘root’@‘localhost’ IDENTIFIED BY ‘新密码’; # 重置新密码