Articles on: cPanel Tutorial

How to Change WordPress Theme via phpMyadmin

Login to the cPanel, look for the Databases section and click on phpmyadmin

Select your WordPress database. (If you aren’t sure which database to select, check your wp-config.php file in the root location of your WordPress installation). In this example, I'm using my Wordpress database "joshipro_wptest1".

Expand the database and select the ‘wp_options’ table (if you have another table prefix ‘tableprefix_options’). In this example, my wp_options is wptest1_options

Select page 2 from the tables header.

Now you’ll need to click 'Edit' to make change on the ‘template’ and ‘stylesheet’ rows.

Insert in the name of the template you wish to assigned to the WordPress e.g. twentyseventeen and press “Go” when you are done as per below.

Repeat the same step 6 for the other row and that's all. You've completed the changes. You may clear cache and browse your WordPress site now to check on it.

Updated on: 15/08/2018

Was this article helpful?

Share your feedback


Thank you!