{"id":534,"date":"2019-11-13T04:34:42","date_gmt":"2019-11-13T04:34:42","guid":{"rendered":"http:\/\/blog.hostinger.io\/hostinger-tutorials\/%category\/wordpresshow-to-change-wordpress-urls-in-mysql-database-using-phpmyadmin\/"},"modified":"2026-10-15T17:39:11","modified_gmt":"2026-10-15T17:39:11","slug":"how-to-change-wordpress-urls-in-mysql-database","status":"publish","type":"post","link":"\/tutorials\/how-to-change-wordpress-urls-in-mysql-database\/","title":{"rendered":"How to change WordPress URL in database using phpMyAdmin"},"content":{"rendered":"<p class=\"wp-block-paragraph\">To change your WordPress URL in the database, open phpMyAdmin, select your WordPress database, and update the <code>home<\/code> and <code>siteurl<\/code> values in the <code>wp_options<\/code> table. These settings control your site&rsquo;s public address and WordPress installation URL.<\/p><p class=\"wp-block-paragraph\">Editing the database directly is useful when you can&rsquo;t access wp-admin, need to correct an incorrect site URL, or have changed your domain during a migration. For an HTTP-to-HTTPS change, you may also need to update these values.<\/p><p class=\"wp-block-paragraph\">Before making changes, back up your database. Updating <code>home<\/code> and <code>siteurl<\/code> changes WordPress&rsquo;s main URL settings, but it doesn&rsquo;t automatically update links stored elsewhere in your site&rsquo;s content or plugin settings.<\/p><p>\n\n\n\n\n\n\n<\/p><h2 id=\"h-1-determining-the-name-of-wordpress-mysql-database\" class=\"wp-block-heading h-t-title-2\">1. Find your WordPress database<\/h2><p class=\"wp-block-paragraph\">Before changing your WordPress URL, <a data-click-id=\"hgr-post-content-link-identify-the-wordpress-database-connected-to-your-website\" href=\"\/tutorials\/how-to-find-wordpress-database-name\/\" data-type=\"link\" data-id=\"\/tutorials\/how-to-find-wordpress-database-name\/\">identify the WordPress database connected to your website<\/a>. This ensures you&rsquo;re editing the correct installation, especially if your hosting account contains multiple WordPress websites or databases.<\/p><p class=\"wp-block-paragraph\">You can find your WordPress database name in the <code>wp-config.php<\/code> file or through your hosting control panel.<\/p><p class=\"wp-block-paragraph\">If you&rsquo;re using Hostinger, Open Hostinger dashboard and navigate to <strong>WordPress &rarr; Overview<\/strong>. The database name is listed in the <strong>Database <\/strong>section.<\/p><div class=\"wp-block-image\">\n<figure data-wp-context='{\"imageId\":\"6ad70c5fa1a2e\"}' data-wp-interactive=\"core\/image\" data-wp-key=\"6ad70c5fa1a2e\" class=\"aligncenter size-large wp-lightbox-container\"><img decoding=\"async\" width=\"2212\" height=\"1414\" 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--pointerdown=\"actions.preloadImage\" data-wp-on--pointerenter=\"actions.preloadImageWithDelay\" data-wp-on--pointerleave=\"actions.cancelPreload\" data-wp-on-window--resize=\"callbacks.setButtonStyles\" src=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/2\/2019\/11\/hpanel-websites-wordpress-overview-database-highlighted.png\/w=1024,h=1024,fit=scale-down\" alt=\"The Database section in the WordPress Overview page of hPanel\" class=\"wp-image-146272\" srcset=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/2\/2019\/11\/hpanel-websites-wordpress-overview-database-highlighted.png\/w=2212,fit=scale-down 2212w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/2\/2019\/11\/hpanel-websites-wordpress-overview-database-highlighted.png\/w=300,fit=scale-down 300w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/2\/2019\/11\/hpanel-websites-wordpress-overview-database-highlighted.png\/w=1024,fit=scale-down 1024w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/2\/2019\/11\/hpanel-websites-wordpress-overview-database-highlighted.png\/w=150,fit=scale-down 150w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/2\/2019\/11\/hpanel-websites-wordpress-overview-database-highlighted.png\/w=768,fit=scale-down 768w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/2\/2019\/11\/hpanel-websites-wordpress-overview-database-highlighted.png\/w=1536,fit=scale-down 1536w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/2\/2019\/11\/hpanel-websites-wordpress-overview-database-highlighted.png\/w=2048,fit=scale-down 2048w\" sizes=\"(max-width: 2212px) 100vw, 2212px\" \/><button class=\"lightbox-trigger\" type=\"button\" aria-haspopup=\"dialog\" data-wp-bind--aria-label=\"state.thisImage.triggerButtonAriaLabel\" data-wp-init=\"callbacks.initTriggerButton\" data-wp-on--click=\"actions.showLightbox\" data-wp-style--right=\"state.thisImage.buttonRight\" data-wp-style--top=\"state.thisImage.buttonTop\">\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\"><\/path>\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n<\/div><p class=\"wp-block-paragraph\">You can also find the database name in the <a data-click-id=\"hgr-post-content-link-wp-config-php-file\" href=\"\/tutorials\/how-to-use-wp-config-php-wordpress-function\/\" data-type=\"link\" data-id=\"\/tutorials\/how-to-use-wp-config-php-wordpress-function\/\">wp-config.php file<\/a>. Open <strong>File Manager<\/strong> from Hostinger dashboard, locate <strong>wp-config.php<\/strong> in your root directory, and search for <strong>DB_NAME<\/strong>. The value next for parameter is your database name.<\/p><ol start=\"3\" class=\"wp-block-list\">\n<li>\n<\/ol><figure class=\"wp-block-image size-full\"><a data-click-id=\"hgr-post-content-link-hostinger-com-tutorials-wp-content-uploads-sites-2-2023-03-f\" href=\"https:\/\/www.hostinger.com\/tutorials\/wp-content\/uploads\/sites\/2\/2023\/03\/filemanager-publichtml-wpconfig-dbname-1.png\"><img decoding=\"async\" width=\"954\" height=\"632\" src=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/2\/2023\/03\/filemanager-publichtml-wpconfig-dbname-1.png\/public\" alt=\"wp-config file, database username highlighted\" class=\"wp-image-80705\" srcset=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/2\/2023\/03\/filemanager-publichtml-wpconfig-dbname-1.png\/w=954,fit=scale-down 954w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/2\/2023\/03\/filemanager-publichtml-wpconfig-dbname-1.png\/w=300,fit=scale-down 300w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/2\/2023\/03\/filemanager-publichtml-wpconfig-dbname-1.png\/w=150,fit=scale-down 150w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/2\/2023\/03\/filemanager-publichtml-wpconfig-dbname-1.png\/w=768,fit=scale-down 768w\" sizes=\"(max-width: 954px) 100vw, 954px\" \/><\/a><\/figure><figure class=\"wp-block-image size-large\"><a data-click-id=\"hgr-post-content-link-wordpress-hosting\" aria-label=\"Wordpress hosting\" class=\"hgr-tutorials-cta hgr-tutorials-cta-wordpress-hosting\" href=\"\/wordpress-hosting\" target=\"_blank\" rel=\"noreferrer noopener\"><img decoding=\"async\" width=\"2048\" height=\"600\" src=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/2\/2024\/06\/New-WP_in-text-banner.png\/w=1024,h=1024,fit=scale-down\" alt=\"\" class=\"wp-image-111781\" srcset=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/2\/2024\/06\/New-WP_in-text-banner.png\/w=2048,fit=scale-down 2048w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/2\/2024\/06\/New-WP_in-text-banner.png\/w=300,fit=scale-down 300w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/2\/2024\/06\/New-WP_in-text-banner.png\/w=1024,fit=scale-down 1024w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/2\/2024\/06\/New-WP_in-text-banner.png\/w=150,fit=scale-down 150w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/2\/2024\/06\/New-WP_in-text-banner.png\/w=768,fit=scale-down 768w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/2\/2024\/06\/New-WP_in-text-banner.png\/w=1536,fit=scale-down 1536w\" sizes=\"(max-width: 2048px) 100vw, 2048px\" \/><\/a><\/figure><h2 id=\"h-2-back-up-your-wordpress-database\" class=\"wp-block-heading h-t-title-2\">2. Back up your WordPress database<\/h2><p class=\"wp-block-paragraph\">Before changing your WordPress URL, back up your database so you can restore the original settings if something goes wrong.<\/p><p class=\"wp-block-paragraph\">To create a backup using phpMyAdmin:<\/p><ol start=\"1\" class=\"wp-block-list\">\n<li>Open <strong>phpMyAdmin<\/strong> from your hosting control panel.<\/li>\n\n\n\n<li>Select your WordPress database from the left sidebar.<\/li>\n\n\n\n<li>Click the <strong>Export<\/strong> tab.<\/li>\n\n\n\n<li>Choose <strong>Quick<\/strong> as the export method and <strong>SQL<\/strong> as the format.<\/li>\n\n\n\n<li>Click <strong>Export<\/strong> to download the backup file.<\/li>\n<\/ol><p class=\"wp-block-paragraph\">Store the downloaded SQL file somewhere safe. If the URL change causes issues, you can restore the previous database using this backup.<\/p><p class=\"wp-block-paragraph\">If you&rsquo;re using Hostinger, you can also <a data-click-id=\"hgr-post-content-link-back-up-your-wordpress-website\" href=\"\/tutorials\/backup-wordpress\/\">back up your WordPress website<\/a> using the available backup tools in hPanel.<\/p><h2 class=\"wp-block-heading h-t-title-2\" id=\"h-3-change-your-wordpress-url-in-phpmyadmin\">3. Change your WordPress URL in phpMyAdmin<\/h2><p class=\"wp-block-paragraph\">Once you&rsquo;ve identified and backed up your WordPress database, you can change your website&rsquo;s URL using phpMyAdmin. You can manually edit the <code>home<\/code> and <code>siteurl<\/code> values to change your website&rsquo;s main address or run SQL queries to update those settings and replace old URLs in post content.<\/p><h3 class=\"wp-block-heading h-t-title-3\">Method 1. Change the WordPress URL manually<\/h3><p class=\"wp-block-paragraph\">This method is useful when you need to correct your website&rsquo;s address, restore access to wp-admin, or update the primary URL after switching domains.<\/p><ol start=\"1\" class=\"wp-block-list\">\n<li>Open <strong>phpMyAdmin<\/strong> and select your WordPress database from the left sidebar.<\/li>\n\n\n\n<li>Find the <code>wp_options<\/code> table and click <strong>Browse<\/strong>. The table prefix may differ from <code>wp_<\/code> depending on your WordPress installation.<\/li>\n\n\n\n<li>Locate the row where <code>option_name<\/code> is <code>siteurl<\/code> and click <strong>Edit<\/strong>.<\/li>\n\n\n\n<li>Change its <code>option_value<\/code> to your new WordPress installation URL, such as <code>https:\/\/example.com<\/code>, then click <strong>Go<\/strong> to save.<\/li>\n\n\n\n<li>Find the row where <code>option_name<\/code> is <code>home<\/code> and click <strong>Edit<\/strong>.<\/li>\n\n\n\n<li>Update its <code>option_value<\/code> to your website&rsquo;s new public URL and click <strong>Go<\/strong> to save.<\/li>\n<\/ol><p class=\"wp-block-paragraph\">For most WordPress websites, <code>home<\/code> and <code>siteurl<\/code> contain the same URL. However, they can differ if WordPress is installed in a separate directory.<\/p><p class=\"wp-block-paragraph\">Use the full URL, including <code>https:\/\/<\/code> when your website has a working SSL certificate, and don&rsquo;t add a trailing slash.<\/p><p class=\"wp-block-paragraph\">Updating these values changes your WordPress website&rsquo;s primary URL settings, but it doesn&rsquo;t automatically update old links stored in posts, images, or plugin settings.<\/p><h3 class=\"wp-block-heading h-t-title-3\"><strong>Method 2. Change WordPress URLs using SQL queries<\/strong><\/h3><p class=\"wp-block-paragraph\">If you&rsquo;re migrating your WordPress website to a new domain, you can use SQL queries to change the main site URLs and replace references to the old domain in post content.<\/p><ol class=\"wp-block-list\">\n<li>Go to <strong>phpMyAdmin<\/strong> via your website&rsquo;s control panel.<\/li>\n\n\n\n<li>The left panel lists all of your databases. Select the one connected to your WordPress site and head to the <strong>SQL <\/strong>tab.<\/li>\n<\/ol><figure class=\"wp-block-image size-large\"><a data-click-id=\"hgr-post-content-link-hostinger-com-tutorials-wp-content-uploads-sites-2-2019-11-s\" href=\"https:\/\/www.hostinger.com\/tutorials\/wp-content\/uploads\/sites\/2\/2019\/11\/Screenshot-2023-01-26-at-17.46.09.png\"><img decoding=\"async\" width=\"1024\" height=\"325\" src=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/2\/2019\/11\/Screenshot-2023-01-26-at-17.46.09.png\/w=1024,h=1024,fit=scale-down\" alt=\"phpMyAdmin run SQL query\/queries on database\" class=\"wp-image-76353\" srcset=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/2\/2019\/11\/Screenshot-2023-01-26-at-17.46.09.png\/w=1024,fit=scale-down 1024w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/2\/2019\/11\/Screenshot-2023-01-26-at-17.46.09.png\/w=300,fit=scale-down 300w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/2\/2019\/11\/Screenshot-2023-01-26-at-17.46.09.png\/w=150,fit=scale-down 150w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/2\/2019\/11\/Screenshot-2023-01-26-at-17.46.09.png\/w=768,fit=scale-down 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure><ol start=\"3\" class=\"wp-block-list\">\n<li>Enter the following SQL query<strong>:<\/strong><\/li>\n<\/ol><pre class=\"wp-block-preformatted\"><strong>\n<\/strong>UPDATE wp_options SET option_value = replace(option_value, 'oldurl.com', 'newurl.com') WHERE option_name = 'home' OR option_name = 'siteurl';UPDATE wp_posts SET guid = replace(guid, 'oldurl.com','newurl.com');UPDATE wp_posts SET post_content = replace(post_content, 'oldurl.com', 'newurl.com'); UPDATE wp_postmeta SET meta_value = replace(meta_value,'oldurl.com','newurl.com');<\/pre><p class=\"wp-block-paragraph\">Replace <strong>oldurl.com<\/strong> with your current WordPress address and <strong>newurl.com<\/strong> with your new WordPress address.<\/p><p>\n\n\n<div class=\"announcement-block announcement-block--important\">\n            <span class=\"announcement-block__heading\">\n                <svg width=\"24\" height=\"24\" viewBox=\"0 0 24 24\" fill=\"none\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\">\n                    <path fill-rule=\"evenodd\" clip-rule=\"evenodd\"\n                          d=\"M12 22.5C17.799 22.5 22.5 17.799 22.5 12C22.5 6.20101 17.799 1.5 12 1.5C6.20101 1.5 1.5 6.20101 1.5 12C1.5 17.799 6.20101 22.5 12 22.5ZM13.637 7.65198C13.637 6.74791 12.9041 6.01501 12 6.01501C11.0959 6.01501 10.363 6.74791 10.363 7.65198C10.5335 9.53749 10.875 13.383 10.875 13.383C10.875 14.0043 11.3787 14.508 12 14.508C12.6213 14.508 13.125 14.0043 13.125 13.383V13.38L13.637 7.65198ZM11.9927 15.714C11.3714 15.714 10.8677 16.2177 10.8677 16.839C10.8677 17.4603 11.3714 17.964 11.9927 17.964H12.0073C12.6286 17.964 13.1323 17.4603 13.1323 16.839C13.1323 16.2177 12.6286 15.714 12.0073 15.714H11.9927Z\"\n                          fill=\"#FEA419\"\/>\n                <\/svg>\n                Important\n            <\/span>\n            <p class=\"announcement-block__content\">\n                <strong>Important!<\/strong> Your table prefix might not be <strong>wp_<\/strong>. See the correct table prefix on the left panel of phpMyAdmin, and update the SQL query.\n            <\/p><\/div>\n\n\n\n<\/p><li>Press&nbsp;<strong>Go. <\/strong>You will see success messages along with the number of changed rows. Note that the number of rows will be different for each WordPress website.<br><img decoding=\"async\" class=\"aligncenter wp-image-22877 size-full\" src=\"\/tutorials\/wp-content\/uploads\/sites\/2\/2016\/06\/sucess-messages-after-changing-wordpress-urls-e1573617184477.png\" alt=\"This image shows that you have successfully changed your WordPress URLs\" width=\"1613\" height=\"612\" srcset=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/2\/2016\/06\/sucess-messages-after-changing-wordpress-urls-e1573617184477.png\/w=1613,fit=scale-down 1613w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/2\/2016\/06\/sucess-messages-after-changing-wordpress-urls-e1573617184477.png\/w=150,fit=scale-down 150w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/2\/2016\/06\/sucess-messages-after-changing-wordpress-urls-e1573617184477.png\/w=300,fit=scale-down 300w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/2\/2016\/06\/sucess-messages-after-changing-wordpress-urls-e1573617184477.png\/w=768,fit=scale-down 768w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/2\/2016\/06\/sucess-messages-after-changing-wordpress-urls-e1573617184477.png\/w=1024,fit=scale-down 1024w\" sizes=\"(max-width: 1613px) 100vw, 1613px\" \/><\/li><li>The last thing we need to do is verify the changes. Open the <strong>wp_options<\/strong> table and check the <strong>option_value<\/strong> of <strong>siteurl<\/strong> and <strong>home. <\/strong>You should see your new URL.<br><img decoding=\"async\" class=\"aligncenter wp-image-22879 size-full\" src=\"\/tutorials\/wp-content\/uploads\/sites\/2\/2016\/06\/new-urls-in-wp-options-table.png\" alt=\"The new URLs in wp_options table\" width=\"1316\" height=\"626\" srcset=\"https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/2\/2016\/06\/new-urls-in-wp-options-table.png\/w=1316,fit=scale-down 1316w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/2\/2016\/06\/new-urls-in-wp-options-table.png\/w=150,fit=scale-down 150w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/2\/2016\/06\/new-urls-in-wp-options-table.png\/w=300,fit=scale-down 300w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/2\/2016\/06\/new-urls-in-wp-options-table.png\/w=768,fit=scale-down 768w, https:\/\/imagedelivery.net\/LqiWLm-3MGbYHtFuUbcBtA\/wp-content\/uploads\/sites\/2\/2016\/06\/new-urls-in-wp-options-table.png\/w=1024,fit=scale-down 1024w\" sizes=\"(max-width: 1316px) 100vw, 1316px\" \/><\/li><p class=\"wp-block-paragraph\"><span style=\"font-weight: 400\">If you get error messages and the queries are not executing, check your code for syntax errors and make sure you are using the correct table prefix. Contact the hosting support for further assistance if the error persists.<\/span><\/p><h2 id=\"h-conclusion\" class=\"wp-block-heading h-t-title-2\">Next step: Check your website for redirect issues<\/h2><p class=\"wp-block-paragraph\">After changing your WordPress URL in the database, check that your website loads correctly and visitors can access its pages without unexpected redirects.<\/p><p class=\"wp-block-paragraph\">If your website still redirects to the previous address, review your WordPress settings, caching configuration, and existing redirect rules. You may need to <a data-click-id=\"hgr-post-content-link-manage-your-wordpress-redirects\" href=\"\/tutorials\/301-redirects-in-wordpress\/\" data-type=\"link\" data-id=\"\/tutorials\/301-redirects-in-wordpress\/\">manage your WordPress redirects<\/a> to make sure visitors reach the correct URLs.<\/p><p class=\"wp-block-paragraph\">Also, check that your WordPress dashboard, internal links, and images work as expected. If you encounter problems, restore the previous URL settings or your database backup.<\/p><p class=\"wp-block-paragraph\"><\/p>\n","protected":false},"excerpt":{"rendered":"<p>To change your WordPress URL in the database, open phpMyAdmin, select your WordPress database, and update the home and siteurl [&#8230;]<\/p>\n<p><a class=\"btn btn-secondary understrap-read-more-link\" href=\"\/tutorials\/how-to-change-wordpress-urls-in-mysql-database\/\">Read More&#8230;<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"rank_math_title":"How to change WordPress URL in database using phpMyAdmin","rank_math_description":"To change your WordPress URL in the database, open phpMyAdmin, find the wp_options table, and update the home and siteurl values.","rank_math_focus_keyword":"change wordpress url in database","footnotes":""},"categories":[22643,22637],"tags":[],"class_list":["post-534","post","type-post","status-publish","format-standard","hentry","category-advanced","category-wordpress"],"hreflangs":[{"locale":"en-US","link":"https:\/\/www.hostinger.com\/tutorials\/how-to-change-wordpress-urls-in-mysql-database","default":0},{"locale":"pt-BR","link":"https:\/\/www.hostinger.com\/br\/tutoriais\/como-mudar-url-do-wordpress-no-banco-de-dados\/","default":0},{"locale":"fr-FR","link":"https:\/\/www.hostinger.com\/fr\/tutoriels\/modifier-url-wordpress-dans-base-de-donnees\/","default":0},{"locale":"es-ES","link":"https:\/\/www.hostinger.com\/es\/tutoriales\/como-cambiar-la-url-de-wordpress\/","default":0},{"locale":"id-ID","link":"https:\/\/www.hostinger.com\/id\/tutorial\/cara-mengubah-url-wordpress-phpmyadmin\/","default":0},{"locale":"en-PH","link":"https:\/\/www.hostinger.com\/ph\/tutorials\/how-to-change-wordpress-urls-in-mysql-database","default":0},{"locale":"en-MY","link":"https:\/\/www.hostinger.com\/my\/tutorials\/how-to-change-wordpress-urls-in-mysql-database","default":0},{"locale":"en-GB","link":"https:\/\/www.hostinger.com\/uk\/tutorials\/how-to-change-wordpress-urls-in-mysql-database","default":0},{"locale":"en-IN","link":"https:\/\/www.hostinger.com\/in\/tutorials\/how-to-change-wordpress-urls-in-mysql-database","default":0},{"locale":"en-CA","link":"https:\/\/www.hostinger.com\/ca\/tutorials\/how-to-change-wordpress-urls-in-mysql-database","default":0},{"locale":"en-AU","link":"https:\/\/www.hostinger.com\/au\/tutorials\/how-to-change-wordpress-urls-in-mysql-database","default":0},{"locale":"en-NG","link":"https:\/\/www.hostinger.com\/ng\/tutorials\/how-to-change-wordpress-urls-in-mysql-database","default":0},{"locale":"es-AR","link":"https:\/\/www.hostinger.com\/ar\/tutoriales\/como-cambiar-la-url-de-wordpress\/","default":0},{"locale":"es-MX","link":"https:\/\/www.hostinger.com\/mx\/tutoriales\/como-cambiar-la-url-de-wordpress\/","default":0},{"locale":"es-CO","link":"https:\/\/www.hostinger.com\/co\/tutoriales\/como-cambiar-la-url-de-wordpress\/","default":0},{"locale":"pt-PT","link":"https:\/\/www.hostinger.com\/pt\/tutoriais\/como-mudar-url-do-wordpress-no-banco-de-dados\/","default":0}],"_links":{"self":[{"href":"https:\/\/www.hostinger.com\/tutorials\/wp-json\/wp\/v2\/posts\/534","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.hostinger.com\/tutorials\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.hostinger.com\/tutorials\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.hostinger.com\/tutorials\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.hostinger.com\/tutorials\/wp-json\/wp\/v2\/comments?post=534"}],"version-history":[{"count":38,"href":"https:\/\/www.hostinger.com\/tutorials\/wp-json\/wp\/v2\/posts\/534\/revisions"}],"predecessor-version":[{"id":159716,"href":"https:\/\/www.hostinger.com\/tutorials\/wp-json\/wp\/v2\/posts\/534\/revisions\/159716"}],"wp:attachment":[{"href":"https:\/\/www.hostinger.com\/tutorials\/wp-json\/wp\/v2\/media?parent=534"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hostinger.com\/tutorials\/wp-json\/wp\/v2\/categories?post=534"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hostinger.com\/tutorials\/wp-json\/wp\/v2\/tags?post=534"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}