title: ERROR 1396 (HY000): Operation CREATE USER failed
body: <p>i was creating a db in mysql and ran commands-</p>
  
  <pre><code>create database projectdb;
  create user 'aquaman'@'localhost' identified by password'aquaman123';
  </code></pre>
  
  <p>and it gave error-</p>
  
  <pre><code>ERROR 1396 (HY000): Operation CREATE USER failed for 'aquaman'@'localhost' 
  </code></pre>
  
  <p>anyone please help me how to resolve it</p>