How to Change Theme Without Login To WordPress Admin Area !!!

Check the database name from wp-config.php file.

Backup the database using the following command from shell.

cPanel

 mysqldump database_name > database_name.sql

Plesk

mysqldump –opt -uadmin -p`cat /etc/psa/.psa.shadow` database_name > database_name.sql

Now, login to phpmyadmin and select the database_name.

In the database click on table wp_options .

In wp_options click on Sql tab .

Execute the following queries for finding out the current theme enabled for wordpress site.

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

Now, execute the following query for changing the theme for wordpress site.

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’;

Replace default with theme name.

Check the theme again by running below command.

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