KNOWNHOST WIKI

User Tools

Site Tools


cms:wordpress:how-to-change-wordpress-themes-plugins-via-phpmyadmin

How to use PHPMyAdmin to change themes and plugins for WordPress

In this guide we'll be showing how to do the following two things through PHPMyAdmin.

  • Change/deactivate plugins
  • Change your theme

This process is rather straightforward but due to the nature of editing databases we do recommend that you create a backup prior to beginning any work!

Difficulty
Medium
Medium

Deactivating WordPress Plugins

This process may be a little imtidiating for those who are unfamiliar with how WordPress utilizes plugins via the database.

They use a long string that looks like this

a:8:{i:0;s:19:"akismet/akismet.php";i:1;s:43:"all-in-one-seo-pack/all_in_one_seo_pack.php";i:2;s:36:"contact-form-7/wp-contact-form-7.php";i:3;s:37:"disable-comments/disable-comments.php";i:4;s:9:"hello.php";i:5;s:27:"redirection/redirection.php";i:6;s:43:"shortcodes-ultimate/shortcodes-ultimate.php";i:7;s:23:"wordfence/wordfence.php";}

To understand what this is; we'll break it down.

'a:8:' is the number of active plugins. This string currently has 8 active plugins. This number and the length of the line changes depending on how many plugins are active.

The easiest thing to do when troubleshooting plugins is to just wipe it back to default.

However, first we need to get there.

You're going to want to login to your cPanel account and navigate to PHPMyAdmin

Once inside you're going to see a list of your databases on the left – in this case; we're using 'khtest_wp' – we'll then go to the 'wp_options' table.

Within this next page you'll see a bunch of data in what is called 'rows' – rows are numerical and start from 1.

We'll want to go to 'page 2' and search for row 33; you'll see the following

We'll want to modify this value. You can do this by double-clicking on it and it'll enlarge the text place to modify.

At this point; if you want to reset the entire active plugin we replace that entire line with the following

a:0:{}

This deactivates all plugins that are currently active and marks them as disabled.

Once you've modified the field; click outside of the row to save the changes.

If you want to be advanced and disable only a specific plugin you would need to change the active number of plugins and remove the plugin from the line.

Example:

If I wanted to remove just one plugin;

a:8: becomes a:7: and then I'll remove my redirection plugin 'i:5;s:27:"redirection/redirection.php";' and delete it from the line which gives me the following

a:7:{i:0;s:19:"akismet/akismet.php";i:1;s:43:"all-in-one-seo-pack/all_in_one_seo_pack.php";i:2;s:36:"contact-form-7/wp-contact-form-7.php";i:3;s:37:"disable-comments/disable-comments.php";i:4;s:9:"hello.php";i:6;s:43:"shortcodes-ultimate/shortcodes-ultimate.php";i:7;s:23:"wordfence/wordfence.php";}

Now I only have 7 active plugins and I can login to my WordPress dashboard again.

However, the easiest solution due to the ability to simply re-enable plugins in WordPress is most likely to just deactivate all plugins as noted earlier in this guide.

Changing WordPress Theme

There may be some instances where you're unable to change the theme due to site-code issues or incompatibility issues at the result of upgrading PHP or perhaps WordPress was updated but your theme developer didn't push their update in time and now your website is broken or perhaps you just want to be able to know how to change it through other means than the WordPress dashboard.

This is possible through PHPMyAdmin section of your server.

You're going to want to login to your cPanel account and navigate to PHPMyAdmin

Once inside you're going to see a list of your databases on the left – in this case; we're using 'khtest_wp' – we'll then go to the 'wp_options' table.

Within this next page you'll see a bunch of data in what is called 'rows' – rows are numerical and start from 1.

We'll want to go to 'page 2' and search for rows 40 and 41 (typically always the same in WordPress databases)

These two rows are called "template" and "stylesheet"

You can use the "filter rows" bar to search for these too.

We're going to want to modify these two values of 'bhost' (or whatever your theme name is!) to another theme that exists on the server.

To edit there are two ways you can do this.

Method #1 – double click on the row where 'bhost' is located and it'll turn into an editing box.

You would then change 'bhost' to your a default WordPress theme such as 'twentynineteen' – or whatever theme you have available. Simply click off to the side or it to save changes

Method #2 – clicking on the 'edit' button to the left will bring up a larger screen.

Same as Method #1; you would change 'bhost' to your a default WordPress theme such as 'twentynineteen' – or whatever theme you have available.

Then you would click "Go" to push the change.

Now you've updated your WordPress theme so that you can get into 'wp-admin' of your website.

cms/wordpress/how-to-change-wordpress-themes-plugins-via-phpmyadmin.txt · Last modified: 2019/07/02 17:48 by Jonathan K. W.