Explore our in-depth
crafted by
skilled professionals!

Our Latest News, Advice and Thoughts

How to Change WordPress Theme by Editing Database?

You are here:

Usually we alter a WordPress theme from our WordPress dashboard. Inn some circumstances, updating a plugin just isn’t appropriate with our present theme, so we have to swap our WordPress theme. In such conditions the one option to change the theme is manually from the database.


Steps to vary the WordPress theme inside phpMyAdmin

1) Log into cPanel.

2) Navigate to FileManager below ‘Information’ part.

Change Theme


3) Open ‘wp-config.php’ file and test the database identify.

Change Theme


4) Navigate to phpMyAdmin below ‘Databases’ and open the database for the WordPress web site.

5) Open wp-options desk from the database.

Change Wordpress Theme


6) Find and open two rows known as the template and the stylesheet.

Change Theme


7) Open each template and the stylesheet. Then substitute the present theme by including the brand new theme in option_value.

Change Theme


8) Click on “Go” to allow modifications.


You’ll be able to change the WordPress theme by the terminal utilizing the next steps.

1)  Login to the server utilizing SSH command.

2) Add the theme within the theme folder.

3) Login to MySQL utilizing the beneath command.

# mysql -u root -p

4) Swap to web site database

5) Test the present theme which is utilized in WordPress web site utilizing the next command.

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

6) Now replace the WordPress theme utilizing the bellow command.

UPDATE wp_options SET option_value = ‘Themename’ WHERE option_name = ‘template’;


Should you want any additional assist please contact our assist division.



Leave a Comment