Home » Categories » Managed WordPress » Advanced

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.
  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.
1 (3)
Article Rating (3 Votes)
Rate this article
  • Icon PDFExport to PDF
Related Articles
Install a WordPress plugin with FTP
Added on Tue, Nov 17, 2020
Preview your website using hosts files
Added on Tue, Nov 17, 2020
Update a WordPress plugin with FTP
Added on Tue, Nov 17, 2020
Optimize table in MySQL
Added on Tue, Nov 17, 2020
Change a WordPress theme with SSH
Added on Tue, Nov 17, 2020