MySQL对设置密码进行了默认的限制(policy = 1)。
表格内容应该改成如下所示:
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 |
即MEDIUM,所以设置的密码必须符合长度(默认为 8 )要求,且必须含有数字,小写字母,大写字母和特殊字符。