How to create a six character password in MySQL 5.7
<p>I need to create a user with a six character password in new MySQL on my mac. I know that the lowest setting in 5.7 will allows only eight characters. Is there any way to go around that?</p>

<p>I type in <code>CREATE USER 'newsier'@'localhost' IDENTIFIED BY 'special'</code></p>

<p>It outputs the error </p>

<pre><code>ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
</code></pre>