title: Can't change user password on MySQL using UPDATE
body: <p>Under MySql 5.7.17 the mentioned instruction do not work and always I get no feedback or the following error message:</p>
  
  <blockquote>
    <p><strong>ERROR 1064 (42000):</strong> You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'UPDATE mysql.user SET password=password("elephant7") where user="root"' at line ...</p>
  </blockquote>
  
  <p>I tried the following <code>UPDATE</code> on the command line:</p>
  
  <pre><code>UPDATE mysql.user SET Password = PASSWORD('elephant7') WHERE User='root';
  </code></pre>
  
  <p>I really don't see anymore my mistake. I also tried without <code>;</code>.</p>