Change WordPress Theme From Database or phpMyAdmin

Change WordPress Theme Using phpMyAdmin or Activate WordPress Theme Using Database directly -To debug WordPress Theme Issues, to solve the problem of the WP Admin Area or to fix any other incompatibility problem in WordPress, we need to use this WordPress trick to change theme directly from Database or phpMyAdmin.

Sometimes new changes such as plugins or updates are simply not compatible with your current theme. Often, with this incompatibility, you are unable to enter the admin area to switch the theme.

This can leave you in a circular problem as you need to change the theme in order to get into the admin area. In this scenario, you will need to change it directly from the database.

Also read – How to change Website domain name without hurting SEO?

This article will guide you on how to change WordPress Theme from phpMyAdmin or Database step by step.

Change WordPress Theme Using phpMyAdmin

You can activate your WordPress theme from within the database. This is helpful if you can’t access WordPress due to an issue with your theme.

Steps that can be followed –

1. Log into phpMyAdmin (cPanel / Plesk / Web Hosting / Managed WordPress).
2. Click on the database you want to manage.
3. Click on the wp_options table. In our case it was wprv_options. Make sure to check for _options.
4. Under the option_name column, locate the template entry. You may need to navigate beyond the first page of the entries.
5. Click Edit next to the template entry.
6. In the option_value column, change the value to the name of your theme. The new value must be the same as your theme’s folder name.
7. To save, click Go.
8. Click Edit next to the stylesheet entry.
9. In the option_value column, change the value to the name of your theme (or child theme, if you’ve previously created one). The new value must be the same as your theme’s folder name in File Manager(ex. Astra).
10. To save, click Go.

You are done with the process here. Now if you reload your website you will see the new theme there.

Now, check if your WordPress problem is resolved or not. If not you can contact us directly to get it fixed. We will help you to fix all your WordPress and Server issues like deleting old backup from WHM Server.

We have also made a tutorial on activating theme from database. Watch this and follow the steps accordingly.

Activate Theme from Database or phpMyAdmin – YouTube Tutorial

• DomainRacer Hosting Review (2024-2025)November 14, 2024
• You can do it too: Practical SEO Guide for Beginners in 2022February 17, 2022
• Top 7 secrets of super-successful video marketingFebruary 11, 2022
• Reasons to Hire a Senior Living Marketing Company in SacramentoJanuary 5, 2022
• What are the Benefits of using a paraphrasing app on an Android smartphone?November 10, 2021
• A Guide to Programmatic Direct MailOctober 27, 2021

Thanks for reading. Now we bet that you know how to change or activate WordPress Theme from Database or phpMyAdmin. Let us know if you have any queries.

Have a Good Day. Happy Blogging!