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".
![](https://storage.crisp.chat/users/helpdesk/website/0e35a1b5-ce97-4d12-a27e-1bbafd0ae641/2a5717cc-f0f9-4c41-9ffd-07d5fd6a5c6d.png)
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.
![](https://storage.crisp.chat/users/helpdesk/website/0e35a1b5-ce97-4d12-a27e-1bbafd0ae641/e7c25203-c452-42eb-9b15-af389d1fe2bf.png)
Now you’ll need to click 'Edit' to make change on the ‘template’ and ‘stylesheet’ rows.
![](https://storage.crisp.chat/users/helpdesk/website/0e35a1b5-ce97-4d12-a27e-1bbafd0ae641/7e1fa100-1aea-4793-9048-7abacb6b2bd6.png)
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.
![](https://storage.crisp.chat/users/helpdesk/website/0e35a1b5-ce97-4d12-a27e-1bbafd0ae641/d5f08c62-8abd-48d0-9790-df3e4323828f.png)
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.
![](https://storage.crisp.chat/users/helpdesk/website/0e35a1b5-ce97-4d12-a27e-1bbafd0ae641/526e5d3a-d947-467a-b65f-c4fb357b6d20.png)
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".
![](https://storage.crisp.chat/users/helpdesk/website/0e35a1b5-ce97-4d12-a27e-1bbafd0ae641/2a5717cc-f0f9-4c41-9ffd-07d5fd6a5c6d.png)
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.
![](https://storage.crisp.chat/users/helpdesk/website/0e35a1b5-ce97-4d12-a27e-1bbafd0ae641/e7c25203-c452-42eb-9b15-af389d1fe2bf.png)
Now you’ll need to click 'Edit' to make change on the ‘template’ and ‘stylesheet’ rows.
![](https://storage.crisp.chat/users/helpdesk/website/0e35a1b5-ce97-4d12-a27e-1bbafd0ae641/7e1fa100-1aea-4793-9048-7abacb6b2bd6.png)
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.
![](https://storage.crisp.chat/users/helpdesk/website/0e35a1b5-ce97-4d12-a27e-1bbafd0ae641/d5f08c62-8abd-48d0-9790-df3e4323828f.png)
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
Thank you!