PhotoDateChanger
Easily change the dates and times on your photos and videos
Click here for more info about the app
VocabReminder
English dictionary with notifications so you won't forget what you're studying!
Click here for more info about the app
VocabQuiz
The app that quizzes and scores you on your vocabulary!
Click here for more info about the app

How to Resolve ERROR 1396 (HY000): Operation CREATE USER failed for Error in MySQL

       

If you run into this error when trying to create a user in mysql, chances are you already have this user account created.

create user 'someuser'@'localhost' identified by 'somepassword';
ERROR 1396 (HY000): Operation CREATE USER failed for 'someuser'@'localhost'

To see all users in your mysql database type:

select user from mysql.user;

+-----------+
| user      |
+-----------+
| mysql.sys |
| root      |
+-----------+

You may can add privileges to a user with the following

grant all privileges on *.* to 'someuser'@'localhost' with grant option;

Or you can drop the user completely with the following

drop user someuser;
flush privileges;

You also may want to restart mysql if the changes do not take place (from the command line not mysql prompt)

mysql.server stop
mysql.server start
Tagged w/ #mysql #databases #troubleshooting #admin