title: MySQL ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version
body: <p>When I tried to grant privileges on users at mySQL, the error happened.Am I type something wrong on the command line?</p>
  
  <p>mySQL Ver 8.0.16 for macos10.14 on x86_64 (MySQL Community Server - GPL).</p>
  
  <pre class="lang-sql prettyprint-override"><code>mysql&gt;grant all privileges on librarydb.* to 'phill'@'%' identified by '123456';
  </code></pre>
  
  <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 
  'identified by '123456'' at line 1.
  </code></pre>