Why Does MySQL Throw 'ERROR 1396 (HY000): Operation CREATE USER failed' and How Can I Fix It?

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

In MySQL, attempting to re-create a user that has been deleted may result in the error "ERROR 1396 (HY000): Operation CREATE USER failed." To address this issue, follow these steps:

1. Confirm User Deletion: Ensure the user ('jack' in this case) no longer exists in the mysql.user table.
2. Drop Nonexistent User: Even if the user has been deleted, issuing the command DROP USER 'jack'@'localhost' may help clear any residual references.
3. Flush Privileges: Execute the command FLUSH PRIVILEGES to refresh the security privileges. This step is crucial to ensure that any changes made to the user table take effect.
4. Recreate User: Now, attempt to recreate the user using the command CREATE USER 'jack'@'localhost' IDENTIFIED BY 'test123'. If successful, the user will be created without the error.

Example:

mysql> DROP USER 'jack'@'localhost';
Query OK, 0 rows affected (0.00 sec)

mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)

mysql> CREATE USER 'jack'@'localhost' IDENTIFIED BY 'test123';
Query OK, 0 rows affected (0.00 sec)

The above is the detailed content of Why Does MySQL Throw 'ERROR 1396 (HY000): Operation CREATE USER failed' and How Can I Fix It?. For more information, please follow other related articles on the PHP Chinese website!