How to Change WordPress Theme via phpMyAdmin

A theme controls the general appearance and feel of your site including things like page layout, widget locations, and default font and color choices. has a range of themes for you to choose from in the Theme Showcase where each theme has an about page that includes features and instructions. New themes are always being added, keep checking for new designs: you can change your theme as often as you like.

Which theme to use? Here is a list of top 6 WordPress themes.

Are you trying to figure out how to change a WordPress theme? The actual process for switching WordPress themes is fairly simple.

Before diving in the deep to know how to change WordPress theme via phpMyAdmin, let me highlight what happens to your existing content when you change themes.

Most of your regular site elements will not be affected by changing themes. In addition, nothing will change with:

  • Nothing bad will happen to your posts and pages when you switch themes.
  • Any core WordPress settings. For example, static pages.
  • Any plugins except those belonging to your current theme.
  • Your site name and description will stay the same.

Grab the best deal on MyThemeShop: fastest WordPress themes on the market.

How to change WordPress theme?

Normally, the easiest way to change your WordPress theme is by visiting the Appearance » Themes page in WordPress admin area. However, sometimes a WordPress error can make your website admin area inaccessible.

In such cases, keeping back up of your site becomes handy. Sometimes, we don’t have a backup and don’t want to move back to revert to a default theme, then you can change to a custom WordPress theme from your database by using phpMyAdmin.

Changing theme via phpMyAdmin allows you to tell WordPress which theme to use by changing the information in the database.

  • At very first, install the theme you want to use on your WordPress site.
  • Now, connect your site to the FTP client.
  • Go to the /wp-content/themes/ folder. Here, you can see all the themes that you are currently using on your site.
  • Once you ensure that the theme is installed, now go to cPanel dashboard of your WordPress hosting account.
  • Scroll down to the databases section and then click on phpMyAdmin.
  • On the left side of the screen, click on the database that you are using for your WordPress site.
  • A list of the database will appear.
  • Click on the ‘wp_options’ table to open it.
  • Scroll down and locate ‘template’ and ‘stylesheet’ rows. Click on the Edit button next to the template row.

Changing theme using phpMyAdmin
Changing theme using phpMyAdmin

  • The row editor will open where you need to change the value for the option_value field to the theme you want to use. The value will be the same as the name of the folder of your theme. For example, /wp-content/themes/abc, here, value will be set as abc.
  • Click on Go in order to save your changes.
  • Follow the same steps for stylesheet row.

Now, you have put your installed theme in action.

Isn’t it easy? I hope this guide helps you in changing WordPress theme via phpMyAdmin successfully.

Also Read:

Comment Policy: Your words are your own, so be nice and helpful if you can. Please, only use your real name and limit the amount of links submitted in your comment. We accept clean XHTML in comments, but don't overdo it please.


Please enter your comment!
Please enter your name here



MonsterInsights is the best Google Analytics plugin for WordPress. Setup Google Analytics for WordPress with just a few clicks.


Start WordPress Blog: Ultimate Guide For Beginners

Here is our step by step guide for beginners to start a WordPress blog.

Top 6 Best WordPress Theme Frameworks

There are many websites themes which are created by using a framework. Likewise, WordPress Theme frameworks also becoming so popular. The framework allows you...

The Most Essential WordPress Plugins

Here, I have listed some excellent plugins which will surely add more features and new functionality to your WordPress blog.

Tips to Speed Up WordPress Performance

Here, I am sharing some tips to speed up WordPress performance. All you need to modify .htaccess file on your server and add some plugins.

The Ultimate Guide to Harden WordPress Security

Learn how to improve WordPress security. Here are some basic security concepts that will help you to harden WordPress security.

How to Setup CloudFlare Free SSL for WordPress Blog

Google has announced that they will count HTTPS as a ranking factor which means if you using HTTPS you will get a higher position...


Get almost 100% PageSpeed on Newspaper theme

The newspaper theme is the most popular premium theme for a self-hosted WordPress blog. The theme is developed by team tagDiv. You...

How to Delete Multiple Images in WordPress Media Gallery

Hey, guys today one of my friends asked me a question, How can I delete Multiple Images in WordPress? I replied, "It's very simple." Yeah,...

How to setup CloudFlare CDN for WordPress blog

In today's world website speed is a crucial element to getting good ranks on the web. Website speed also aids in indexing...

How To Reduce Admin-Ajax Server Load In WordPress

To increase better user experience, we always end up by increasing site speed. After clicking a website link seems like a simple...

How to Remove jQuery Migrate in WordPress?

jQuery Migrate greatly simplifies the process of moving older jQuery code to a higher jQuery version by identifying deprecated features. It then restores deprecated...