How to: Disable all your plugins in a second

Sometimes, for exemple when you have to upgrade your blog, you need to disable all your plugins. Depending to how much plugins you’re using, it can takes a lot of time and be kinda boring. Happilly, I got the solution to this problem, with a simple recipe to disable all your plugins on a second!

First of it all, login to your phpmyadmin and choose your WordPress database. Once done, click on the sql button to open the sql command window.

Then, simply paste the following sql command and execute it.

UPDATE wp_options SET option_value = '' WHERE option_name = 'active_plugins';

That's all, you have disabled all your plugins. Does anyone got a tip to re-enable them in a second?

11 Responses

Nov 27 2008 10:28

Hi,

Don’t want to be the one to rain on your parade or anything, but this is easily doable in the WP plugins menu. You simply check the box at the top of the list and it will check all the boxes below it. Then, just push the deactivate button. To reactivate, just do the same thing again.

Hope that’s helpful,

Miss Mussel

Nov 27 2008 11:15

Easier way is to rename the plugins directory to plugins2, and rename it back after a while :)

Nov 27 2008 11:22

Thanks to both of you for the tips!

Nov 28 2008 09:02

When you say “upgrade the blog”, are you referring to upping to a newer Wordpress version? If so, all plugin manipulation is done automatically with “auto-upgrade”. No renaming or re-activating. As for directing a general reader to editing in phpmyadmin… I would include a strong warning.

Nov 28 2008 09:24

@Pablo: Yes, the “auto-upgrade” can disable all your plugins automatically, but there’s other situation where you have to disable all your plugins, for exemple if a problem appears. In that case, that hack still could be useful in my opinion.

And for the warning, you’re right that I should have inclued some, althought this line of sql can’t be that harmful.

Thanks for sharing your thoughts!

Dec 07 2008 11:14

Awesome recipe. I’ve installed a plugin a couple of days ago that I got from a pretty much unreliable source I guess and just doesn’t wants to get uninstalled (it’s active but not listed on the plugin page)

Apr 27 2009 04:07

Hello WP Recipes, I’m back lurking on the net again and thought to drop by to say thanks for this tip again that has saved me (again) from a corrupt plugin that caused an error on all pages and just doesn’t wants to be disabled.

Trackbacks:

Leave a Comment

* Name, Email, Comment are Required