How to change a theme without login to WordPress Admin Area
In this tutorial I will show you how to change a 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’;