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 in the expert coverage he provides. In addition to writing for InfoPhilic, Amit loves to read and try new things.


Subscribe to our newsletter

To be updated with all the latest news, offers and special announcements.


Please enter your comment!
Please enter your name here