报错内容
ERROR 1819 ( HY000) : Your password does not satisfy the current policy requirements
解决过程
mysql> create user test1@localhost identified by 'pwd' ;
ERROR 1819 ( HY000) : Your password does not satisfy the current policy requirements
mysql> SHOW VARIABLES LIKE 'validate_password%' ;
+--------------------------------------+--------+
| Variable_name | Value |
+--------------------------------------+--------+
| validate_password.check_user_name | ON |
| 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 |
+--------------------------------------+--------+
7 rows in set ( 0.01 sec)
set global validate_password.policy = 0 ;
set global validate_password.length = 0 ;
mysql> SHOW VARIABLES LIKE 'validate_password%' ;
+--------------------------------------+-------+
| Variable_name | Value |
+--------------------------------------+-------+
| validate_password.check_user_name | ON |
| 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 |
+--------------------------------------+-------+
7 rows in set ( 0.00 sec)
mysql> create user test1@localhost identified by 'pwd' ;
Query OK, 0 rows affected ( 0.01 sec)
关键的两句
set global validate_password.policy = 0 ;
set global validate_password.length = 0 ;