title: ERROR 1064 (42000): You have an error in your SQL syntax; Want to configure a password as root being the user
body: <p>I have just downloaded WAMP. I want to configure a password for the MySQL root user using MySQL console. No password has been set previously.</p>
  
  <p>The following is the input</p>
  
  <pre><code>    mysql-&gt; use mysql
      Database changed
      mysql-&gt; UPDATE user
           -&gt; SET Password=PASSWORD&lt;'elephant7'&gt;
           -&gt; WHERE user='root';
  </code></pre>
  
  <blockquote>
    <p>ERROR 1064 (42000): 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  'WHERE user='root'' at line 3</p>
  </blockquote>