Cannot drop mysql database

[pvirzi]

Hi there,

in my free hosting account I've got 2 mysql dbs and i need to drop one of them

as far as i understand, in order to drop a db i need to go through cpanel-->mysql databases and from there delete the db

i tried this many times but couldn't get any result, cpanel just tells me that the db has been dropped but it hasn't

could you please help me?

thanks for your help

bye

Peppe

 

[ChatIndia]

Okay, step by step
Step1: Login to your control panel.
Step2: Click on MySQL database
Step3: Delete the databaase

Click on Home and see for the no of database used. I'm sure it is reduced by one. If you still see the database but your number is reduced then you don't have to worry. What's the problem there?

 

[pvirzi]

nope, tried many times, the sql databases counter in the cpanel home is still telling me there are 2 out of 3 possible dbs...

i know this sound silly, and i've been using cpanels long enough, but it just won't drop...

...

the ghost of my old db is haunting me :biggrin:

 

[ChatIndia]

okay, try this, remove all users from the database and then try to delete it.
Edit:
and think carefully before deleting it, the ghost of your old database may try to take revenge from you.

 

[pvirzi]

same result, i've deleted the users some 2 weeks ago, the db is not usable as there is no user assigned...it just sits there... watching me

 

[ChatIndia]

be online, I'm trying to find any alternate for it.
Edit:
use phpmyadmin to delete your database

 

[pvirzi]

From the SQL statement window.....

I got a nice big alert window telling me that

"DROP DATABASE" statements are disabled."

And so the journey of the ghost database continues...

:biggrin:

@snshusat: thanks for your help anyway, tried many ways...no way of getting rid of it

 

[ChatIndia]

Okay, give all the privileges to yourself and then try.
Edit:
chucked up the sponge. But at least you can give me reputation for my try.

 

[scylla]

why don't you just login to phpmyadmin & drop all of the tables for that database? Then you can reuse that same database for whatever project you need it for.

 

[ChatIndia]

Scylla. You gave an excellent solution for this problem.