How to Change a WordPress Theme in MySql (PhpMyAdmin)

New plugins or theme updates can brings new issues or errors in your current theme. Sometimes you need to change your theme or reset the password directly in the database because you are unable to enter the WordPress admin area to switch the theme. This article will help you on how to change a WordPress theme in MySQL database.

To change WP theme in PhpMyAdmin follow these steps:

  1. Log in inside the phpMyAdmin and look to the left hand sidebar. Select and click on your specific WordPress database.
  2. From your WordPress database, select the wp_options table.
  3. Look to the horizontal tab menu on the screen and click on the Browse tab option (by default you are in this tab right now).
  4. Under the option_name column, find the template and stylesheet entries. You may find these records on the second page.

    template and stylesheet entries
    template and stylesheet entries
  5. Click on the Edit button in the same row with the template entry.
  6. Change the value to the name of your theme (the name must be the same as your theme’s folder name) in the option_value column.
  7. Save it.
  8. Do the same thing with the stylesheet entry.

Now is your WordPress theme activated from within the database.

Recent Articles

How to Hide Shipping Methods in WooCommerce?

This is a small detail, but WooCommerce doesn't have built-in any function for hiding shipping methods based on different situations. Imagine when...

How to Get WordPress Post Featured Image URL

Are you a WordPress developer or an advanced WordPress user? Whoever you are, sometimes you may need the direct URL of a...

How to Bulk Delete Media in WordPress

WordPress and media. That's the topic for a book. Sometimes is not easy to find what you need and when you have...

Custom Order Number for WooCommerce Will Saves You a Lot of Hassle!

WordPress is still the king of Content Management Systems (CMS). Thanks to its open-source nature, millions upon millions of users and PHP...

How to Manually Sort WooCommerce Products

WooCommerce is an e-commerce plugin for WordPress. It is a great way for the user to create an online store for their...

Get in touch

Be our first-class reader, build a community and follow us on social media!

Leave A Reply

Please enter your comment!
Please enter your name here