How to Change WordPress Theme from phpMyAdmin?

Wordpress theme defines the display of your website. Generally, we change the Wordpress theme from the Wordpress admin area. We may face the issue to change your Wordpress theme in case of incompatibility with Plugin. In these cases, we will need to change the Wordpress theme from the Wordpress Database. Wordpress uses MySQL Database hence we will try to do this from phpMyAdmin in this article.

Important Note: Please take your Database Backup before making any changes to the Database. It is always recommended to take DB Backup before changes. Once you make the changes on your Database, it will impact on your website.

  1. Before we start, we need to know about the Database name which is used by your WordPress. Please click on this link which helps you to find your Database.

  2. Go to phpMyAdmin.



  3. Click on Databases and find your Database.



  4. Click on your Database used for Wordpress.



  5. Click on wp-option.



  6. Find two rows name template and stylesheet and click on edit one by one.

  7. Change the new theme from the old theme in option_value.





  8. Click on the Go button to save changes.

          This is it, you have changed the Wordpress theme from the phpMyAdmin Database successfully.

  • 0 Users Found This Useful

Was this answer helpful?

Related Articles

How to Set Up Wordpress Pretty Permalinks in a Windows Environment Running IIS?

Default Wordpress URL looks like http://mydomain.com/?p=123. It is not a user-friendly SEO URL....

How to schedule post publishing in WordPress?

In this article, we will show you how to schedule posts in WordPress Using this function you can...

How to Fix the 500-Internal Server Error in WordPress?

So you have been receiving 500 Internal Server Error in your WordPress website? Don’t panic, have...

How to add LiteSpeed cache for Wordpress Website in cPanel?

First of all, we need to know about Browser Caching. Whenever user accesses any page of the...

How To Fix An Error "The Uploaded file could not be moved to WP-Content/Uploads" folder?

Sometimes you receive following error while trying to upload new Media/Images to your WordsPress...