InfoPhilic WordPress How to Change WordPress Theme via phpMyAdmin

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:

Amit Malewar
Amit Malewar has been the tutorial writer since 2013. His passion for helping people in all aspects of technology flow through the expert coverage he provides. In addition to writing for InfoPhilic, Amit loves to read and try new things.

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



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 can buy...

How to Remove jQuery Migrate in WordPress?

Learn how to remove jQuery Migrate from your WordPress site.

WP Super Cache Plugin: Best Settings & Configuration Guide

A cache plugin serves static contents to the visitor, which improves page load speed. There are so many cache plugins available in the WordPress plugin...

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 thing. But...

How to configure WP-Rocket plugin for WordPress site

When it comes to optimizing your website, the role of caching in WordPress can never be underestimated. What exactly is caching all about? We know...


Bluehost Hosting

Get hosting for just $3.95 per month with Bluehost. Bluehost is an officially recommend WordPress host, and one of the most popular & reliable web hosts available.