title: correct syntax for setting password using mysql 5.5.8 command line
body: <p>I've just downloaded and  installed WAMPserver 2.1 and I want to set a password for the MySQL 5.5.8 database.  I'm doing a tutorial at lynda.com and the tutor (Kevin Skoglund) instructions to type:</p>
  
  <pre><code>mysql&gt; use mysql
  Database changed
  
  mysql&gt; UPDATE user
      -&gt; SET Password = PASSWORD('paSSword')
      -&gt; WHERE user = 'root';
  </code></pre>
  
  <p>When I hit enter, I get this error about the WHERE statement:</p>
  
  <pre><code>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 2
  </code></pre>
  
  <p>Does anyone know the correct syntax for the WHERE statement?  His lessons were done in 2007, so I guess the syntax has changed because it worked for him in the video.  This line was returned for him:</p>
  
  <pre><code>Query OK, 1 row affected (0.00 sec)
  Rows matched: 1 Changed: 1  Warnings: 0
  mysql&gt;
  </code></pre>
  
  <p>Thanks</p>