{"id":1195,"date":"2020-09-22T08:58:21","date_gmt":"2020-09-22T08:58:21","guid":{"rendered":"https:\/\/blog.hostinger.io\/support\/2020\/09\/22\/4469298-how-to-change-wordpress-theme-via-phpmyadmin-at-hostinger\/"},"modified":"2026-03-16T12:12:13","modified_gmt":"2026-03-16T12:12:13","slug":"4469298-how-to-change-wordpress-theme-via-phpmyadmin-at-hostinger","status":"publish","type":"post","link":"https:\/\/www.hostinger.com\/support\/4469298-how-to-change-wordpress-theme-via-phpmyadmin-at-hostinger\/","title":{"rendered":"How to Change WordPress Theme via phpMyAdmin at Hostinger?"},"content":{"rendered":"<p class=\"no-margin\">If you don&rsquo;t have access to the WordPress administrator page and wish to change your website&rsquo;s theme, just follow these steps:<\/p><p class=\"no-margin\">\n<\/p><h2 id=\"step-1---open-file-manager\">Step 1 &ndash; Identify your WordPress database<\/h2><p class=\"no-margin\">Navigate to <b><a href=\"\/support\/4548688-basic-actions-in-file-manager#h_0f7a938593\" target=\"_blank\" class=\"intercom-content-link\">File Manager<\/a><\/b>, and open the <b>wp-config.php<\/b> file inside your <b>public_html<\/b> directory. The name of the database for your website is shown in the <b>DB_NAME<\/b> line:<\/p><p class=\"no-margin\">\n<\/p><div class=\"intercom-container intercom-align-center\"><img decoding=\"async\" src=\"\/support\/wp-content\/uploads\/sites\/55\/2020\/09\/552eca18-3929-4ba7-a787-7147f0f1b625.jpg\"><\/div><p class=\"no-margin\">While you are at <b>File Manager<\/b>, be sure to check all the available themes you currently have on the <b>\/wp-content\/themes<\/b> directory:<\/p><p class=\"no-margin\">\n<\/p><div class=\"intercom-container\"><img decoding=\"async\" src=\"\/support\/wp-content\/uploads\/sites\/55\/2020\/09\/7aec6a38-f78f-4cc4-acfb-e13c988ccc0b.jpg\"><\/div><h2 id=\"step-2---open-phpmyadmin\">Step 2 &ndash; Open phpMyAdmin<\/h2><p class=\"no-margin\">Go to the Databases &rarr; <b>MySQL databases <\/b>section on your hPanel and locate the database with the name you found in wp-config.php file and <b><a href=\"\/support\/1583545-how-to-access-phpmyadmin-in-hpanel\" target=\"_blank\" class=\"intercom-content-link\">open it via phpMyAdmin<\/a><\/b><\/p><p class=\"no-margin\">\n<\/p><p class=\"no-margin\">In phpMyAdmin, open the<b> wp_options<\/b> table and find the <b>template <\/b>and <b>stylesheet<\/b> rows &ndash; you may need to scroll down or move to the next page. These rows will contain your current theme name:<\/p><p class=\"no-margin\">\n<\/p><div class=\"intercom-container\"><img decoding=\"async\" src=\"\/support\/wp-content\/uploads\/sites\/55\/2020\/09\/60d9cc9e-5c3d-4d26-a60c-c5c6f22963e5.jpg\"><\/div><p class=\"no-margin\">Next, double-click on both of the rows to edit the theme name. You can change it to any of the themes you have already installed. The name should fully match the name of the theme&rsquo;s folder:<\/p><p class=\"no-margin\">\n<\/p><div class=\"intercom-container intercom-align-center\"><img decoding=\"async\" src=\"\/support\/wp-content\/uploads\/sites\/55\/2020\/09\/25516116-883c-4121-9b45-30b9897517f0.jpg\"><\/div><p class=\"no-margin\">That&rsquo;s it! your WordPress theme has been <b>changed successfully<\/b>. You can corroborate it by visiting your website after <b><a href=\"https:\/\/www.hostinger.com\/tutorials\/clear-browser-cache\" target=\"_blank\" class=\"intercom-content-link\">clearing your cache<\/a><\/b> or using an incognito window &#128522; <\/p><p class=\"no-margin\">\n<\/p><p class=\"no-margin\"><b>NOTE:<\/b> <\/p><ul>\n<li>\n<p class=\"no-margin\"><b><a href=\"\/support\/4411258-how-to-disable-wordpress-plugins-without-access-to-the-admin-page\" target=\"_blank\" class=\"intercom-content-link\">How to disable WordPress plugins without access to the admin page?<\/a><\/b><\/p>\n<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Changing the WordPress theme without accessing the WordPress admin panel<\/p>\n","protected":false},"author":581,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"include_on_kodee":true,"footnotes":""},"categories":[179],"tags":[],"class_list":["post-1195","post","type-post","status-publish","format-standard","hentry","category-wordpress-management"],"hreflangs":[{"locale":"en-US","link":"https:\/\/www.hostinger.com\/support\/4469298-how-to-change-wordpress-theme-via-phpmyadmin-at-hostinger\/","default":1},{"locale":"es-ES","link":"https:\/\/www.hostinger.com\/es\/support\/4469298-como-cambiar-el-tema-de-wordpress-a-traves-de-phpmyadmin-en-hostinger\/","default":0},{"locale":"fr-FR","link":"https:\/\/www.hostinger.com\/fr\/support\/4469298-comment-changer-le-theme-de-wordpress-via-phpmyadmin-chez-hostinger\/","default":0},{"locale":"id-ID","link":"https:\/\/www.hostinger.com\/id\/support\/4469298-bagaimana-cara-mengubah-tema-wordpress-melalui-phpmyadmin-di-hostinger\/","default":0},{"locale":"pt-PT","link":"https:\/\/www.hostinger.com\/br\/support\/4469298-como-alterar-o-tema-do-wordpress-via-phpmyadmin-no-hostinger\/","default":0},{"locale":"uk-UA","link":"https:\/\/www.hostinger.com\/ua\/support\/4469298----wordpress--phpmyadmin--hostinger\/","default":0}],"include_on_kodee":true,"_links":{"self":[{"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/posts\/1195","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/users\/581"}],"replies":[{"embeddable":true,"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/comments?post=1195"}],"version-history":[{"count":1,"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/posts\/1195\/revisions"}],"predecessor-version":[{"id":4689,"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/posts\/1195\/revisions\/4689"}],"wp:attachment":[{"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/media?parent=1195"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/categories?post=1195"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/tags?post=1195"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}