title: mySQL password policy refuses all attempts to create user
body: <p>My current installation of mySQL/phpMyAdmin on my ubuntu server is refusing to allow any user to be created with any password I have tried. The error is always:</p>
  
  <p><code>ERROR 1819 (HY000): Your password does not satisfy the current policy requirements</code></p>
  
  <p>I have never had this error before with other installations of mysql, on server and xampp/localhost both. This is a new server installation however.</p>
  
  <p>For example, on the mysql terminal on the command line, any attempt to create a user (with extremely random passwords) fails</p>
  
  <pre><code>mysql&gt; CREATE USER 'ses'@'%' IDENTIFIED BY 'yIO8v3hVai0zosaD';
  ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
  mysql&gt; CREATE USER 'ses'@'%' IDENTIFIED BY 'yIO8v3hVai0zosaDyIO8v3hVai0zosaDyIO8v3hVai0zosaD';
  ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
  </code></pre>
  
  <p>Same thing with phpMyAdmin</p>
  
  <p><a href="https://i.stack.imgur.com/Pa9eW.png" rel="noreferrer"><img src="https://i.stack.imgur.com/Pa9eW.png" alt="enter image description here"></a></p>
  
  <p><a href="https://i.stack.imgur.com/lmpii.png" rel="noreferrer"><img src="https://i.stack.imgur.com/lmpii.png" alt="enter image description here"></a></p>
  
  <p>With the following error at the bottom</p>
  
  <pre><code>Warning in ./libraries/dbi/DBIMysqli.class.php#261
   mysqli_query(): (HY000/1819): Your password does not satisfy the current policy requirements
  
  Backtrace
  
  ./libraries/dbi/DBIMysqli.class.php#261: mysqli_query(
  object,
  string 'SELECT PASSWORD(\'rSxYcnCcO2fhhKgD\') AS `password`;',
  integer 0,
  )
  ./libraries/DatabaseInterface.class.php#244: PMA_DBI_Mysqli-&gt;realQuery(
  string 'SELECT PASSWORD(\'rSxYcnCcO2fhhKgD\') AS `password`;',
  object,
  integer 1,
  )
  ./libraries/DatabaseInterface.class.php#1944: PMA_DatabaseInterface-&gt;tryQuery(
  string 'SELECT PASSWORD(\'rSxYcnCcO2fhhKgD\') AS `password`;',
  object,
  integer 1,
  boolean false,
  )
  ./libraries/server_privileges.lib.php#5055: PMA_DatabaseInterface-&gt;fetchSingleRow(string 'SELECT PASSWORD(\'rSxYcnCcO2fhhKgD\') AS `password`;')
  ./libraries/server_privileges.lib.php#5179: PMA_getHashedPassword(string 'rSxYcnCcO2fhhKgD')
  ./libraries/server_privileges.lib.php#4176: PMA_getSqlQueriesForDisplayAndAddUser(
  string 'test-accountdb',
  string '%',
  string '',
  )
  ./server_privileges.php#167: PMA_addUser(
  NULL,
  string 'test-accountdb',
  string '%',
  NULL,
  boolean true,
  )
  </code></pre>
  
  <p>Edit: Added results for the mysql <code>validate_password%</code> variables</p>
  
  <pre><code>mysql&gt; SHOW VARIABLES LIKE 'validate_password%';
  +--------------------------------------+--------+
  | Variable_name                        | Value  |
  +--------------------------------------+--------+
  | 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      |
  +--------------------------------------+--------+
  </code></pre>