How to change wordpress theme directly from database?

I had some error in my new wp theme. When I enabled the new theme, I got a blank page. I was unable to access my wordpress blog both from frontend and backend (admin panel).

In this case, either I need to change/fix my theme’s code. But, what if I am not a coder?

The solution is to change the currently active theme from database.

Open phpMyAdmin, go to your wp database. Open wp_options table. Search for three option_name – template, stylesheet, and current_theme.

SELECT *
FROM wp_options
WHERE option_name = 'template'
OR option_name = 'stylesheet'
OR option_name = 'current_theme';

See the option_value fields from the search result. The option_value will be your theme name. Change option_value of the search result to ‘classic’ OR ‘default’. Classic and default are the default wordpress themes present at the time of wp installation.

UPDATE wp_options SET option_value = 'default' WHERE option_name = 'template';
 
UPDATE wp_options SET option_value = 'default' WHERE option_name = 'stylesheet';
 
UPDATE wp_options SET option_value = 'default' WHERE option_name = 'current_theme';