WordPress: Disable Plugins from phpMyAdmin

Having problems with your WordPress blog with pages just appearing blank? Having problems even logging in as the Administrator? Chances are there's something wrong with a plugin you installed/activated.

You can deactivate your plugins from phpMyAdmin by running this line of SQL:

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

or you can see all your activated plugins running this line of SQL and checking out the option_value values:

SELECT * FROM wp_options WHERE option_name = 'active_plugins';

If you have problems with these queries, just update the table name (wp_options) to include your prefix, i.e. mysite_wp_options

You can reactivate them one-by-one, taking note of the last plugin you activate. When the site does break again you'll know it was something to do with the last plugin you activated.


Back to Blogs