How to disable all WordPress plugins directly from the database?

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

a:2:{i:0;s:19:”akismet/akismet.php”;i:1;s:9:”hello.php”;}

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 hostvento