phpmyadmin enable drop database statement

Question

I was alerted by my hosting provider that I exceed my 1000 table limit. I have a lot of databases and would like to delete more at once. Unfortunaltley they don't have a multiselect feature so I decided to use a query in phpmyadmin.

When I try something like DROP database some_name I get DROP DATABASE statements are disables

Does anyone know if it's possible to enable them or a different way to delete multiple databases?

score 47 · Accepted Answer · edited Jun 20 '20 at 09:12

47

It looks like there is a phpMyAdmin setting that you need to edit in config.inc.php.

boolean $cfg['AllowUserDropDatabase'] (line 503)

show a 'Drop database' link to normal users

edited Jun 20 '20 at 09:12

Community

1
1

answered Dec 10 '10 at 15:59

Pekka

442,112
142
972
1,088

2

For those interested, I've also submitted a phpMyAdmin config Gist on for those guys who're using the default Apache/PHP setup on a Mac: http://tekkie.flashbit.net/php/phpmyadmin-configuration-for-mac-os-x-bundled-php-and-apache – Ain Tohvri Jul 21 '12 at 13:58
@Pekka , your link does not seem to be working. Please check. – faheem khan Mar 14 '13 at 08:43
Edited to fix the dead link – Maurice Apr 01 '13 at 11:00
there are three config.inc.php files , /var/lib/phpmyadmin/config.inc.php, /usr/share/phpmyadmin/setup/frames/config.inc.php , /etc/phpmyadmin/config.inc.php. which one should i modify? – isnvi23h4 Sep 23 '15 at 15:42
@FFgTYnh I don't know - depends on your server settings. I'd simply try and revert until one works – Pekka Sep 23 '15 at 18:15
Where is `config.inc.php` located in XAMPP? – Razvan Zamfir Sep 24 '20 at 10:24

score 38 · Answer 2 · edited Jul 09 '13 at 11:52

38

Yes, you can do it with the following steps:

Go to wamp/apps/phpmyadmin3.5.1/libraries
Open the file called "config.default.php"
Go to line 653 and change $cfg['AllowUserDropDatabase'] = false; to true
Restart the server to see the changes

For Windows XP users: if the effect is not reflected, exit WAMP through the quick launch icon and try restarting it.

edited Jul 09 '13 at 11:52

Konstantin Oznobihin

5,234
24
31

answered Feb 20 '13 at 17:54

@Sachin For windows 8 also exiting wamp and restarting worked for me. Thanks – Mukesh Feb 26 '14 at 05:53
Tnx much, this helped also with xampp – Jiro Matchonson Feb 26 '21 at 14:28
for xampp 8.0 its on line 770 – Godwin Mar 30 '21 at 13:01

Matija · Answer 3 · 2022-03-08T15:18:24.857

16

Go to -> your_drive/xampp/PhpMyAdmin/libraries/ (Windows with XAMPP)

or

/usr/share/phpmyadmin/libraries/ (Linux with PHP/Apache/MySQL/PhpMyAdmin)

Open a file name config.default.php
Find $cfg['AllowUserDropDatabase']
You will find the value is False. Change it to True.
Linux restart apache2 in terminal /etc/init.d/apache2 restart (Linux) or XAMPP Control Panel restart Mysql

edited Mar 08 '22 at 15:18

answered Jan 27 '13 at 19:34

Matija

17,604
2
48
43

Thanks for mentioning the absolute path because I can find two `config.[inc/default].php` :) – mr5 May 06 '14 at 06:28
Thanks Man for your Detail explanation – MindCoder Mar 06 '22 at 05:47

score 13 · Answer 4 · edited May 20 '18 at 01:04

13

you will need to update file config.default generally phpmyadmin's libraries folder

line 653 (may very depending on version)

$cfg['AllowUserDropDatabase'] = true;

edited May 20 '18 at 01:04

William Desportes

1,412
1
22
31

