CODEWITHSUNDEEP
mysql
Ravi
Ravi

Reputation: 1784

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

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?

Upvotes: 0

Views: 85

Answers (1)

Lightness Races in Orbit
Lightness Races in Orbit

Reputation: 385174

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.

Upvotes: 3

Related Questions