MySQL5.6.6版本之后增加了密码强度验证插件validate_password,相关的密码规则查询方法:
mysql> show variables like "%password%";
+---------------------------------------+--------+
| Variable_name | Value |
+---------------------------------------+--------+
| default_password_lifetime | 0 |
| disconnect_on_expired_password | ON |
| log_builtin_as_identified_by_password | OFF |
| mysql_native_password_proxy_users | OFF |
| old_passwords | 0 |
| report_password | |
| sha256_password_proxy_users | OFF |
| validate_password_check_user_name | OFF |
| 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 |
+---------------------------------------+--------+
14 rows in set (0.00 sec)
mysql>
参数说明:
validate_password_length: 最小长度8位
validate_password_mixed_case_count: 至少要包含的大写字母数和小写字母数,都是1
validate_password_number_count:至少要包含的数字个数,1
validate_password_special_char_count : 至少要包含的特殊字符个数,1
validate_password_policy:密码强度检查等级,0/LOW,1/MEDIUM(默认值),2/STRONG