title: How do I turn off the mysql password validation?
body: <p>It seems that I may have inadvertently loaded the password validation plugin in MySQL 5.7. This plugin seems to force all passwords to comply to certain rules.</p>
  
  <p>I would like to turn this off.</p>
  
  <p>I've tried changing the validate_password_length variable as suggested <a href="https://stackoverflow.com/a/34913583/2341218">here</a> to no avail.</p>
  
  <pre><code>mysql&gt; SET GLOBAL validate_password_length=4;
  Query OK, 0 rows affected (0.00 sec)
  
  mysql&gt; SET PASSWORD FOR 'app' = PASSWORD('abcd');
  ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
  </code></pre>
  
  <p>I would like to either unload the plugin or neuter it somehow.</p>