How to disable wordpress plugins through phpmyadmin

Recently my business partner and I purchased a site of flippa. We received the domain name, got the wordpress files and database and proceeded to set it up on our server.

When we had everything set up, unfortunately the site was broken, and when I checked the error log it pointed to a plugin issue.

This was a bit of a challenge, as we couldn’t login to the site, to manually go in and disable the plugin, so we had to do it through the database.

This is the code you can run, to quickly disable all your wordpress plugins via phpmyadmin, or your alternative mysql editor.

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

Once you have run the code, you site should now run and you can at least login and check out what’s going on.

Rob StGeorge
Senior SQL Server Database Administrator residing in Auckland, NZ

1 Comment

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.