MySQL:Your password does not satisfy the current policy requirements

Environment:

Mysql > select version ()

+-+

| | version () |

+-+

| | 5.7.17-log |

+-+

1 row in set (0.00 sec)

Error report:

Mysql > create user repl@'192.168.100.51' identified by '123456'

ERROR 1819 (HY000): Your password does not satisfy the current policy requirements has this problem because the plug-in is installed, as follows:

Mysql > select name,dl from mysql.plugin

+-- +

| | name | dl |

+-- +

| | validate_password | validate_password.so |

+-- +

1 row in set (0.00 sec) specific rules are:

Mysql > 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 | |

+-+ +

Installation of plug-ins enabled:

1. The library object file corresponding to the plug-in needs to be in the directory specified by the configuration option plugin_dir.

two。 You can use-- plugin-load=validate_password.so to load the plug-in when server starts, or to write plugin-load=validate_password.so to the configuration file.

3. You can also load the plug-in (which will be registered in the mysql.plugins table) mysql > INSTALL PLUGIN validate_password SONAME 'validate_password.so' while server is running with the following statement

To prevent the plug-in from being deleted at run time, add it to the configuration file:

[mysqld]

Plugin-load=validate_password.so

Validate-password=FORCE_PLUS_PERMANENT

For more information:

Https://dev.mysql.com/doc/refman/5.7/en/validate-password-plugin-installation.html