title: Can't set root MySQL password to null
body: <p>When installing mysql, I didn't put anything in the root password fields, but when I ran <code>mysql -u root</code> I still got <code>Access denied for user 'root'@'localhost'</code>.</p>
  
  <p>I started mysql up in safe mode without the grant tables, <code>sudo mysql_safe --skip-grant-tables &amp;</code>, then jumped in with <code>mysql -u root</code> without a problem.</p>
  
  <p>Then I did <code>use mysql; update user set authentication_string=null where user='root';</code> and I got:</p>
  
  <pre><code>Query OK, 0 rows affected (0.00 sec)
  Rows matched: 1  Changed: 0  Warnings: 0
  </code></pre>
  
  <p>Anyone have any insight on why the password isn't updating?</p>