title: How to change mySQL root password in MAMP
body: <p>I installed mySQL a while back but have now installed MAMP which also includes mySQL. I want to change the root user password in this new mySQL instance but I can't get this to work:</p>
  
  <pre><code>mysqladmin -u root -p --port=8889 --protocol=TCP password myNewPassword
  </code></pre>
  
  <p>(I have to use the port # and TCP protocol, otherwise it just tries to connect to my older mySQL instance)</p>
  
  <p>The error I get is:</p>
  
  <blockquote>
    <p>mysqladmin: [Warning] Using a password on the command line interface can be insecure.
    Warning: Since password will be sent to server in plain text, use ssl connection to ensure password safety.
    mysqladmin: unable to change password; error: '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 '() IDENTIFIED BY 'myNewPassword'' at line 1'</p>
  </blockquote>
  
  <p>What am I doing wrong?</p>