Knowledge Base Hub

Browse through our helpful how-to guides to get the fastest solutions to your technical issues.

Home  >  WordPress FAQ  >  How to disable all WordPress plugins directly from the database?
Top Scroll

How to disable all WordPress plugins directly from the database?

 2 min

WordPress Plugins can be easily disabled from your database. Making changes in database is useful when there is some problem with installation of wordpress such as having blank pages or not being able to login to admin area.

To disable all plugins, Login to “phpMyadmin“and select “wordpress database” from menu on the left.

Browse the table wp_options and search for the option “active_plugins“. Click the pencil icon to edit the table. The content there may vary, depending on plugins you have enabled. For example, if you have the Akismet and Hello Dolly plugins enabled, the code there will be


To disable all plugins, simply delete the code and click the “Go button” to save the change.  Alternative option is to use the following query to disable all of your WordPress plugins:

UPDATE wp_options SET option_value = ” WHERE option_name = ‘active_plugins’;

Please be advised that disabling the plugins will not be remove them permanently from wordpress application, they’d just be de-activated. You can use wordpress admin area to activate plugins again.

Looking for Best Hosting For WordPress? Look no further than MilesWeb!!

For our Knowledge Base visitors only
Get 10% OFF on Hosting
Special Offer!
Claim the discount before it’s too late. Use the coupon code:
Note: Copy the coupon code and apply it on checkout.