mysql8修改密码加密规则
使用root账号登录MySQL
mysql -uroot -p
给root账号赋予全部权限
grant system_user on *.* to 'root'@'%';
设置密码策略并刷新权限
set global validate_password.policy=0;
FLUSH PRIVILEGES;
更改加密方式
ALTER USER 'root'@'%' IDENTIFIED BY '{password}' PASSWORD EXPIRE NEVER;
更改密码
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '{pwd12345}';
最后刷新权限,使修改生效
FLUSH PRIVILEGES;