1. Home
  2. Knowledge Base
  3. How to disable WordPress plugins (No access to WP-ADMIN) using PHP MyAdmin

Often when people have difficulties accessing the admin page of their website, they find out that issues like this mostly occur as a result of faulty plugins. To fix this, it is crucial that you access the particular plugin giving this issue and have it deactivated. Disabling plugins from your website due to difficulties in accessing your website’s admin area can be done in three different ways using WordPress. This happens when you install a new plugin which sometimes proves problematic. These three ways are:

  • Using your plugins tab via your dashboard.
  • Through FTP by renaming the plugins folder
  • Directly from your database.

 While the first option mentioned above is rarely used, the second option requires a software application to correct these difficulties. Thus, firstly you need an application for this process that will connect the file transfer protocol from your server to your computer. It allows you to access files on your website from your server host. These applications can be obtained from the many open source applications out there.

However, this article will focus on the deactivation of WordPress plugins Using PHP my admin directly from your database.  This technique involves four steps, which are:

  1. Accessing your database in PHP my admin.
  2. Clicking the WordPress domain name option.
  3. Locating the faulty plugin(s)
  4. Deactivating/Disabling the broken plugin.

How to disable WordPress plugins via phpMyAdmin

In most cases, the FTP technique is by far the easiest way to disable WordPress plugins if you cannot access your dashboard. Using PhpMyAdmin is another alternative. The PhpMyadmin technique is especially useful when you discover that your WordPress admin account cannot be accessed and you have deduced that the problem may have arisen as a result of faults from your plugins. This/these plugins have to be deactivated to identify the particular plugin causing this problem. 

The first step is to log in to your WordPress administrative panel and scrolling to the plugin menu. Next is scrolling and login to your websites cPanel and scrolling to the section that says database and clicks on the PHP my Admin option. It will automatically take you to the Php MyAdmin page where you will insert your login details. From there you will be directed to the PhpMyadmin interface which will display options that will allow you to click on your WordPress database.

After clicking on your database, the list of all the tables within your installations is shown. From there, click on your SQL tab from where you run the following  SQL command  SELECT*FROM w_options WHERE option_name =’active’_plugins’;  and click on the Go button.

This will take you to another page. On this new page, click on the edit link option. This displays all the active plugins. From here it is essential that you first of all select all the active plugins showed, cut and save them somewhere as a backup in case you mess the entire process up. After cutting the plugins (deleting them from the work options table), you then click on the Go button.

This disables all the active plugins. Then return to the websites admin panel, refresh the plugins page. You will discover that all the plugins have been disabled. This should give you access to your admin.

Now, to disable one plugin, you repeat the same process, delete the entry, and particular number from the curly bracket in the plugin search listing and renumber all the plugins starting from zero in the following manner. For instance, if there are 10 plugins, renumbering from zero will have the last plugin numbered 9. If there are 11, it becomes 10.

After this, you will discover that upon return to your phpMyadmin page, and clicking on the plugins page where you will discover that the particular plugin deleted has been disabled. The code a:10: tells you that there are ten active plugins and a:11: tells you that there are eleven active plugins. After doing this, you copy the edited entry, return to PHP Myadmin windows and go to the wp options page, click the edit button on the row with option name “active plugin” and paste and save the copied code on the displayed table. Going back to your plugins page on your WP ADMIN page, you will notice that the deleted plugin from the modified code has been disabled.

Also, another way of disabling all the active plugins is by going to the SQL tab and clear the option value for active plugins in like manner as the previous technique by running the command UPDATE wp_options SWT option_value = * WHERE option_name =’active_plugins’; and save it by clicking the Go button. This method disables all the active plugins while the first option disables only selected plugins in your installation.

Was this article helpful?

Leave a Reply

Your email address will not be published. Required fields are marked *