Note Code : 1973 Can't create user 'user'@'localhost'; it already exists, Mysql

Question

once I created a user named 'dscl' and deleted afer few days. Now when I am trying to create a user named 'dscl'it is showing me an error message as below.

Note Code : 1973 Can't create user 'dscl'@'localhost'; it already exists

I executed a query (select * from mysql.user;) to check user list and it is not showing any user named 'dscl'.

What could be the cause?

What's to explain? If you want to know more about what `FLUSH PRIVILEGES` does, simply look it up in the MySQL manual. — Lightness Races in Orbit, Jun 14 '16 at 11:53
similar http://stackoverflow.com/questions/5555328/error-1396-hy000-operation-create-user-failed-for-jacklocalhost?rq=1 — dav, Jun 14 '16 at 11:54

score 3 · Accepted Answer · answered Jun 14 '16 at 11:52

3

Did you forget to FLUSH PRIVILEGES after altering the grant table?

You should do so now, so that the change (deleting dscl) is loaded into the server's memory.

Re-adding the user should then work.

answered Jun 14 '16 at 11:52

Lightness Races in Orbit

378,754
76
643
1,055

Note Code : 1973 Can't create user 'user'@'localhost'; it already exists, Mysql

1 Answers1