title: error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near
body: <p>I ran this command :</p>
  
  <pre><code>CREATE DATABASE wordpress;
  </code></pre>
  
  <p>And I got</p>
  
  <blockquote>
    <p>Query OK, 1 row affected (0.00 sec)</p>
  </blockquote>
  
  <p>I ran the second command :</p>
  
  <pre><code>CREATE USER wordpressuser@localhost IDENTIFIED BY ‘password’;
  </code></pre>
  
  <p>And I got: </p>
  
  <blockquote>
    <p>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 '‘password’' at line 1</p>
  </blockquote>
  
  <p>What am I doing wrong? Running a freshly installed Ubuntu 14.04 Server and trying to make a database for Wordpress.</p>