Knowledge Base
MilesWeb / WordPress FAQ

How to disable all WordPress plugins directly from the database?

Approx. read time : 2 min

WordPress Plugins can b 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!!

With over 10+ years of experience in the web hosting industry, I have achieved extensive exposure to result-oriented methodologies. And expertise in different domains like Datacentre Services, Cloud computing technology, Web hosting industry and many more.