InMotion Hosting Support Center

Sometimes new changes such as plugins or updates are simply not compatible with your current theme. Often, with this incompatibility you are unable to enter the admin area to switch the theme. This can leave you in a circular problem as you need to change the theme in order to get into the admin area. In this scenario you will need to change it directly in the database. This article will guide you on how to do that within your WordPress site.

Changing your theme within phpMyadmin

  1. Log into your cPanel interface.
  2. Look for the Databases category and click on the phpMyadmin icon.
  3. Once inside the phpMyadmin look to the left hand sidebar and click on your specific wordpress database.
  4. From there, select the wp_options table.
  5. Once the table is opened, look to the tab menu on the screen and click on the Browse tab option. This allows you to browse the columns broken down into pages. Click on the Show All option at the top so it will list all the columns on one page.
  6. Next, you will need to locate two rows on the page, the template and the stylesheet. Pick template and click on the Edit link.
  7. This will take you to the edit page where we will change the data for the option_value. In our example, the value is set for the alexandira template. Change this to the default theme name, twentythirteen and click on the Go button at the bottom of the page.
  8. Perform the same procedure on the stylesheet row. When you finish the stylesheet and return to the list, you should see the new theme in the value portion of the list for both. You can now visit your website and see that it is using the default theme. From here you should also be able to log into your wp-admin area.
    BeforeAfter
Continued Education in Course WordPress
You are viewing Section 7: 345: How to change a theme via the database
Section 6: 346: Fixing 3.7 redirect error in Wordpress
Section 8: 344: Moving a WordPress Installation to a Different Location

Support Center Login

Social Media Login

   
Social Login Joomla

Related Questions

Here are a few questions related to this article that our customers have asked:
Ooops! It looks like there are no questions about this page.
Would you like to ask a question about this page? If so, click the button below!
Ask a Question
n/a Points
2014-09-04 12:04 am

what about if i want to go back to my old themes? is it the same process ? 

Staff
25,902 Points
2014-09-04 8:10 am
Hello Rey,

Yes, you would use the same process to enter the name of your old theme.

Kindest Regards,
Scott M
n/a Points
2014-10-16 4:10 pm

Thanks a lot.  Helped me out of a jam and got me going again.

There may be serveral references in the article to "column" when I think what was meant was "row" ?

Staff
15,661 Points
2014-10-16 4:51 pm
Hello Tray,

Thank you for your comment. I removed/changed some of the incorrect instances of "column" in the article.

If you have any more suggestions, let us know.

Thank you,
John-Paul
n/a Points
2014-12-11 5:04 am

Don't forget to mention that you will need to use the theme's 'text_domain' as the name, because the actual name won't work.

n/a Points
2015-03-04 3:10 am

Index of /

  • bcis/
  • cgi-bin/
Apache Server at bluechipinfosystem.in Port 80 how to set default wordpress theme in cpanel  please help me 
Staff
25,902 Points
2015-03-04 7:02 am
Hello Ajay,

This error is beyond just a theme issue. It means the directory you are viewing has no index page. This could indicate the program was installed in the wrong directory. If you need help understanding BlueHosts's folder structure you will want to contact them to find out what your 'directory root' is for your website so the program can be installed there.

Kindest Regards,
Scott M
n/a Points
2015-05-04 3:04 am

thank you so much. i mean it.

Post a Comment

Name:
Email Address:
Phone Number:
Comment:
Submit

Please note: Your name and comment will be displayed, but we will not show your email address.

8 Questions & Comments

Post a comment

Back to first comment | top

Need more Help?

Search

Ask the Community!

Get help with your questions from our community of like-minded hosting users and InMotion Hosting Staff.

Current Customers

Chat: Click to Chat Now E-mail: support@InMotionHosting.com
Call: 888-321-HOST (4678) Ticket: Submit a Support Ticket

Not a Customer?

Get web hosting from a company that is here to help. Sign up today!