How to disable all WordPress plugins directly from the database?

Find best Web Development tips and Tricks.
Post Reply
apurba_soft
Posts: 10
Joined: Thu Jun 23, 2016 10:08 am
Location: India
Contact:

How to disable all WordPress plugins directly from the database?

Post by apurba_soft » Thu Jun 23, 2016 1:15 pm

Hi, My WordPress is crashed, Now I want to Disable all Plugins using PhpMyadmin.

Please advice me.

arnlweb
Site Admin
Posts: 95
Joined: Wed Jun 22, 2016 1:28 pm
Location: India
Contact:

Re: How to disable all WordPress plugins directly from the database?

Post by arnlweb » Thu Jun 23, 2016 1:16 pm

Log in to phpMyAdmin and select your WordPress database from the menu on the left.

Browse the table wp_options and find the option active_plugins. Click the pencil icon to edit the table. Its content will vary, depending on what plugins you have enabled. For example, if you have the Akismet and Hello Dolly plugins enabled, the code there will be:

Code: Select all

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.

The other option is to use the following query to disable all of your WordPress plugins:

Code: Select all

UPDATE wp_options SET option_value = '' WHERE option_name = 'active_plugins';
Please note that disabling the plugins will not remove them from your WordPress application. They will simply be deactivated. You can easily activate them from your WordPress admin area at any time.

apurba_soft
Posts: 10
Joined: Thu Jun 23, 2016 10:08 am
Location: India
Contact:

Re: How to disable all WordPress plugins directly from the database?

Post by apurba_soft » Thu Jun 23, 2016 1:23 pm

I run this sql statement,

Code: Select all

UPDATE wp_options SET option_value = '' WHERE option_name = 'active_plugins';
Now, all plugins are disabled.

Thank you.

Post Reply