title: while creating and deleting user in mysql ERROR 1396 (HY000): Operation CREATE USER
body: <p>I am trying to create new user in mysql,  </p>
  
  <pre><code>    create user 'saravanakumar'@'localhost' identified by 'saravanakumar';
  </code></pre>
  
  <p>it shows error as,</p>
  
  <pre><code>    ERROR 1396 (HY000): Operation CREATE USER failed for 'saravanakumar'@'localhost'
  </code></pre>
  
  <p>after I read this </p>
  
  <p><a href="https://stackoverflow.com/questions/5555328/error-1396-hy000-operation-create-user-failed-for-jacklocalhost">ERROR 1396 (HY000): Operation CREATE USER failed for &#39;jack&#39;@&#39;localhost&#39;</a></p>
  
  <p>I delete user.But I can't.It shows </p>
  
  <pre><code>    mysql&gt; SELECT User FROM mysql.user;
      +---------------+
      | User          |
      +---------------+
      | root          |
      | saravanakumar |
      | saravanakumar |
      |               |
      | root          |
      | saravanakumar |
      |               |
      | root          |
      +---------------+
      8 rows in set (0.00 sec)
  
      mysql&gt; FLUSH PRIVILEGES;
      Query OK, 0 rows affected (0.00 sec)
  
      mysql&gt; SELECT User FROM mysql.user;
      +---------------+
      | User          |
      +---------------+
      | root          |
      | saravanakumar |
      | saravanakumar |
      |               |
      | root          |
      | saravanakumar |
      |               |
      | root          |
      +---------------+
      8 rows in set (0.00 sec)
  </code></pre>
  
  <p>how can i delete all these user in table and how can i create a single user.What is the root cause of this problem? experts please help me.</p>