{"id":7003,"date":"2022-06-03T08:28:35","date_gmt":"2022-06-03T08:28:35","guid":{"rendered":"https:\/\/wpx.net\/kb\/?post_type=ht_kb&#038;p=7003"},"modified":"2025-07-18T12:57:51","modified_gmt":"2025-07-18T12:57:51","slug":"how-can-i-change-my-wordpress-theme-from-the-database-phpmyadmin","status":"publish","type":"ht_kb","link":"https:\/\/wpx.net\/kb\/how-can-i-change-my-wordpress-theme-from-the-database-phpmyadmin\/","title":{"rendered":"How can I change my WordPress Theme through phpMyAdmin?"},"content":{"rendered":"\n<p>In certain cases, such as when a theme causes a critical error or your WordPress dashboard becomes inaccessible, you may need to <strong>manually switch your WordPress theme via the database<\/strong>.<\/p>\n\n\n\n<p>This guide will walk you through the steps to safely change your active WordPress theme using <strong>phpMyAdmin<\/strong> in your WPX control panel.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"step-1-login-to-your-wpx-account\">Step 1. Log in to your WPX account<\/h2>\n\n\n\n<p>Begin by logging into your WPX account. You can do this by visiting the <strong><a href=\"https:\/\/wpx.net\/clientarea\/\" target=\"_blank\" rel=\"noreferrer noopener\">WPX login page<\/a>.\u200b<\/strong><\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"step-2-navigate-to-your-hosting-plan\">Step 2. Go to Control Panel<\/h2>\n\n\n\n<p>Once logged in:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Locate your hosting plan in the WPX client area.<\/li>\n\n\n\n<li>Click the <strong>Control Panel<\/strong> button next to the plan you wish to manage.<\/li>\n<\/ol>\n\n\n\n<figure data-wp-context=\"{&quot;imageId&quot;:&quot;6a0473d78ce48&quot;}\" data-wp-interactive=\"core\/image\" data-wp-key=\"6a0473d78ce48\" class=\"wp-block-image size-full wp-lightbox-container\"><img loading=\"lazy\" decoding=\"async\" width=\"1919\" height=\"796\" data-wp-class--hide=\"state.isContentHidden\" data-wp-class--show=\"state.isContentVisible\" data-wp-init=\"callbacks.setButtonStyles\" data-wp-on--click=\"actions.showLightbox\" data-wp-on--load=\"callbacks.setButtonStyles\" data-wp-on-window--resize=\"callbacks.setButtonStyles\" src=\"https:\/\/wpx.net\/kb\/wp-content\/uploads\/2025\/03\/image-10.png\" alt=\"\" class=\"wp-image-12899\" srcset=\"https:\/\/wpx.net\/kb\/wp-content\/uploads\/2025\/03\/image-10.png 1919w, https:\/\/wpx.net\/kb\/wp-content\/uploads\/2025\/03\/image-10-300x124.png 300w, https:\/\/wpx.net\/kb\/wp-content\/uploads\/2025\/03\/image-10-1024x425.png 1024w, https:\/\/wpx.net\/kb\/wp-content\/uploads\/2025\/03\/image-10-768x319.png 768w, https:\/\/wpx.net\/kb\/wp-content\/uploads\/2025\/03\/image-10-50x21.png 50w, https:\/\/wpx.net\/kb\/wp-content\/uploads\/2025\/03\/image-10-1536x637.png 1536w, https:\/\/wpx.net\/kb\/wp-content\/uploads\/2025\/03\/image-10-60x25.png 60w, https:\/\/wpx.net\/kb\/wp-content\/uploads\/2025\/03\/image-10-100x41.png 100w\" sizes=\"auto, (max-width: 1919px) 100vw, 1919px\" \/><button\n\t\t\tclass=\"lightbox-trigger\"\n\t\t\ttype=\"button\"\n\t\t\taria-haspopup=\"dialog\"\n\t\t\taria-label=\"Enlarge\"\n\t\t\tdata-wp-init=\"callbacks.initTriggerButton\"\n\t\t\tdata-wp-on--click=\"actions.showLightbox\"\n\t\t\tdata-wp-style--right=\"state.imageButtonRight\"\n\t\t\tdata-wp-style--top=\"state.imageButtonTop\"\n\t\t>\n\t\t\t<svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"12\" height=\"12\" fill=\"none\" viewBox=\"0 0 12 12\">\n\t\t\t\t<path fill=\"#fff\" d=\"M2 0a2 2 0 0 0-2 2v2h1.5V2a.5.5 0 0 1 .5-.5h2V0H2Zm2 10.5H2a.5.5 0 0 1-.5-.5V8H0v2a2 2 0 0 0 2 2h2v-1.5ZM8 12v-1.5h2a.5.5 0 0 0 .5-.5V8H12v2a2 2 0 0 1-2 2H8Zm2-12a2 2 0 0 1 2 2v2h-1.5V2a.5.5 0 0 0-.5-.5H8V0h2Z\" \/>\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n\n\n\n<p class=\"wp-block-ht-blocks-messages wp-block-hb-message wp-block-hb-message--withicon is-style-info\">If you have more than five hosting plans of the same type (WordPress, Agency or WooCommerce), not all may appear on the homepage. Use the <strong>WordPress Hosting<\/strong>, <strong>Agency Hosting<\/strong> or <strong>WooCommerce Hosting<\/strong> tab in the left-hand menu to find your service.<\/p>\n\n\n\n<div class=\"wp-block-group is-layout-constrained wp-block-group-is-layout-constrained\">\n<div class=\"wp-block-group is-layout-constrained wp-block-group-is-layout-constrained\">\n<h2 class=\"wp-block-heading\" id=\"step-3-open-phpmyadmin\">Step 3. Open phpMyAdmin<\/h2>\n\n\n\n<p>In the Control Panel:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Select <strong>Databases<\/strong>. <\/li>\n\n\n\n<li>Then click on the <strong>phpMyAdmin<\/strong> button to open it. <\/li>\n<\/ol>\n<\/div>\n\n\n\n<figure data-wp-context=\"{&quot;imageId&quot;:&quot;6a0473d78e5c1&quot;}\" data-wp-interactive=\"core\/image\" data-wp-key=\"6a0473d78e5c1\" class=\"wp-block-image size-full wp-lightbox-container\"><img loading=\"lazy\" decoding=\"async\" width=\"1919\" height=\"873\" data-wp-class--hide=\"state.isContentHidden\" data-wp-class--show=\"state.isContentVisible\" data-wp-init=\"callbacks.setButtonStyles\" data-wp-on--click=\"actions.showLightbox\" data-wp-on--load=\"callbacks.setButtonStyles\" data-wp-on-window--resize=\"callbacks.setButtonStyles\" src=\"https:\/\/wpx.net\/kb\/wp-content\/uploads\/2022\/06\/image-7.png\" alt=\"\" class=\"wp-image-13721\" srcset=\"https:\/\/wpx.net\/kb\/wp-content\/uploads\/2022\/06\/image-7.png 1919w, https:\/\/wpx.net\/kb\/wp-content\/uploads\/2022\/06\/image-7-300x136.png 300w, https:\/\/wpx.net\/kb\/wp-content\/uploads\/2022\/06\/image-7-1024x466.png 1024w, https:\/\/wpx.net\/kb\/wp-content\/uploads\/2022\/06\/image-7-768x349.png 768w, https:\/\/wpx.net\/kb\/wp-content\/uploads\/2022\/06\/image-7-50x23.png 50w, https:\/\/wpx.net\/kb\/wp-content\/uploads\/2022\/06\/image-7-1536x699.png 1536w, https:\/\/wpx.net\/kb\/wp-content\/uploads\/2022\/06\/image-7-60x27.png 60w, https:\/\/wpx.net\/kb\/wp-content\/uploads\/2022\/06\/image-7-100x45.png 100w\" sizes=\"auto, (max-width: 1919px) 100vw, 1919px\" \/><button\n\t\t\tclass=\"lightbox-trigger\"\n\t\t\ttype=\"button\"\n\t\t\taria-haspopup=\"dialog\"\n\t\t\taria-label=\"Enlarge\"\n\t\t\tdata-wp-init=\"callbacks.initTriggerButton\"\n\t\t\tdata-wp-on--click=\"actions.showLightbox\"\n\t\t\tdata-wp-style--right=\"state.imageButtonRight\"\n\t\t\tdata-wp-style--top=\"state.imageButtonTop\"\n\t\t>\n\t\t\t<svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"12\" height=\"12\" fill=\"none\" viewBox=\"0 0 12 12\">\n\t\t\t\t<path fill=\"#fff\" d=\"M2 0a2 2 0 0 0-2 2v2h1.5V2a.5.5 0 0 1 .5-.5h2V0H2Zm2 10.5H2a.5.5 0 0 1-.5-.5V8H0v2a2 2 0 0 0 2 2h2v-1.5ZM8 12v-1.5h2a.5.5 0 0 0 .5-.5V8H12v2a2 2 0 0 1-2 2H8Zm2-12a2 2 0 0 1 2 2v2h-1.5V2a.5.5 0 0 0-.5-.5H8V0h2Z\" \/>\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Step 4. Locate the Theme Settings in the database<\/h2>\n\n\n\n<p>In phpMyAdmin, select the database associated with the website you want to edit.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1005\" height=\"634\" src=\"https:\/\/wpx.net\/kb\/wp-content\/uploads\/2022\/06\/pic1-9.png\" alt=\"\" class=\"wp-image-13204\" srcset=\"https:\/\/wpx.net\/kb\/wp-content\/uploads\/2022\/06\/pic1-9.png 1005w, https:\/\/wpx.net\/kb\/wp-content\/uploads\/2022\/06\/pic1-9-300x189.png 300w, https:\/\/wpx.net\/kb\/wp-content\/uploads\/2022\/06\/pic1-9-768x484.png 768w, https:\/\/wpx.net\/kb\/wp-content\/uploads\/2022\/06\/pic1-9-50x32.png 50w, https:\/\/wpx.net\/kb\/wp-content\/uploads\/2022\/06\/pic1-9-60x38.png 60w, https:\/\/wpx.net\/kb\/wp-content\/uploads\/2022\/06\/pic1-9-100x63.png 100w\" sizes=\"auto, (max-width: 1005px) 100vw, 1005px\" \/><\/figure>\n\n\n\n<p>Select the database of the site. Find and click on the table ending in <code>_options<\/code> (e.g., <code>wp_options<\/code>, <code>www_options<\/code>, or <code>subdomain_options<\/code>). The prefix may vary based on your WordPress setup.<\/p>\n\n\n\n<figure data-wp-context=\"{&quot;imageId&quot;:&quot;6a0473d78ebf9&quot;}\" data-wp-interactive=\"core\/image\" data-wp-key=\"6a0473d78ebf9\" class=\"wp-block-image size-full wp-lightbox-container\"><img loading=\"lazy\" decoding=\"async\" width=\"1086\" height=\"910\" data-wp-class--hide=\"state.isContentHidden\" data-wp-class--show=\"state.isContentVisible\" data-wp-init=\"callbacks.setButtonStyles\" data-wp-on--click=\"actions.showLightbox\" data-wp-on--load=\"callbacks.setButtonStyles\" data-wp-on-window--resize=\"callbacks.setButtonStyles\" src=\"https:\/\/wpx.net\/kb\/wp-content\/uploads\/2022\/06\/pic2.png\" alt=\"\" class=\"wp-image-13208\" srcset=\"https:\/\/wpx.net\/kb\/wp-content\/uploads\/2022\/06\/pic2.png 1086w, https:\/\/wpx.net\/kb\/wp-content\/uploads\/2022\/06\/pic2-300x251.png 300w, https:\/\/wpx.net\/kb\/wp-content\/uploads\/2022\/06\/pic2-1024x858.png 1024w, https:\/\/wpx.net\/kb\/wp-content\/uploads\/2022\/06\/pic2-768x644.png 768w, https:\/\/wpx.net\/kb\/wp-content\/uploads\/2022\/06\/pic2-50x42.png 50w, https:\/\/wpx.net\/kb\/wp-content\/uploads\/2022\/06\/pic2-60x50.png 60w, https:\/\/wpx.net\/kb\/wp-content\/uploads\/2022\/06\/pic2-100x84.png 100w\" sizes=\"auto, (max-width: 1086px) 100vw, 1086px\" \/><button\n\t\t\tclass=\"lightbox-trigger\"\n\t\t\ttype=\"button\"\n\t\t\taria-haspopup=\"dialog\"\n\t\t\taria-label=\"Enlarge\"\n\t\t\tdata-wp-init=\"callbacks.initTriggerButton\"\n\t\t\tdata-wp-on--click=\"actions.showLightbox\"\n\t\t\tdata-wp-style--right=\"state.imageButtonRight\"\n\t\t\tdata-wp-style--top=\"state.imageButtonTop\"\n\t\t>\n\t\t\t<svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"12\" height=\"12\" fill=\"none\" viewBox=\"0 0 12 12\">\n\t\t\t\t<path fill=\"#fff\" d=\"M2 0a2 2 0 0 0-2 2v2h1.5V2a.5.5 0 0 1 .5-.5h2V0H2Zm2 10.5H2a.5.5 0 0 1-.5-.5V8H0v2a2 2 0 0 0 2 2h2v-1.5ZM8 12v-1.5h2a.5.5 0 0 0 .5-.5V8H12v2a2 2 0 0 1-2 2H8Zm2-12a2 2 0 0 1 2 2v2h-1.5V2a.5.5 0 0 0-.5-.5H8V0h2Z\" \/>\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Step 5: Update the Active Theme<\/h2>\n\n\n\n<p>Within the <code>_options<\/code> table, look for the following two rows:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>template &amp; stylesheet. <\/li>\n\n\n\n<li>These are usually located on <strong>page 2<\/strong> of the table entries.<\/li>\n<\/ol>\n\n\n\n<figure data-wp-context=\"{&quot;imageId&quot;:&quot;6a0473d78f0d1&quot;}\" data-wp-interactive=\"core\/image\" data-wp-key=\"6a0473d78f0d1\" class=\"wp-block-image size-full wp-lightbox-container\"><img loading=\"lazy\" decoding=\"async\" width=\"1148\" height=\"912\" data-wp-class--hide=\"state.isContentHidden\" data-wp-class--show=\"state.isContentVisible\" data-wp-init=\"callbacks.setButtonStyles\" data-wp-on--click=\"actions.showLightbox\" data-wp-on--load=\"callbacks.setButtonStyles\" data-wp-on-window--resize=\"callbacks.setButtonStyles\" src=\"https:\/\/wpx.net\/kb\/wp-content\/uploads\/2022\/06\/pic3.png\" alt=\"\" class=\"wp-image-13211\" srcset=\"https:\/\/wpx.net\/kb\/wp-content\/uploads\/2022\/06\/pic3.png 1148w, https:\/\/wpx.net\/kb\/wp-content\/uploads\/2022\/06\/pic3-300x238.png 300w, https:\/\/wpx.net\/kb\/wp-content\/uploads\/2022\/06\/pic3-1024x813.png 1024w, https:\/\/wpx.net\/kb\/wp-content\/uploads\/2022\/06\/pic3-768x610.png 768w, https:\/\/wpx.net\/kb\/wp-content\/uploads\/2022\/06\/pic3-50x40.png 50w, https:\/\/wpx.net\/kb\/wp-content\/uploads\/2022\/06\/pic3-60x48.png 60w, https:\/\/wpx.net\/kb\/wp-content\/uploads\/2022\/06\/pic3-100x79.png 100w\" sizes=\"auto, (max-width: 1148px) 100vw, 1148px\" \/><button\n\t\t\tclass=\"lightbox-trigger\"\n\t\t\ttype=\"button\"\n\t\t\taria-haspopup=\"dialog\"\n\t\t\taria-label=\"Enlarge\"\n\t\t\tdata-wp-init=\"callbacks.initTriggerButton\"\n\t\t\tdata-wp-on--click=\"actions.showLightbox\"\n\t\t\tdata-wp-style--right=\"state.imageButtonRight\"\n\t\t\tdata-wp-style--top=\"state.imageButtonTop\"\n\t\t>\n\t\t\t<svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"12\" height=\"12\" fill=\"none\" viewBox=\"0 0 12 12\">\n\t\t\t\t<path fill=\"#fff\" d=\"M2 0a2 2 0 0 0-2 2v2h1.5V2a.5.5 0 0 1 .5-.5h2V0H2Zm2 10.5H2a.5.5 0 0 1-.5-.5V8H0v2a2 2 0 0 0 2 2h2v-1.5ZM8 12v-1.5h2a.5.5 0 0 0 .5-.5V8H12v2a2 2 0 0 1-2 2H8Zm2-12a2 2 0 0 1 2 2v2h-1.5V2a.5.5 0 0 0-.5-.5H8V0h2Z\" \/>\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n\n\n\n<p>Once located, double-click the value in each row and replace the current theme name with the <strong>directory name<\/strong> of the new theme you want to activate (e.g., <code>twentytwentyone<\/code>).<\/p>\n\n\n\n<p>Press <strong>Enter<\/strong> to save each change.<\/p>\n\n\n\n<p class=\"wp-block-ht-blocks-messages wp-block-hb-message wp-block-hb-message--withicon is-style-alert\">The new theme must already exist in the <code>\/wp-content\/themes\/<\/code> folder of your site. You can check this via FTP or the WPX File Manager.<\/p>\n\n\n\n<figure data-wp-context=\"{&quot;imageId&quot;:&quot;6a0473d78f90b&quot;}\" data-wp-interactive=\"core\/image\" data-wp-key=\"6a0473d78f90b\" class=\"wp-block-image size-full wp-lightbox-container\"><img loading=\"lazy\" decoding=\"async\" width=\"1164\" height=\"906\" data-wp-class--hide=\"state.isContentHidden\" data-wp-class--show=\"state.isContentVisible\" data-wp-init=\"callbacks.setButtonStyles\" data-wp-on--click=\"actions.showLightbox\" data-wp-on--load=\"callbacks.setButtonStyles\" data-wp-on-window--resize=\"callbacks.setButtonStyles\" src=\"https:\/\/wpx.net\/kb\/wp-content\/uploads\/2022\/06\/pic4.png\" alt=\"\" class=\"wp-image-13212\" srcset=\"https:\/\/wpx.net\/kb\/wp-content\/uploads\/2022\/06\/pic4.png 1164w, https:\/\/wpx.net\/kb\/wp-content\/uploads\/2022\/06\/pic4-300x234.png 300w, https:\/\/wpx.net\/kb\/wp-content\/uploads\/2022\/06\/pic4-1024x797.png 1024w, https:\/\/wpx.net\/kb\/wp-content\/uploads\/2022\/06\/pic4-768x598.png 768w, https:\/\/wpx.net\/kb\/wp-content\/uploads\/2022\/06\/pic4-50x39.png 50w, https:\/\/wpx.net\/kb\/wp-content\/uploads\/2022\/06\/pic4-60x47.png 60w, https:\/\/wpx.net\/kb\/wp-content\/uploads\/2022\/06\/pic4-100x78.png 100w\" sizes=\"auto, (max-width: 1164px) 100vw, 1164px\" \/><button\n\t\t\tclass=\"lightbox-trigger\"\n\t\t\ttype=\"button\"\n\t\t\taria-haspopup=\"dialog\"\n\t\t\taria-label=\"Enlarge\"\n\t\t\tdata-wp-init=\"callbacks.initTriggerButton\"\n\t\t\tdata-wp-on--click=\"actions.showLightbox\"\n\t\t\tdata-wp-style--right=\"state.imageButtonRight\"\n\t\t\tdata-wp-style--top=\"state.imageButtonTop\"\n\t\t>\n\t\t\t<svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"12\" height=\"12\" fill=\"none\" viewBox=\"0 0 12 12\">\n\t\t\t\t<path fill=\"#fff\" d=\"M2 0a2 2 0 0 0-2 2v2h1.5V2a.5.5 0 0 1 .5-.5h2V0H2Zm2 10.5H2a.5.5 0 0 1-.5-.5V8H0v2a2 2 0 0 0 2 2h2v-1.5ZM8 12v-1.5h2a.5.5 0 0 0 .5-.5V8H12v2a2 2 0 0 1-2 2H8Zm2-12a2 2 0 0 1 2 2v2h-1.5V2a.5.5 0 0 0-.5-.5H8V0h2Z\" \/>\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n\n\n\n<p class=\"wp-block-ht-blocks-messages wp-block-hb-message wp-block-hb-message--withicon\">That&#8217;s it! You\u2019ve successfully changed your WordPress theme via the database. The new theme should now be active on your website.<\/p>\n\n\n\n<p>Stuck at any point? Don\u2019t worry, just click the live chat widget in the bottom-right, and one of our support agents will assist you in <strong>under 30 seconds<\/strong>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In certain cases, such as when a theme causes a critical error or your WordPress dashboard becomes inaccessible, you may need to manually switch your WordPress theme via the database. This guide will walk you through the steps to safely change your active WordPress theme using phpMyAdmin in your WPX&#8230;<\/p>\n","protected":false},"author":2,"comment_status":"open","ping_status":"closed","template":"","format":"standard","meta":{"_editorskit_title_hidden":false,"_editorskit_reading_time":2,"_editorskit_is_block_options_detached":false,"_editorskit_block_options_position":"{}","inline_featured_image":false,"footnotes":""},"ht-kb-category":[106],"ht-kb-tag":[],"class_list":["post-7003","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-databases"],"_links":{"self":[{"href":"https:\/\/wpx.net\/kb\/wp-json\/wp\/v2\/ht-kb\/7003","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wpx.net\/kb\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/wpx.net\/kb\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/wpx.net\/kb\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/wpx.net\/kb\/wp-json\/wp\/v2\/comments?post=7003"}],"version-history":[{"count":18,"href":"https:\/\/wpx.net\/kb\/wp-json\/wp\/v2\/ht-kb\/7003\/revisions"}],"predecessor-version":[{"id":13742,"href":"https:\/\/wpx.net\/kb\/wp-json\/wp\/v2\/ht-kb\/7003\/revisions\/13742"}],"wp:attachment":[{"href":"https:\/\/wpx.net\/kb\/wp-json\/wp\/v2\/media?parent=7003"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/wpx.net\/kb\/wp-json\/wp\/v2\/ht-kb-category?post=7003"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/wpx.net\/kb\/wp-json\/wp\/v2\/ht-kb-tag?post=7003"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}