How to change WordPress theme via phpMyAdmin?

Changing a WordPress theme via phpMyAdmin is not recommended, as it can be risky and can cause issues with your website if not done correctly. However, in certain condition, you may require to change WordPress theme directly from the database. In this article, we will discuss step by step guideline to change the WordPress theme directly from the database.

Considering you have phpMyAdmin access for your WordPress database, you can start with the following steps:

1. Log in to your hosting account and access phpMyAdmin.
2. Locate your WordPress database and select it.
3. Look for the “wp_options” table and click on it.
4. Search for the “template” and “stylesheet” rows and edit their values to the name of the new theme you want to use.
5. Click the “Go” button to save the changes.
6. Log in to your WordPress dashboard and check if the new theme is applied correctly.

However, as mentioned earlier, changing a WordPress theme via phpMyAdmin is not recommended, and it’s safer to do it via the WordPress dashboard. If you’re not comfortable with the technical aspects of your WordPress site, it’s better to seek help from a professional or use a plugin to switch themes.