title: Reset MySQL root password using ALTER USER statement after install on Mac
body: <p>I'm new to the whole Mac experience. I recently installed MySQL and it seems I have to reset the password after install. It won't let me do anything else.</p>
  
  <p>Now I already reset the password the usual way: </p>
  
  <pre><code>update user set password = password('XXX') where user = root;
  </code></pre>
  
  <p>(BTW: took me ages to work out that MySQL for some bizarre reason has renamed the field 'password' to 'authentication_string'. I am quite upset about changes like that.)</p>
  
  <p>Unfortunately it seems I need to change the password a different way that is unknown to me. Maybe someone here has already come across that problem?</p>