How to Change your WordPress Theme using phpMyAdmin

Managing themes from the WordPress admin area is really easy but accessing your WordPress admin area isn’t that easy sometimes. You might not be able to access your WordPress admin area on many occasions. If this is the case with you, we have got you covered.

Need for phpMyAdmin

Well, we all know that nothing is easier than using the WordPress admin area for changing the theme. We just have to click on Appearance in the menu and then click on theme option to choose the theme which needs to be activated. See it’s that simple. But sometimes you are unable to even access your WordPress admin area. This error can refrain you from using this easy method. However, using a backup you can easily make your way to the WordPress admin area and then use this method.

But in case you don’t even have a backup then changing your WordPress theme from the database using phpMyAdmin will definitely help you out in this case. So let me guide you through the process.

Using phpMyAdmin to change WordPress theme

In this method, you can change the information in the database to let WordPress know that which theme is to be used. You will need the theme, that you are switching to, to be preinstalled on your website. But in case it isn’t, then you can install the theme manually by FTP. Once done, follow the following steps.

First of all, you need to open your FTP client which will help you in connecting to your website. Then you have to navigate to the /wp-content/themes/ folder. Once you have opened this folder you will see all the installed themes. Then make a note of the name of the folder of the theme that is to be installed.

Now you will have to find the phpMyAdmin option under the database section in the cPanel dashboard of your WordPress hosting account. Then click on the phpMyAdmin option.

The previous step will take you to phpMyAdmin where you will find a list. This list will be the list of databases which will be displayed on the left side under the phpMyAdmin logo. You need to look for the database, that you are using for this site, from this list. Once you have found it, click on it.

 

Clicking on your database will display all the tables present in it. You will have to find the ‘wp_options’ table. Once found, click on it.

If someone has changed the database prefix then you will see something else instead of the default WordPress prefix, i.e., wp_.

This will open the table. In the table, you will have to find the ‘template’ and ‘stylesheet’ rows and then click on the button in the extreme left that reads ‘Edit’.

Once you have clicked on the ‘Edit’ button, a row editor will open up. You have to alter the value of the option_value field to the theme that you wish to use on your website.

Once you are done editing, click on the ‘Go’ button. This will save your changes.

You have got to repeat the same process with the stylesheet row. After doing all this you theme will be activated on your website.

Now all you have got to do is to visit your website and test the theme.

 

Check out the top 3 WordPress hosting services:

HostArmada
$2.49 /mo
Starting price
Visit HostArmada
Rating based on expert review
  • User Friendly
    4.5
  • Support
    4.5
  • Features
    4.5
  • Reliability
    4.5
  • Pricing
    4.0
Kamatera
$4.00 /mo
Starting price
Visit Kamatera
Rating based on expert review
  • User Friendly
    3.5
  • Support
    3.0
  • Features
    3.9
  • Reliability
    4.0
  • Pricing
    4.3
ChemiCloud
$2.99 /mo
Starting price
Visit ChemiCloud
Rating based on expert review
  • User Friendly
    4.3
  • Support
    4.3
  • Features
    4.3
  • Reliability
    4.8
  • Pricing
    4.5

How to Change Your WordPress Password using phpMyAdmin

This is a step-by-step guide that shows you how to change your WordPress passwor
2 min read
Angela Olaru
Angela Olaru
Senior Writer & Hosting Expert

How to Delete Extra Database Tables After Uninstalling a WordPress Plugin

Not all the plugins come with an option to delete all the settings
4 min read
Max Ostryzhko
Max Ostryzhko
Senior Web Developer, HostAdvice CTO

How to Edit the CSS for your WordPress Site Using the cPanel Hosting Control Panel

As you know, the design of a WordPress website is controlled by
4 min read
Avi Ilinsky
Avi Ilinsky
Hosting Expert

How to use Amazon RDS with your WordPress Installation

The default instance which is set up while creating an EC2 server with complete
3 min read
Max Ostryzhko
Max Ostryzhko
Senior Web Developer, HostAdvice CTO
HostAdvice.com provides professional web hosting reviews fully independent of any other entity. Our reviews are unbiased, honest, and apply the same evaluation standards to all those reviewed. While monetary compensation is received from a few of the companies listed on this site, compensation of services and products have no influence on the direction or conclusions of our reviews. Nor does the compensation influence our rankings for certain host companies. This compensation covers account purchasing costs, testing costs and royalties paid to reviewers.