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