How to delete database in phpmyadmin?

Hey there,

I'm trying to delete a database just typing in "Drop database <dbname>" but it keeps telling me that "Drop database" statements are disabled. And I cant find anything where I can enable it.

Can anyone help me with this because I'm new at this.

 

cpanel>mysql databases>choose ur database>press on delete good luck

 

I wish it was that simple. There is no button which would say like delete/disable or anything like that.

 

could you provide me your skype?

 

Select the database on the left hand side, then look towards the centre of the page where you will see Import/Export etc... You will see delete.

WebDev

 

If none of the above solutions work, sounds like you don't have any permission to delete/drop databases and you may need to contact your web host regarding the error.

 

You definitely need to login as Administrator in MyPhpAdmin in order to drop the database. You can check with your hosting provider with regards to this matter. If you are using sharing hosting, it will be likely that you will not be given the permission to carry out this task. They will be able to assist you though.

 

I think I will have to contact them its just that it takes time for them to respond.

Thanks

 

First option
control panel ->mysql databases>choose Your database>press on delete

@nd option

use command
delete databasename;

 

I have the same problem too, before this I always worked my way through control panel,
now I see I have 2 deleted before by control panel databases on phpMyAdmin!

 

Was also running into this issue on a MAMP setup, but managed to fix it by selecting the database in the sidebar menu then going to the Operations tab, here you will find an option to Drop the database. All the other fixes I read didn't work for me, there was no delete option and the drop DATABASE request led to disabled statement. Going thru Operations fixed it!

 

You have to be logged in as an administrator (not a user) to drop a database.

 

As a user you can only empty the database. But this should be enough to restart a Setup.
Just navigate into your database, check all tables (you can do this by the "check all" tables on the end of the page) and delete them.

 

If your host using cpanel, you can delete from mysql databases group.

You'll find your db list and delete button.

 

if you want delet database so use this step mysql >databases>choose ur database>press on delete

 

I had this problem. It's a language issue, not computer settings. The geniuses who made phpmyadmin thought that putting a button called 'drop' right next to the DB names would be painfully obvious. But they were blissfully unaware that anyone not familiar with DB-speak would not recognise this as being the same as 'delete'.

So there you are - tick your database then click 'drop'. The console will then ask if you're sure you want to DELETE that database...

 

The answer is to use the MySQL Console and issue the command "drop DATABASE <databasename>;" (without the quotes)

 

So, Just had this issue myself. -- DROP DATABASE sql wasn't working at all, even after changing the config file.

So. If you click on the database you want to DELETE. Then, click on the operation tab. In there you will find, highlighted in RED, 'drop the database (DROP)'

PO, Matt.

 

With query you can use the following syntax..

$result=mysql_query($query="DROP database database_name");

Code (markup):

Run this result, You must find your answer.

 

If you go to cpanel, MySQL Databases, Scroll down until you see your database, On the right, 'Actions' / Delete (Should delete the database).

Best Regards
J