mysql 5.7密码安全策略问题解决

创建用户时报错：

mysql> create user 'mmuser'@'%' identified by 'mmuser-password';
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements

报错原因：密码强度不够。

解决办法

参数解释：

validate_password_dictionary_file 指定密码验证的文件路径;
validate_password_length  密码最小长度
validate_password_mixed_case_count  密码至少要包含的小写字母个数和大写字母个数;
validate_password_number_count  密码至少要包含的数字个数
validate_password_policy 密码强度检查等级，对应等级为：0/LOW、1/MEDIUM、2/STRONG,默认为1

mysql> set global validate_password_policy=0;
Query OK, 0 rows affected (0.00 sec)

mysql> set global validate_password_length=4;
Query OK, 0 rows affected (0.00 sec)

mysql> SHOW VARIABLES LIKE 'validate_password%';
+--------------------------------------+-------+
| Variable_name                        | Value |
+--------------------------------------+-------+
| validate_password_check_user_name    | OFF   |
| validate_password_dictionary_file    |       |
| validate_password_length             | 4     |
| validate_password_mixed_case_count   | 1     |
| validate_password_number_count       | 1     |
| validate_password_policy             | LOW   |
| validate_password_special_char_count | 1     |
+--------------------------------------+-------+