answered Dec 04 '12 at 15:02

Vasek

153
1
5

score 13 · Answer 5 · edited Dec 11 '13 at 09:42

13

Without touching any config files

If you have your phpmyadmin open, on the left side you'll see a database icon right next to your home icon( if you mouse over it - 'query window' title will pop up ), click on it and the window showed will allow you to enter the 'drop query' without touching any config files( at least i had no problems, hope it will help ).

Database button

edited Dec 11 '13 at 09:42

TheHippo

61,720
15
75
100

answered Sep 17 '13 at 15:17

orustammanapov

1,792
5
25
44

score 9 · Answer 6 · edited Jan 14 '21 at 08:21

9

Xampp window

Method 1

Open Xampp
apache -> Config -> phpMyAdmin(config.inc.php) or config.inc.php
Add $cfg['AllowUserDropDatabase'] = true;

Adding line in config.inc.php

Method 2

Open C:\xampp\phpMyAdmin\config.inc.php
Add $cfg['AllowUserDropDatabase'] = true;

edited Jan 14 '21 at 08:21

geertjanvdk

3,440
24
26

answered Dec 01 '20 at 10:04

FAYAZ AHAMED

151
2
1

Yash Vekaria · Answer 7 · 2022-11-07T11:58:33.820

7

PhpMyAdmin throws the error “DROP DATABASE” statement is disabled”. “DROP” tab is missing on the PhpMyadmin Home page. To Enable the above tab in PhpMyAdmin follows the below procedure.

Go to XAMPP directory—–>PhpMyAdmin—–>libraries/ folder.
Open/Edit the file with the name “config.default.php”
Find $cfg['AllowUserDropDatabase']
You will find it’s value is ‘False’, Make it “True” and you’re done.
Refresh PhpMyAdmin Page or Restart MySql server and then open PhpMyAdmin.

edited Nov 07 '22 at 11:58

answered Aug 12 '14 at 05:53

Yash Vekaria

2,285
24
24

Make sure your Apache and MySQL are off when you edit all these. – Aaron Liu Nov 05 '22 at 16:43

score 3 · Answer 8 · answered Oct 21 '14 at 05:19

I was able to do without modifying any of the above mentioned files.

Step 1

click on the database icon next to home icon

Step 2

on the right side of the screen select the operations tab

Step 3 Select the drop the database option and it should work[for me it worked even with the tables containing data

score 2 · Answer 9 · answered Aug 11 '14 at 05:18

2

Drop the database and create a new one. To do so, go to phpmyadmin and select the database over the left panel. Then Go to 'Operations' tab on the head. Find the option to Remove Database at middle right. Click on DROP DATABASE and way to go...

answered Aug 11 '14 at 05:18

Raa Vijay

77
4

score 1 · Answer 10 · edited Jun 20 '20 at 09:12

1

did you try deleting the database by logging in to mySQL using SSH if you have not already..

sudo mysql -u yourmysqlusername -p (enter the password when prompted.)

mysql> SHOW DATABASES; (find your database)

mysql> USE YOURDATABSETODROP; (CHANGE THE DATABASE)

mysql> DROP DATABASE YOURDATABSETODROP; (and you are done.)

edited Jun 20 '20 at 09:12

Community

1
1

answered Sep 30 '13 at 14:43

Ashish Madkaikar

129
1
9

Haron · Answer 11 · 2021-02-15T15:58:15.570

Sometimes PhpMyAdmin throws very unusual error: ““DROP DATABASE” statement is disabled”.

In this situation the “DROP” tab can not be seen in PhpMyAdmin home page. You can get rid of this problem by doing the following process.

Go to -> your_drive/xampp/PhpMyAdmin/libraries/
Open a file name “config.default.php“
Find $cfg['AllowUserDropDatabase'] = false; and convert it to like: $cfg['AllowUserDropDatabase'] = true;
Stop mysql server and Start again.

:) you can now able to drop the database.

