How to Deactivate Your Plugins from Your Database

How to Deactivate Your Plugins from Your Database

In my time of fixing and building sites, sometimes a plugin gets an update (or doesn’t) and suddenly the WordPress site displays an error code – or lots of errors. Unfortunately, there is not a way to get in to the WordPress dashboard and you need to deactivate that plugin.


Below are step-by-step instructions on how to deactivate plugins from your database.

  1. From your hosting account, look for your database section and click on phpMyAdmin.database1
  2. Once you are logged in to phpMyAdmin, select your database on the left hand side. Depending on your plan you may have multiple databases listed or just your one.
  3. Once you click your database, all of the tables will expand, select your options table (usually wp_options) but it may be different depending on how your plan is set up. database3
  4. Once you select your options table you will see a list of the values inside that table. Sometimes the database will default to Structure, if that is the case, make sure you select Browse. You will want to go to the second page to find Active Plugins. database4
  5. Click on Edit next to active_plugins and then select all of your plugins. database5
  6. Delete all the plugins so that the value is empty and hit Go. database6

That’s it, now your plugins have all been deactivated and your site should load. You can reactivate the plugins that were not causing errors from the dashboard.

Leave a Reply