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.
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 ? 

31,565 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" ?

19,934 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,
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 Port 80 how to set default wordpress theme in cpanel  please help me 
31,565 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.

n/a Points
2015-06-29 9:27 am

Thank you so much

n/a Points
2015-07-02 4:42 pm

I never comment because I am a weird sort of person. But you are a life safer. Thank you very much sir. You saved my work.

I installed a theme which was corrupt and I didnt even have the backup.

You rock. thanks again.

n/a Points
2015-07-15 9:42 pm

I followed the steps and it works, however my second problem now is all of the assets are 404, couldn't read the css, js and images. PLease help.I'm using wordpress from GoDaddy.

19,934 Points
2015-07-16 10:32 am
Hello Ricky,

Thank you for contacting us about 404 errors after changing your theme. We are happy to help, but will need some additional information. Did you try the Common WordPress Troubleshooting Techniques?

Have you tried changing the permalinks? For example, changing to a different option, then changing back.

What theme were you installing? What theme did you have before?

Can you provide a link to the site, so we can view the error?

Thank you,
n/a Points
2015-08-25 4:07 pm

Hello, I have read just about everything there is to read about changing a theme in wordpress. My problem is that our wordpress is connected to a cpanel (not so tough, right) so that I should be able to follow all the steps above and change it to a new theme. It works as far as going to the new theme, however, my question is, do I have to fine tune the new theme? Our Cpanel is run through a company, however, I have access to it, and have been playing around with it. I see that I can change the theme either on the Cpanel or through wordpress. What I don't see is all the changes happen.

7,033 Points
2015-08-25 8:45 pm
Hello Tracy,

When you make any changes to the theme and you are not seeing changes then your browser may be cached. Please be sure to clear your browsers cache and wordpress cache (if you have a caching plugin enabled).

Best Regards,
TJ Edens
n/a Points
2015-08-26 11:54 am

Thank you TJ, however, I did follow all of the previous comment/suggestions before I contacted your site. Like in my previous comment, I have gone into the Cpanel as well as just wordpress and tried to make changes. As easy as it is for anyone else to do it, it just seems so compicated when I try to. Either I have to take the new theme and "tweek" it to my liking or it doesn't work at all. All of the main themes are downloaded into the cpanel and when I have followed the instructions previously the new theme doesn't act correctly. I was under the impression that if all of the files are in the cpanel and the themes are there, I should be able to just change the theme and bam! New theme. What else could I be doing wrong?

Thank you so much in advance. 

28,447 Points
2015-08-26 1:44 pm
Hello Tracy,

Unfortunately, you're not giving us any specifics about what you're doing. How are you making changes to a theme? Are you changing them in the editor? Are you making changes with the WordPress interface? What theme are you referring to? Many custom themes have different interfaces that may affect how they are modified. Please give us some further info in order for us to help you .

Arnel C.
n/a Points
2015-08-27 1:23 pm

I was trying to change from the Ultimatum theme to any of the themes that come with Word press. I tried twenty thirteen, blank canvas, etc. I have tried to change them through the c-panel just as the instructions above have stated and also tried directly through wordpress itself. What I'm not sure of is do I have to put the integration link into the pages or should things roll over because they are in the c-panel. Again, we don't control the c-panel, but we do have access to it.

19,934 Points
2015-08-27 3:55 pm
Hello Tracy,

Thank you for contacting us. All of the options you described should work for changing your WordPress theme.

Your WordPress theme should change immediately, unless you are using some type of caching.

You may also have to clear your browser cache to update your view.

Thank you,
n/a Points
2015-10-03 3:23 am

Hello thank you but this is my own problem. i have been trying to solve it. oplease help

Warning: require(/home/softimpa/public_html/wp-includes/functions.php) [function.require]: failed to open stream: No such file or directory in/home/softimpa/public_html/wp-settings.php on line 72Fatal error: require() [function.require]: Failed opening required '/home/softimpa/public_html/wp-includes/functions.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/softimpa/public_html/wp-settings.php on line 72

31,565 Points
2015-10-05 10:05 am
Hello Aity,

The error message "No such file or directory" means that either a path is incorrect or the file is missing. Did you move the installation over from another location? Did you do an update?

Kindest Regards,
Scott M
n/a Points
2015-10-10 10:14 pm

Thank you , thank you so much. I was about to delete all the hard work i had done.

n/a Points
2015-11-11 3:11 pm

This worked for me. Although, once you're in the theme I had to go to the /wp-admin (dashboard) and activate a different theme, and re-activate the theme that I wanted after. There were some lingering issues that it was reading the old theme if I didn't do it this way.

n/a Points
2015-11-27 6:35 am

Thanks, that worked just perfectly. Client managed to kill their website by deleting the active child theme.

Post a Comment

Email Address:
Phone Number:

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

23 Questions & Comments

Post a comment

Back to first comment | top

Need more Help?


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:
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!