phpMyAdmin config

Category: Databases

2013-04-26 2:41 pm EST

Hits: 337
Hi, I am in the middle of development. I would like to edit the config file of my phpMyAdmin in order to allow MySQL users to drop database.

At the moment we are getting the "DROP DATABASE" disabled statement

You must login before you can ask a follow up question.

You must login before you can submit an answer.



5,563 Points
2013-04-26 3:11 pm EST
Hello AoumiS, and thanks for your question.

Typically we wouldn't recommend utilizing phpMyAdmin to add or remove databases, as these are managed within cPanel itself, and if you just drop a database in phpMyAdmin, cPanel will still think it exists.

You can follow our guide on how to delete a database in cPanel for the recommended way to drop a database on our servers.

Alternatively if you really wanted this ability in phpMyAdmin for some reason, you would want to install a separate copy of phpMyAdmin via Softaculous, then in your file you'd add the following line of code to enable the DROP DATABASE command:

/* Turn on Database DROP */

$cfg['AllowUserDropDatabase'] = true;

Please let us know if you had any other questions at all.

- Jacob

You must login before you can post a comment about this answer.

Like this Question?
Write New!
Do you want to publish a tutorial to our support center?

News / Announcements

SSL Certficate Warnings
Updated 2014-04-14 11:34 am EST
Hits: 2029
Heartbleed 0-day OpenSSL security bug
Updated 2014-04-14 04:43 pm EST
Hits: 5341

Related Articles

It looks like there are no related articles.
Would you like to ask a question about this page? If so, click the button below!
Ask a Question

Need more Help?


Ask the Community!

Get help with your questions from our community of like-minded hosting users and InMotion Hosting Staff.

Current Customers

Chat: Click to Chat Now E-mail:
Call: 888-321-HOST (4678) Ticket: Submit a Support Ticket

Not a Customer?

Get web hosting from a company that is here to help. Sign up today!