title: Can't seem to create user in MySQL console (ERROR 1064 (42000))
body: <p>Now I'm no MySQL pro, but I've been using it for a good 5-6 years and I've never come across this:</p>
  
  <ul>
  <li>I log into my server via SSH</li>
  <li>I log into MySQL via <code>mysql -u root -pSUPER_SECRET_PASSWORD</code></li>
  <li>I write: <code>CREATE USER 'magical_username'@'locahost' IDENTIFIED BY 'super_magical_password';</code></li>
  </ul>
  
  <p>Now this is where it gets weird. I expect the query to work and I can go about granting permissions, but, I get this instead:</p>
  
  <p><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 'USER 'magical_username'@'localhost' IDENTIFIED BY 'super_magical_password' at line 1</code></p>
  
  <p>Any ideas?</p>