title: Change mysql user password using command line
body: <p>I'm trying to update the password for a database user using the command line, and it's not working for me. This is the code I'm using:</p>
  
  <pre><code>mysql&gt; UPDATE user SET password=PASSWORD($w0rdf1sh) WHERE user='tate256';
  </code></pre>
  
  <p>Could someone tell me what's wrong with this code.</p>