ERROR 1396 (HY000): Operation CREATE USER failed for 'root'@'localhost'?

In the system, the root is defined by another name as well as password. Then the user is created as a root with the help of the create command. This will result in the ERROR 1396.

The query for this is given as follows −

mysql> create user 'root'@'localhost' identified by 'root123';

After executing the above query, the following error is obtained −

ERROR 1396 (HY000): Operation CREATE USER failed for 'root'@'localhost'

The user can be created with another name and password successfully. This is given as follows −

mysql> create user 'John'@'localhost' identified by 'john123';
Query OK, 0 rows affected (0.14 sec)

Now, the user John has been created successfully with the given password.

Ankith Reddy

Published on 18-Oct-2018 09:44:52

• Related Questions & Answers
• Solve ERROR 1396 (HY000): Operation DROP USER failed for 'user'@'localhost' in MySql?
• Resolve error 1045 (28000) access denied for user 'root'@'localhost' (using password: YES)?
• Fix: ERROR 1396 (HY000): Operation CREATE USER failed in MySQL?
• Why JavaScript 'var null' throw an error but 'var undefined' doesn't?
• Selenium WebDriver Error: AttributeError: 'list' object has no attribute 'click'
• Finding the sum of two numbers without using '+', '-', '/', '*' in JavaScript
• Resolve the MySQL error 'TYPE=MyISAM'?
• Python: Cannot understand why the error - cannot concatenate 'str' and 'int' object ?
• MySQL query to select ENUM('M', 'F') as 'Male' or 'Female'?
• Update 'a' record with 'b' and 'b' with 'a' in a MySQL column (swap) with only 'a' and 'b' values?
• What is the difference between 'throw new Error' and 'throw someObject' in javascript?
• What is difference between '.' , '?' and '*' in Python regular expression?
• Replace '*' with '^' with Java Regular Expressions
• Program to find number of string we can make where 'a' can be 'a' or 'b', and 'b' remains 'b'in Python
• HTML5 geolocation 'permission denied' error in Mobile Safari