How To Deactivate Plugins From The WordPress Database

Your database editor lets you access the plugins without affecting your file structure. For example, if you wanted to deactivate plugins by renaming a folder, you would need to access your file system. But you can accomplish this same effect much faster (and more safely) by using the database as your backdoor solution.

You will find a list (in serialized array) in the “wp-options” table of your WordPress database. There you’ll find the row labeled "active_plugins". This is the table and row you will need to edit to deactivate plugins.

In order to edit serialized data safely, you need to use special editors that help you avoid any human error. The editor suggested in this article was developed by Delicious Brains and makes it very easy to edit serialized arrays.

1. Log into cPanel
2. Click phpMyAdmin under Databases
3. Locate the WordPress database you need to edit
4. Locate the active_plugins row in the “wp-options” table
5. Copy the serialized data in active_plugins and copy it into the serialized data editor
6. Uncheck the plugins you wish to deactivate
7. Restore the edited array into your database
8. (Optional) Paste a:0:{} to disable all plugins
9. Save your changes

Well done! You just deactivated WordPress plugins from your database. Improve your WordPress master skills further in the WordPress education channel.