ERROR 1819 (HY000): Your password does not satisfy the current policy requirements

mysql创建用户或修改密码时报错提示

ERROR 1819 (HY000): Your password does not satisfy the current policy requirements

原因是因为密码设置的过于简单会报错,MySQL有密码设置的规范，具体是与validate_password_policy的值有关,下图表明该值规则

|Policy|Tests Performed| | ------------ | |0 or LOW|长度| |1 or MEDIUM|长度、小写/大写和特殊字符| |2 or STRONG|长度、小写/大写和特殊字符；字典文件| 查看当前密码规则

SHOW VARIABLES LIKE 'validate_password%';

+--------------------------------------+--------+
| Variable_name                        | Value  |
+--------------------------------------+--------+
| 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      |
+--------------------------------------+--------+

修改规则策略

set global validate_password_policy=0;