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

 

mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY '111';    
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements

 

原因是因为MySQL有密码设置的规范，具体是与validate_password_policy的值有关：

 

  MySQL完整的初始密码规则可以通过如下命令查看：

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     |
+--------------------------------------+-------+
7 rows in set (0.01 sec)

 

解决方法：

mysql> set global validate_password_policy=0;
mysql> set global validate_password_length=1;

这样就可以设置简单的密码了。

 

 

参考：

https://www.cnblogs.com/nicknailo/articles/8563737.html