title: mysql CREATE USER
body: <p>I am logged into mysql...</p>
  
  <pre><code>mysql -u root -pmypass
  </code></pre>
  
  <p>And I have run the following command to remove the database user which worked succesfully</p>
  
  <pre><code>mysql&gt; FLUSH PRIVILEGES; DROP USER 'myuser_shop';
  </code></pre>
  
  <p>I can then add user successfully using the following command, again this works successfully</p>
  
  <pre><code>mysql&gt; FLUSH PRIVILEGES; CREATE USER 'myuser_shop' IDENTIFIED BY 'mypass';
  </code></pre>
  
  <p>The above command create a user with the host as a wildcard (%) The issue I am having is if I was to create a user with the host being say localhost or an external IP i get the following error:</p>
  
  <pre><code>mysql&gt; FLUSH PRIVILEGES; DROP USER 'myuser_shop';
  mysql&gt; FLUSH PRIVILEGES; CREATE USER 'myuser_shop'@'localhost' IDENTIFIED BY 'mypass';
  
  Query OK, 0 rows affected (0.00 sec)
  
  ERROR 1396 (HY000): Operation CREATE USER failed for 'myuser_shop'@'localhost'
  </code></pre>
  
  <p>Any suggestions?</p>
  
  <p>Thanks in advance</p>