How to disable WordPress plugins from PhpMyAdmin

WordPress is a very powerfull CMS through which you can make your website faster in a easier way by using using different themes and plugins etc.

As plugins and themes adds functionality to your WordPress site but sometimes they can cause various errors and problems. Heavy plugins may lead to higher consumption your CPU resources, slowing down your website speed due to their running scripts,or giving unusual errors related server, your php code etc.

Sometimes your themes and plugins are not compatible , so we recommend our users to use as much less plugins as they could becuse if you have install more plugins your site will load slow etc. Disabling of WordPress plugins is helpful in those situations when a Webmaster getting some compatibilty issues or some errors(related to php source code,databases,server etc) due to already installed plugins.

Errors like Internal Server Error, Cannot modify header information - headers already sent etc are Please follow the below mentioned steps for disabling your WordPress plugins from PhpmyAdmin of your cPanel:

1) Login to your cPanel.

2) Scroll down to Files section and click on “File Manager” icon.

File Manager in cpanel

After clicking on File Manager you will be redirected to a page where a list of files and folders in your hosting account is visible on screen.

3) Now you need to navigate to public_html > wp-config.php file.

4) Right click on wp-config file and click on view as shown in the screenshot.

Viw wp-config file in cpanel

Note: Viewing of wp-config file is helpful for you to identify the database from which you want to disable plugins.This process is also useful if you have install more than one WordPress.

The name of your WordPress database looks like shown in the screenshot.

Wordpress database check in cpanel

5) Now you need to return again to cpanel.

6) Scroll down to Databases section and click on "phpMyAdmin" icon as shown in the screenshot:

phpmyadmin icon in cPanel

7) Now You will be redirected to phpMyAdmin panel. At the top left side you will see your database directory. Click on "+" to expand it.

Select WordPress database in phpmyadmin

8) Select and click on database name for which you want to disable the plugins as shown in the screenshot:

Wordpress databases in cpanel

9) Now you will a list on the screen when you click on your database and you need to click on "wp_options".

10) After clicking on wp_options , click on "search" from the top menu bar.

11) Now navigate to option_name and write "active_plugins" in its value field and press Go button.

12) Now you are redirected to Search table structure page. Click on "edit" link as shown in the below screenshot.

13) In option_value field you will see your all active plugins.
For eg: You will see something like "a:{}" shows the number of plugins that you have installed.

Select and delete all your plugins in option_value section and press Go button.

This will deactivate all your plugins from your WordPress. Now you can activate any necessary plugins that you want from your WordPress dashboard .