There was a problem deleting the database
As I have many times before, I just logged in to user's cPanel to delete a no longer needed database, it seemed successful, and I removed the DB user as well.
But then the database (with no user) mysteriously came back a couple minutes later while I was working in the user's cPanel.
Tried several times to remove the "ghost" database and it just gives me this error:
There was a problem deleting the database "example_name". The system user "name" does not control a MySQL database named "example_name".
(those aren't the actual names of course)
Checked the user's phpMyAdmin from within cPanel, no database there.
Checked WHM > phpMyAdmin and the database is not there either, yet still shows in the user's cPanel.
Anyone else every run into this?
-
Just in case anyone else encounters this: I tried this on a whim and it worked - I just quickly created a new database and user via the Wizard, and the "ghost" database disappeared. I was then able to successfully delete the new database with no issue. Very odd, and has never happened in the 20~ years I've been running cPanel on my servers. 1 -
Hey there! The most likely explanation is that database was somehow disassociated with the cPanel server. It could have been created manually outside of cPanel, or there could have been an issue with the system at some point. If this happens again, I'd recommend trying the WHM >> Database Map Tool to see if you can link the existing database to the cPanel user, and then delete it through cPanel normally. 0 -
Thanks @cPRex I was so mystified by the encounter and focused on the fact that it wasn't list in WHM's phpMyAdmin I didn't even think to use the DB Map Tool. smh 0 -
It's all good - you still got there! 0 -
I just had this happen. The ghost database can't be found in the map tool or in phpmyadmin. It's some kind of cached data for a recently deleted database. I tried deleting the .cpanel directory but that didn't fix it. Adding a new database, as above, did fix it. Very strange! 0 -
@stormy - Glad my primitive improvised method worked for you. In all the 20+ years I've been handling mySQL databases with cPanel, that was the one and only time I ever encountered the issue. Strange indeed! 0 -
Hello!, here today exactly the same thing happened to me, (the first time it has happened in more than 15 years using cPanel) I also tried the basics, deleting the .cpanel folder, checking phpmyadmin and the map tool. The trick of creating a new base was the solution. I had 4 with errors, I created a new one and the ones with errors disappeared. Thanks @Metro2 0 -
Man, this brings me nuts. Thanks. Weird, as I tried to clear any cache as possible. Still just adding a new DB clear it.
0
Please sign in to leave a comment.
Comments
8 comments