MySQL5.6.6版本之后增加了密码强度验证插件validate_password,相关参数设置的较为严格。
影响的语和函数有:create user,grant,set password,password(),old password。
1、查看mysql全局参数配置
mysql> SHOW VARIABLES LIKE 'validate_password%';
+--------------------------------------+--------+
| Variable_name | Value |
+--------------------------------------+--------+
| validate_password_dictionary_file | |
| validate_password_length | 8 |
| validate_password_mixed_case_count | 1 |
| validate_password_number_count | 1 |
| validate_password_policy | MEDIUM |
| validate_password_special_char_count | 1 |
+--------------------------------------+--------+
6 rows in set (0.08 sec)
2、参数解释
validate_password_dictionary_file