I try to Set policy level to low.

mysql>  SHOW VARIABLES LIKE 'validate_password%';

+-------------------------------------------------+--------+

| Variable_name                                   | Value  |

+-------------------------------------------------+--------+

| validate_password.changed_characters_percentage | 0      |

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

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

+-------------------------------------------------+--------+

15 rows in set (0.01 sec)

and set

mysql> SET GLOBAL validate_password_policy=LOW;

and check password validation policy level with , the policy level is chang to low:

$ SHOW VARIABLES LIKE 'validate_password%';

and restart mysql , but when i change user password ,still get the error message as below

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

then i found policy level not change to LOW

I have tried changing the policy to LOW but that also didn’t help.