Search

HostGator Web Hosting Help

Changing WordPress Themes From the Database

Sometimes, updates made to WordPress or Plugins may break your site due to incompatibilities with your Theme. In most cases, this will prevent you from being able to access the Admin Dashboard, and the Theme will need to be updated to fix any errors. This guide will walk you through updating your WordPress Theme from the Database if you cannot access the Admin Dashboard.

Accessing phpMyAdmin

These steps will vary depending on which interface your account is using. Once logged in, click the Hosting tab at the top of the account.

Classic

  1. Click on the cpanel sub-tab.
  2. Click on the phpMyAdmin icon in the database tools section.

Bluerock

  1. Click the Advanced tab on the left side of the screen.
  2. Click on the phpMyAdmin icon in the Databases section.

Once you have opened phpMyAdmin, choose the database the WordPress site in question is using. Click the + icon next to your username to expand if you do not see a list of databases in the sidebar on the left.

Setting a New Theme

  1. Select the wp_options table.
  2. Once loaded, click on the Browse tab. This allows you to browse the columns broken down into pages.
  3. Check the box to Show All
  4. Locate the template and stylesheet settings. Click Edit.
  5. In the option_value setting, replace the current theme with a default theme (Twentyfifteen, Twentysixteen, etc.).
  6. Click Go to save when you are finished.

Once updated, your WordPress site and Admin Dashboard should be accessible.



Was this resource helpful?
Helpful Unhelpful


Did this resolve your issue?
Solved Unsolved


Please add any other comments or suggestions about this content:





Recommended Help Content

How To Install A New WordPress Theme - Manual Theme Installation
Install Themes These steps will help you install and select a WordPress theme for your blog. Inside the WordPress Dashboard, select the Add New Themes link in the Appearance Menu. You can search for
Getting Started Article 884,282 views tags: install link theme themes wordpress

How To Disable Or Delete Plugins / Themes On A Disabled WordPress Site
This article explains how to deactivate, change or delete themes and plugins on a WordPress site without the dashboard.
Knowledgebase Article 321,178 views tags: access dashboard deactivate disable plugin plugins theme themes wordpress

WordPress - What are Premium Themes?
A free theme can be a good fit if your goal is to simply run a blog. Consider a premium theme if you plan to have more functionality and/or flair, such as an eCommerce site.
Knowledgebase Article 119,073 views tags: Marketplace premium themes wordpress

Related Help Content

WordPress - Getting Started with Themes
This guide will walk you through getting your WordPress theme set up so that you can quickly get to the fun part - customizing your site!
Knowledgebase Article 113,799 views tags: demo guide setup theme wordpress

The first step in the process requires a WordPress theme, preferably one that includes a one-click demo import. Any of the HostGator Certified Themes on HostGator should come with this feature.
Knowledgebase Article 117,572 views tags: MOJO Marketplace demo install press setup theme word wordpress

There are multiple different ways you can install a theme you have purchased for your WordPress site. This article will explain our two recommended methods for installation.
Knowledgebase Article 131,921 views tags: auto automatic certified download install manual premium themes update upload wordpress

Manually Changing the Domain of Your WordPress Site
How to change the name of your WordPress site without WP Tools
Knowledgebase Article 274,195 views tags: change domain update wordpress

Change WordPress URL's With WordPress Tools
This article will explain how to change the Site URL or Home URL setting in WordPress. This may be useful if you have moved your WordPress site or are planning to move your WordPress site.
Knowledgebase Article 298,670 views tags: home site url wordpress wordpresstools

When you purchase a theme subscription you get access to Seller Support, the Theme Seller’s support forum. From there you can contact the theme developer for help with general theme-related issues.
Knowledgebase Article 99,057 views tags: author seller support themes wordpress

There’s a wide variety of themes available within the WordPress community, and we have taken extra steps to vet our themes for high quality.
Knowledgebase Article 151,021 views tags: Marketplace certified install premium setup themes wordpress

Whether you’re starting from scratch or updating an existing website, choosing the right theme will make it easier to create a professional-looking site and achieve your online goals.
Knowledgebase Article 146,878 views tags: Marketplace certified premium themes tips wordpress