Your password does not satisfy the current policy requirements 2016-11-28 22:21

When you see "Your password does not satisfy the current policy requirements" error message that means your password is not safe. MySQL use validate_password plugin to test passwords and improve security. There are 3 levels in validate_password_policy. You can check the value of it by using following command.

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

Three levels of password checking

Policy Tests Performed
0 or LOW tests password length only. Passwords must be at least 8 characters long.
1 or MEDIUM adds the conditions that passwords must contain at least 1 numeric character, 1 lowercase character, 1 uppercase character, and 1 special (nonalphanumeric) character.
2 or STRONG adds the condition that password substrings of length 4 or longer must not match words in the dictionary file, if one has been specified.

You can use following command to change the level of password checking.

mysql> set global validate_password_policy=0;
Query OK, 0 rows affected (0.00 sec)

Remove validate_password plugin (NOT RECOMMEND)

There are many plugins in MySQL use following command to show all plugins.

mysql> SHOW PLUGINS\G
*************************** 1. row ***************************
   Name: binlog
 Status: ACTIVE
   Type: STORAGE ENGINE
Library: NULL
License: GPL
*************************** 2. row ***************************
   Name: mysql_native_password
 Status: ACTIVE
   Type: AUTHENTICATION
Library: NULL
License: GPL
*************************** 3. row ***************************
   Name: sha256_password
 Status: ACTIVE
   Type: AUTHENTICATION
Library: NULL
License: GPL

...
...
...

*************************** 45. row ***************************
   Name: validate_password
 Status: ACTIVE
   Type: VALIDATE PASSWORD
Library: validate_password.so
License: GPL
45 rows in set (0.00 sec)

If you install MySQL just for testing. You can remove validate_password plugin by using following command.

mysql> uninstall plugin validate_password;
Query OK, 0 rows affected (0.02 sec)