这里写自定义目录标题
修改mysql 8.0X密码
//查询所有用户
select *from mysql.user
;
//修改密码
ALTER USER ‘root’@‘%’ IDENTIFIED WITH mysql_native_password BY ‘新密码’;
//刷新修改
FLUSH PRIVILEGES;
//报错,密码强度不够
Your password does not satisfy the current policy requirements
//设置密码的强度
SHOW VARIABLES LIKE ‘validate_password%’
set global validate_password.policy=LOW;
set global validate_password.length=6;