Change WordPress Theme From Database or phpMyAdmin

Ask Me How To / WordPress Hacks

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.

Change WordPress Theme From database or PhpMyAdmin
Change WordPress Theme From database or PhpMyAdmin

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

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!

Comments (8)

  1. Bunny kopare

    Thank you for sharing theme change information I was totally confused. but, you solved my problem.

    1. User Avatar


  2. Ubeid Khan

    Hi Ravi, Nice Blog, I have a WordPress website on Lonavala hill station. Thanks for sharing all the good work.

    1. User Avatar

      I am glad that you liked it.

  3. Kirubaharan

    Thank you pretty much for sharing the massive information to us. It is very useful and informative.
    Please keep blogging new updates. Thanks.

  4. Deepak

    Hi Ravi,

    I’m a big fan of your site and YouTube channel,

    by the way, I’m still new to this whole blogging world but I have 2-year experience in web development so, getting some exposure to my tiny blog would be awesome.

    I was wondering if I could contribute a guest post for your blog.

    Here are some ideas that I think your audience would really like:

    1) Design using Html & CSS

    2) Php Course 

    3) JS Design

    Let me know what you think and I’d be happy to get started right away.


    Deepak Singh Rawat 😊

  5. Ranvir Raushan

    Yes! I am very happy to see your New Website Looks … (Professional)

    1. User Avatar

      Hi Raushan,

      Thanks for the wonderful observation.

Comments are closed.