is drop database syntax denied?

[khairul]

If drop database syntax is denied, then how do we remove the database?

 

[Gouri]

If drop database syntax is denied, then how do we remove the database?

Goto the Cpanel and click on MySql Databases and then delete the database.

 

[khairul]

Did that too, but..

1. cpanel confirm deleted.

2. but database is not deleted.

 

[Gouri]

Did that too, but..

1. cpanel confirm deleted.

2. but database is not deleted.

Can you check whether the database is still available in your phpmyadmin?

 

[khairul]

Yes, phpadmin confirms the availability.

Nothing's changed.

Everything still intact, after deleting via cpanel.

via sql in phpadmin, drop database syntax is denied.

 

[Gouri]

Yes, phpadmin confirms the availability.

Nothing's changed.

Everything still intact, after deleting via cpanel.

via sql in phpadmin, drop database syntax is denied.

Can you tell us what exactly the error you are getting when you give the drop database command?

 

[khairul]

Under phpmyadmin, sql tab, after doing the drop database mydatabase1 command,
i get a pop-up message, saying,

"DROP DATABASE" statements are disabled.

 

[Gouri]

Under phpmyadmin, sql tab, after doing the drop database mydatabase1 command,
i get a pop-up message, saying,

"DROP DATABASE" statements are disabled.

How many databases you have and which one you want to drop?

 

[khairul]

i have 2. and i only want to drop 1. do you even have access to drop people's databases?

 

[Gouri]

i have 2. and i only want to drop 1. do you even have access to drop people's databases?

No, I don't have access to server but I can forward this thread to staff so they can resolve the issue.

 

[khairul]

i want to actually drop one database, but in the mean time,
i can do with dropping all the tables in the database and reconstructing the tables.
but it would really be helpful if we could drop the database ourselves, as it's not really efficient to make a request via forums everytime i need to delete a database or two. It would really help if they would re-enable the drop database syntax. Thanks.

 

[descalzo]

Try using MySQL Databases in cPanel instead.

 

[Anna]

Databases has to be created, and deleted from cPanel.
Doing it in phpMyAdmin will not be enabled, it is a limitation required by cPanel, to keep track of number of databases.

If you don't see it in the list of databases in cPanel, you will need to tell us which database you want removed.

When the answer is given, thread should be escalated.