title: Can Two MySQL Password Policies Policies Cause an Error to not Satisfy the Current Policy Requirements
body: <p>I can not create users on MySQL because of an error &quot;Your Password does not satisfy the Current Policy Requirements&quot;</p>
  <p>I have run the command:
  <code>SHOW VARIABLES LIKE 'validate_password%';</code></p>
  <p>And I find there are two password policies.</p>
  <pre><code>
  +--------------------------------------+--------+
  | Variable_name                        | Value  |
  +--------------------------------------+--------+
  | 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             | LOW    |
  | validate_password_special_char_count | 1      |
  +--------------------------------------+--------+
  14 rows in set (0.00 sec)
  </code></pre>
  <p>Here is a sample string that fails:</p>
  <pre><code>CREATE USER 'support_usr'@'gk1qYu!n%';
  ALTER USER 'support_usr'@'gk1qYu!n%'
  IDENTIFIED BY 'Pxuzj#1M4!d' ;
  </code></pre>
  <p>Could this be a conflict that prevents user password creation? Is there a way to remove one or both of them?</p>