How to Change WordPress Theme via phpMyAdmin

Join InfoPhilic Community!

Let's build a community to help & encourage each other to grow!

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:

Subscribe to our newsletter

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

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


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


Kinsta Hosting

Highly optimized servers for lightning-fast sites. High-security environment hack-fix guarantee. WordPress support experts at your fingertips. GRAB THIS DEAL


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

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 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?...

Xperia Home Launcher: Install on any Android Device (No Root)

Hey, guys today through this tutorial you are going to learn how to install Xperia Home Launcher on any Android device without any root. Also...

How to create News Sitemap for WordPress site?

Learn how to create special news sitemap for your WordPress blog/ website using Yoast News SEO plugin and Jetpack plugin.