MySQL:Your password does not satisfy the current policy requirements

1. mysql> select version();
   
2. +------------+
   
3. | version() |
   
4. +------------+
   
5. | 5.7.17-log |
   
6. +------------+
   
7. 1 row in set (0.00 sec)
   

1. mysql> create user repl@'192.168.100.51' identified by '123456';
   
2. ERROR 1819 (HY000): Your password does not satisfy the current policy requirements

1. mysql> select name,dl from mysql.plugin;
   
2. +-------------------+----------------------+
   
3. | name | dl |
   
4. +-------------------+----------------------+
   
5. | validate_password | validate_password.so |
   
6. +-------------------+----------------------+
   
7. 1 row in set (0.00 sec)

1. mysql> SHOW VARIABLES LIKE 'validate_password%';
   
2. +--------------------------------------+--------+
   
3. | Variable_name | Value |
   
4. +--------------------------------------+--------+
   
5. | validate_password_check_user_name | OFF |
   
6. | validate_password_dictionary_file | |
   
7. | validate_password_length | 8 |
   
8. | validate_password_mixed_case_count | 1 |
   
9. | validate_password_number_count | 1 |
   
10. | validate_password_policy | MEDIUM |
    
11. | validate_password_special_char_count | 1 |
    
12. +--------------------------------------+--------+

1.插件对应的库对象文件需在配置选项plugin_dir指定的目录中。

2.可使用--plugin-load=validate_password.so在server启动时载入插件，或者将plugin-load=validate_password.so写入配置文件。

3.也可以通过如下语句在server运行时载入插件（会注册进mysql.plugins表）mysql> INSTALL PLUGIN validate_password SONAME 'validate_password.so';