Categories: Hostripples Featured

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

 

 


Vishwajit Kale
Vishwajit Kale blazed onto the digital marketing scene back in 2015 and is the digital marketing strategist of Hostripples, a company that aims to provide affordable web hosting solutions. Vishwajit is experienced in digital and content marketing along with SEO. He's fond of writing technology blogs, traveling and reading.

Recent Posts

This Diwali, Give Your Website the Glow It Deserves — Host Smarter,Rank Higher

Every Diwali Brings New Light, New Beginnings, and New Opportunities In today’s digital world, your website is the Diya that…

6 days ago

What Are the Best WordPress Photo Gallery Plugins for 2026?

Photography is not just about taking pictures—it’s about presenting them beautifully. For photographers and creative bloggers, WordPress photo gallery plugins…

3 weeks ago

How Can You Prepare Your Ecommerce Site/blog for Festivals?

Festivals are more than cultural celebrations—they’re golden opportunities for e-commerce stores and bloggers to attract, engage, and convert audiences. During…

4 weeks ago

Shared Hosting: Migrating Your Site Seamlessly

If you’re new to web hosting, the idea of moving your website from one provider to another might sound intimidating.…

1 month ago

Top 15 WooCommerce Plugins to Power Your eCommerce Store in 2025

WooCommerce powers over 5 million online stores, and its true potential comes alive with plugins that enhance functionality. The right…

1 month ago