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 Hosting / Managed WordPress).

2. Click on the database you want to manage.
3. Click on the wp_options table.
4. Under the option_name column, locate the template entry. You may need to navigate beyond the first page of 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(ex. twentyseventeen).
10. To save, click Go.

More info

• Return to Install, change or update a theme in WordPress