There are situations where we may not be able to access the WordPress admin panel due to various issues, such as a broken theme, plugin conflicts, or login problems.<\/p>\n\n\n\n
In such cases, we can change the active WordPress theme directly from the backend using MySQL\/MariaDB<\/strong>. This can be done through phpMyAdmin<\/strong> or the MySQL\/MariaDB command line.<\/p>\n\n\n\n In this article, we will explain how to change the active WordPress theme from the backend.<\/p>\n\n\n\n Before proceeding, make sure you have:<\/p>\n\n\n\n Log in to the server through SSH, or access the WordPress database using phpMyAdmin<\/strong> or the MySQL\/MariaDB command line<\/strong>.<\/p>\n\n\n\n Before making any database changes, it is recommended to take a backup of the WordPress database.<\/p>\n\n\n\n In this example, we are going to activate the Make sure the corresponding theme directory exists:<\/p>\n\n\n\n If you want to activate a different theme, replace Run the following queries against the WordPress database:<\/p>\n\n\n\n If your WordPress database uses a custom table prefix, replace For example, if the table prefix is After executing the queries, access the WordPress website and verify that the new theme is active.<\/p>\n\n\n\n If the website is using caching, clear the relevant WordPress, server, or CDN cache before testing.<\/p>\n\n\n\n Changing the WordPress theme directly from the backend is useful when the WordPress admin panel is inaccessible. By updating the relevant values in the Always make sure that the theme directory exists under Yes. The active theme can be changed directly through the WordPress database using phpMyAdmin or the MySQL\/MariaDB command line.<\/p>\n\n\n\n WordPress themes are normally stored under:<\/p>\n\n\n\n Replace For example:<\/p>\n\n\n\n How to do WordPress website migration from domain to subdomain – Pheonix Solutions<\/a><\/p>\n\n\n\nPrerequisites<\/h2>\n\n\n\n
\n
wp-content\/themes\/<\/code><\/pre>\n\n\n\nImplementation<\/h2>\n\n\n\n
Step 1: Access the WordPress Database<\/h3>\n\n\n\n
Step 2: Identify the Theme<\/h3>\n\n\n\n
twentysixteen<\/code> theme.<\/p>\n\n\n\nwp-content\/themes\/twentysixteen<\/pre>\n\n\n\n
twentysixteen<\/code> with the appropriate theme directory name.<\/p>\n\n\n\nStep 3: Update the WordPress Theme<\/h3>\n\n\n\n
UPDATE wp_options SET option_value = 'twentysixteen' WHERE option_name = 'template';
UPDATE wp_options SET option_value = 'twentysixteen' WHERE option_name = 'stylesheet';
UPDATE wp_options SET option_value = 'twentysixteen' WHERE option_name = 'current_theme';<\/pre>\n\n\n\nwp_options<\/code> with the appropriate table name.<\/p>\n\n\n\nwpabc_<\/code>, use:<\/p>\n\n\n\nUPDATE wpabc_options SET option_value = 'twentysixteen' WHERE option_name = 'template';
UPDATE wpabc_options SET option_value = 'twentysixteen' WHERE option_name = 'stylesheet';
UPDATE wpabc_options SET option_value = 'twentysixteen' WHERE option_name = 'current_theme';<\/pre>\n\n\n\nStep 4: Verify the Website<\/h3>\n\n\n\n
Conclusion<\/h2>\n\n\n\n
wp_options<\/code> table, we can activate an existing theme without accessing the WordPress dashboard.<\/p>\n\n\n\nwp-content\/themes\/<\/code> and take a database backup before making direct database changes.<\/p>\n\n\n\nFAQs<\/h2>\n\n\n\n
1. Can I change the WordPress theme without accessing the WordPress admin panel?<\/h3>\n\n\n\n
2. Where are WordPress themes stored?<\/h3>\n\n\n\n
wp-content\/themes\/<\/pre>\n\n\n\n
3. What should I replace
twentysixteen<\/code> with?<\/h3>\n\n\n\ntwentysixteen<\/code> with the theme directory name<\/strong> of the theme you want to activate.<\/p>\n\n\n\nUPDATE wp_options SET option_value = 'astra' WHERE option_name = 'template';<\/pre>\n\n\n\n
Related Article<\/h3>\n\n\n\n