How to Change WordPress Theme Editing MySql Tables

by Raghu on March 2, 2010

Follow the simple steps to change the WordPress Theme ny editing MySql Tables(WordPress database). You might run into situations when you have access to only backend.

Change WordPress Theme

  • Logn into MySQL Database for your site (Example : msql.example.com)
  • Open the Database for your site ( DB_example)
  • Open the Table wp_options
  • Open Browse Tab
  • Find the option’s template and stylesheet
  • Edit the value to theme name you want to change (Example : default)
  • Save the table

If some plugin have corrupted the theme files, using above change, you can set the default theme.

{ 4 comments… read them below or add one }

Bastian January 29, 2011 at 9:45 am

Thanks for this Tutorial, i fall into Panic as i delete my Theme. Now i have changed it over the SQL Database, thank You! =)

Rico April 1, 2011 at 8:11 am

I tried that, but it didn’t work. :-(

Thomas January 6, 2012 at 4:14 am

thx! you saved my life ^^

Raghu January 7, 2012 at 4:16 pm

This saved my life couple of times :)

Leave a Comment

Previous post:

Next post: