Error creating the database, That user already Exists

IT_Architect

Verified User
Joined
Feb 27, 2006
Messages
1,088
I deleted a database like I've done many times before. When I went to recreate it, I received the following error:

Error creating the database
Details
That user already Exists

I logged in root to MySQL and did:
drop user username;
FLUSH PRIVILEGES ;

I still have the same problem. This must be a control panel problem. Any ideas?
 
Problem Solved:
I queried the round cube and every other database and table that made sense while looking for the user. The user wasn't there. I decided that logic had reached the end of its rope and did a server reboot. Problem solved. I easily added the database and user after that.

I don't know where DA is looking when it returns that error, but it must be an out-of-date memory location.

Environment:
DirectAdmin new install
FreeBSD 6.2, quad, 4 gigs.
MySQL MySQL 5.0.45

Thanks!
 
Back
Top