mysql修改密码Your password does not satisfy the current policy requirements

时间:2022-05-22 13:31:38

出现这个问题的原因是:密码过于简单。刚安装的mysql的密码默认强度是最高的,如果想要设置简单的密码就要修改validate_password_policy的值,

validate_password_policy有以下取值:

Policy Tests Performed
0 or LOW Length
1 or MEDIUM Length; numeric, lowercase/uppercase, and special characters
2 or STRONG Length; numeric, lowercase/uppercase, and special characters; dictionary file

如果要修改这个值,

1、先登入到mysql

mysql修改密码Your password does not satisfy the current policy requirements

2、设置安全级别

mysql修改密码Your password does not satisfy the current policy requirements

3、默认密码长度为8,可以设置为其它值,最小4位

mysql修改密码Your password does not satisfy the current policy requirements

4、设置新密码,刚安装完的mysql必须设置新密码(应该是从5.5版本开始)

mysql修改密码Your password does not satisfy the current policy requirements