Deactivate WordPress Plugins using phpMyAdmin

We can deactivate WordPress plugins from WordPress admin area but if you are installing any plugin and your admin area stopped working, you can disable WordPress plugin directly from your WordPress database.

In this article, we will explain how to deactivate WordPress plugin from MySQL database using phpMyAdmin.
Before you perform this steps, make sure that you secure full backup for your database.

[1] If you have cPanel, login to your cPanel and go to phpMyAdmin.

[2] Once you login to phpMyAdmin, click on your WordPress database.

[3] Now, click on “SQL” tab as shown in the following image:

Click SQL
[4] Now execute the following select query:

SELECT * FROM wp_options WHERE option_name = ‘active_plugins’;

SQL Query
Make sure that you use appropriate table name. If you have different table prefix, you will have to use appropriate table name.

[5]  Click on the “Edit” link as shown in the following image:

Edit SQL[6] This should show the content as follow:


[7] Remove the unwanted entry from the above. For example, if you wish to disable Akismet, remove the following:


Leave a Reply