How to Change WordPress Theme in the Database via phpMyAdmin
Sometimes, a theme or plugin update can cause problems that break your site and block access to the WordPress dashboard. When this happens, one safe way to get your site working again is to change the WordPress theme in the database to a default theme—like Twenty Twenty-Four—using a tool called phpMyAdmin. Don't worry if you're not a developer; this article will guide you step-by-step to restore clear and safe access to your website.
When to Use This Method
- You updated a theme or plugin and now get a white screen or error.
- You're locked out of wp-admin due to theme incompatibility.
- You're debugging issues and need to revert to a known working theme.
/wp-content/themes/ folder via File Manager. You can also find your current theme in the /wp-config.php file.Change WordPress Theme in Database
- Log in to your Bluehost Account Manager.
- In the left-hand menu, click Websites.
- Click the MANAGE button located next to the website you want to manage.
- In the website overview page, click the PHPMyAdmin button.
- In phpMyAdmin, locate and click your WordPress site's database in the left sidebar.
To determine which database your WordPress site uses, check the wp-config.php file or refer to this article: How to Find Your WordPress Database.
- Click the
wp_optionstable (the prefix may vary, e.g.,example_options).
- Click the Browse tab.
- Check the box for Show All to view more rows.
- Locate these two rows:
templatestylesheet
- Click Edit on each, and in the option_value field, enter a default WordPress theme like
twentytwentyfour,twentytwentythree, etc.
- Click Go to save changes.
Once both fields are updated, visit your site. You should now be able to access the dashboard using the new default theme.
Related Articles
Summary
Changing your WordPress theme through the database is a reliable solution when you're locked out of your admin dashboard due to theme-related issues. By using phpMyAdmin to update the template and stylesheet values in the wp_options table, you can safely restore access to your site. Just remember to back up your database before making any changes—and if you're unsure, don't hesitate to contact our support team for help.
If you need further assistance, feel free to contact us via Chat or Phone:
- Chat Support - While on our website, you should see a CHAT bubble in the bottom right-hand corner of the page. Click anywhere on the bubble to begin a chat session.
- Phone Support -
- US: 888-401-4678
- International: +1 801-765-9400
You may also refer to our Knowledge Base articles to help answer common questions and guide you through various setup, configuration, and troubleshooting steps.