score 0 · Answer 12 · answered Aug 16 '13 at 14:25

Yes, you can do it with the following steps:
1. Go to wamp/apps/phpmyadmin3.5.1/libraries
2. Open the file called "config.default.php"
3. Go to line 653 and change $cfg['AllowUserDropDatabase'] = false; to true
~~4.Restart the server to see the changes~~

~~Restart the wamp~~ ...Close wamp server and open again. :)

Enjoy!

CAtoOH · Answer 13 · 2014-01-12T15:04:30.503

If this happened on a MAC, the chances are you are not running within an administrator's account; you don't have permission to delete the directory.

In your finder menu bar click "go" and type the following: usr/local/mysql/data
Select/delete the directory with the same database you want to drop - you will likely get the dialog asking for the admin username and password to continue.
After you enter the admin credentials, the directory will be gone. Restart your session with the database and you will be good to go.

Hope this helps

score 0 · Answer 14 · edited Oct 30 '14 at 09:18

if you are using version 4+ then you can simply drop a database just following these steps:

go to mysql admin
click database option (right side of your databases)
here you will get all the databases you have and now click the checkbox at the left side of the databases you want to delete
just the bottom of these databases you can see the option "Drop" so click the drop to delete the database permanently

score 0 · Answer 15 · answered Nov 19 '14 at 17:37

I had to use another icon in CPanel (Databases section / MySqlDatabases) instead of (Databases Section / phpMyAdmin).

(... since my shared web-host provider disables the DROP DATABASE command, and initially limits access to command line and config files.)

score 0 · Answer 16 · answered May 16 '15 at 11:40

0

select the database in phpadmin
click the operations button
show the remove database section
click the Drop the database(DROP). It show the alert box.
click OK.

answered May 16 '15 at 11:40

Arockia jenitha

1
3

score 0 · Answer 17 · answered Aug 23 '15 at 20:47

I had problems with most of these approaches.

My installation is hosted so I don't have access to the PHP config files and the PHPMyAdmin interface is not displaying the "Remove Database" section mentioned above (under the Operations Tab). The icon in the corner didn't work either.

What I realised you can do is create a stored procedure to delete your table.

Go to "Routines", "Add Routine" and create a stored procedure with the single line:

DROP DATABASE databasename

When that's created you can execute it and the database will get deleted.

score 0 · Answer 18 · answered Jun 18 '16 at 10:28

0

Go to \wamp\apps\phpmyadmin4.1.14\libraries Open the file called "config.default.php" Go to line 653 and change $cfg['AllowUserDropDatabase'] = false; to true Restart the server to see the changes

answered Jun 18 '16 at 10:28

Priyanshu Singh

704
8
12

score 0 · Answer 19 · answered Jul 09 '20 at 14:39

I noticed the same problem when I was trying to drop a database (5.0.2 is the version of PhpMyAdmin I am using). In my case, there is no $cfg['AllowUserDropDatabase'] variable in the config.inc.php file and the default config file libraries/config.default.php has it false by default.

If you want to allow dropping a database temporarily, I would recommend just adding a $cfg['AllowUserDropDatabase'] = true; line in the end of the config.inc.php file (or change the false value to true instead if it's already there) instead of modifying the default value in libraries/config.default.php that some answers here recommend because as the documentation says, "the file is not intended for changes". After doing your thing, just delete the line altogether or set it back to false again.

score -1 · Answer 20 · edited Sep 29 '16 at 12:57

Go to the left sidebar of phpmyadmin where there is a listing of your databases and select the specific database that you want to delete.
Having done that under the menu bar where there are several options such as query, sql, operations, etc choose structure.
When you do that it will give you a listing of all the tables of the DB and right below the tables there is a checkbox choose check all and on the dropdown after that choose drop.

phpmyadmin enable drop database statement

20 Answers20

Method 1

Method 2

Linked