Change a WordPress theme in the database

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.

  1. Log into phpMyAdmin (cPanel / Plesk / Web & Classic / Managed WordPress).

    Note: If you're using cPanel Hosting, you must select the database for your WordPress site in the left-hand column before proceeding to the next step.

  2. Click on the wp_options table.
  3. Under the option_name column, locate the template entry. You may need to navigate beyond the first page of entries.
  4. Click Edit next to the template entry.
  5. 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.
  6. To save, click Go.
  7. Click Edit next to the stylesheet entry.
  8. 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(ex. twentyseventeen).
  9. To save, click Go.

More info


Was This Article Helpful?
Thanks for your feedback. To speak with a customer service representative, please use the support phone number or chat option above.
Glad we helped! Anything more we can do for you?
Sorry about that. Tell us what was confusing or why the solution didn’t solve your problem.