title: MySQL Errors - You must SET PASSWORD/Password hash should be a 41-digit hexadecimal number
body: <p>All, this is probably a simple fix but I can't seem to get it working... </p>
  
  <p>I'm trying to set up a MySQL database (on RHEL) but getting the following errors:</p>
  
  <pre><code>mysql&gt; SELECT 1;
  ERROR 1820 (HY000): You must SET PASSWORD before executing this statement
  mysql&gt; SET PASSWORD = PASSWORD('new_pass');
  ERROR 1372 (HY000): Password hash should be a 41-digit hexadecimal number
  mysql&gt; SELECT PASSWORD('new_pass');
  ERROR 1820 (HY000): You must SET PASSWORD before executing this statement
  </code></pre>
  
  <p>I've tried every possible command/query and I cannot bypass these two error messages. Maybe something's up with my permissions? Any thoughts? Thanks!</p>