1. Knowledge Base
  2. >
  3. Results
  4. >
  5. Enable/Disable WordPress Plugins using Database

Enable/Disable WordPress Plugins using Database

If your WordPress admin login page is only showing a blank screen, it could be due to an issue with one or more plugins that have been installed. This will usually happen if you install a plugin that is not compatible with the currently installed theme.  It can also occur if the installed WordPress version has recently been updated as plugin developers don't always update plugins to keep up with all WordPress security updates.

You can easily determine if a plugin is causing the issue by disabling all plugins temporarily. 

We recommend backing up your WordPress database from within phpMyAdmin before making any changes to the database.

Step 1: Determine the Database Name

Find out which database is associated with WordPress' installation that you wish to change, by following the instructions below:

You may find some links below that will redirect you to your cPanel and its features provided that the following conditions are met:
  • You are logged into your Customer Portal. You can also log in after clicking the link.
  • The hosting package you are attempting to access is either a Shared or Cloud.
  1. Log into cPanel.
  2. In the Files section, click File Manager.
  3. On the left side, select public_html.
  4. Click the Settings button found on the top right-hand corner.
  5. Put a checkmark on the Show Hidden Files (dotfiles) box. The Web Root (public_html or www) is selected in default.
  6. Click Save.

In the File Manager:

  1. Locate the wp-config.php file and click it.
  2. Right-click and select Edit. Click the Edit button again.
  3. Make a note of the database name. It will look similar to this:
    define('DB_NAME', 'domain_wrdp1')
    (Domain will be a prefixed form of the actual domain name or cPanel username being used.)

Step 2: Disable All Plugins

In the cPanel:

  1. In the Databases section, click phpMyAdmin.
  2. From the left-hand navigation menu, click on the appropriate database name.
  3. From the left-hand navigation menu, click wp_options.
  4. In the options table, find the option_name column and find the line named active_plugins. (You may have to click the > at the bottom of the page to view more columns.)
  5. On the active_plugins line, click edit. You will see something similar to this:
    a:5:{i:0;s:35:"add-from-server/add-from-server.php";i:1;s:25:"age-verify/age-verify.php";i:2;s:19:"jetpack/jetpack.php";i:4;s:69:"simple-full-screen-background-image/simple-full-screen-background.php";i:6;s:27:"wp-super-cache/wp-cache.php";}
  6. Highlight the entire box of code, cut it out, and paste it into a text file to be saved on your local PC.
  7. Once the code has been removed, click Go.

The plugins are now successfully disabled but are still installed with all options intact.

To re-enable plugins via the database, follow the steps above and paste the code that was saved in step 5 back into the box (active_plugins) from which it was initially removed; then click Go to save the changes.

Step 3: Isolate the Plugin Causing Issues

The most effective way to determine which plugin is causing the issue is to enable each plugin one at a time, following the instructions below:

  1. Visit your WordPress admin login page and refresh it, then log into WordPress.
  2. Go to Plugins > Installed Plugins. To know where to find your WordPress plugins, you can use this video as a guide.
  3. Activate a plugin.
  4. Go to your website and refresh the page.

* Repeat steps 3 and 4 until you encounter a plugin that causes an issue with your website.