Select Page

How to Change WordPress themes using Database?

Some times you come across a situation that you cant access your site for some reason.

For example I had a bug in my theme’s functions.php file and I could not even access my wp-admin. Only solution was to change the current theme to the site working again.

So If you need to change the theme via database, all you need to do is make changes in two rows in wp-options table.

Look for the rows with option name ‘template’ and ‘stylesheet’ and change the option value to the directory name of the theme you want to select.