{"id":1452,"date":"2020-11-23T09:22:06","date_gmt":"2020-11-23T09:22:06","guid":{"rendered":"https:\/\/hostingspell.com\/blog\/?p=1452"},"modified":"2021-07-23T21:30:11","modified_gmt":"2021-07-23T21:30:11","slug":"how-to-change-siteurl-of-wordpress-from-mysql","status":"publish","type":"post","link":"https:\/\/blog.hostingspell.com\/how-to-change-siteurl-of-wordpress-from-mysql\/","title":{"rendered":"How to change SiteURL of WordPress from MySQL"},"content":{"rendered":"\n

You can change the area name for your WordPress site any time you like, yet there are a couple of significant settings that must be made to do the switch.<\/p>\n\n\n\n

Make a point to deliberately follow the means beneath to guarantee it’s done appropriately.<\/p>\n\n\n\n

Several reasons to change the URL<\/strong><\/h2>\n\n\n\n

Coming up next are directions for moving a WordPress establishment from one URL to an alternate one. There are various cases for moving a WordPress introduce, as demonstrated as follows.<\/p>\n\n\n\n

Case 1: Moving from a subdirectory<\/strong><\/h3>\n\n\n\n

The primary case is the point at which a WordPress site moves from a sub-registry to its parent area. For instance:<\/p>\n\n\n\n

Move from http:\/\/example.com\/blog<\/p>\n\n\n\n

to<\/p>\n\n\n\n

http:\/\/example.com<\/a><\/p>\n\n\n\n

If you’ve just moved your area to another URL, you can’t sign in since WordPress is arranged to utilize the old URL.<\/p>\n\n\n\n

Case 2: Adding or eliminating www<\/strong><\/h3>\n\n\n\n

Another motivation to refresh your URLs is if you have to include or eliminate www from your space. For instance, in case you’re utilizing Cloudflare with DreamHost, you have to add www to your area. So if it was already example.com, you would transform it to www.example.com.<\/p>\n\n\n\n

After modifying the URL, you may likewise observe a program divert blunder when seeing your site. It might state “Too many sidetracks” or “The page isn’t diverting appropriately”.<\/p>\n\n\n\n

Case 3: Adding ‘https’ to the URL<\/strong><\/h3>\n\n\n\n

In case you’re utilizing an SSL testament, the initial segment of the URL changes from ‘HTTP’ to ‘HTTPS’. If you’ve just rolled out this improvement, you can’t sign in since WordPress is arranged to utilize the old URL.<\/p>\n\n\n\n

Case 4: Moving to another space<\/strong><\/h3>\n\n\n\n

The last case is the point at which a WordPress site moves from one completely facilitated space to an alternate one. For instance:<\/p>\n\n\n\n

Move from http:\/\/example.com\/blog<\/p>\n\n\n\n

to<\/p>\n\n\n\n

http:\/\/hostingspell.com<\/a><\/p>\n\n\n\n

If this choice applies to your site, see the accompanying article for full directions on moving a WordPress introduce to an alternate space<\/p>\n\n\n\n

Different ways to change the WordPress URL<\/strong><\/h2>\n\n\n\n

Choice 1: Changing the HOME and SITE URL utilizing phpMyAdmin<\/strong><\/h3>\n\n\n\n

If you’ve just made any of the progressions above, you’re not ready to sign in to your dashboard. You can rather utilize phpMyAdmin to refresh the HOME and SITE URLs.<\/p>\n\n\n\n

Visit the accompanying article for more data on the most proficient method to sign in to phpMyAdmin:<\/p>\n\n\n\n

Finding your phpMyAdmin login accreditations<\/p>\n\n\n\n

  • Open phpMyAdmin.<\/li>
  • Snap your information base in the left sheet. A few tables show up underneath it. Snap-on your wp_options table.<\/li><\/ul>\n\n\n\n
    \"\"<\/figure>\n\n\n\n
    • Find the ‘siteurl’ and ‘home’ lines. Snap the pencil symbol close to each to alter.<\/li><\/ul>\n\n\n\n
      \"\"<\/figure>\n\n\n\n
      • Snap the pencil symbol close to each to alter.<\/li><\/ul>\n\n\n\n
        \"\"<\/figure>\n\n\n\n
        • Change the URL by composing in another one.<\/li>
        • Snap the Go button to spare the settings. Do this for both the ‘siteurl’ and ‘home’ alternatives.<\/li><\/ul>\n\n\n\n

          You should now have the option to sign in to your site at example.com\/wp-login.php.<\/p>\n\n\n\n

          Even though this gives you admittance to your site, any previous URLs in your information base are as yet utilizing the old URL. You should now utilize a module to refresh all URLs in your information base to the new URL.<\/p>\n\n\n\n

          Choice 2: Changing the URLs in your wp-config.php record<\/strong><\/h3>\n\n\n\n

          You can likewise change the URLs in your wp-config.php record. This is somewhat simpler than altering your information base and will give you quick admittance to your site.<\/p>\n\n\n\n

          • Sign in to your site utilizing FTP or SSH.<\/li>
          • In your WordPress registry, alter the document named ‘wp-config.php’.<\/li>
          • Making and altering records through FTP<\/li>
          • Making and altering a record through SSH<\/li>
          • In that record, including the accompanying lines simply above<\/li>
          • If you visit your site now, you’ll see you can sign in.<\/li><\/ul>\n\n\n\n

            Even though this gives you prompt admittance to your site, the information base is as yet not arranged to utilize the right HOME and SITE URL. You should now utilize a module to refresh all URLs in your information base to the new URL.<\/p>\n\n\n\n

            Verifying the new HOME and SITE URL<\/strong><\/h2>\n\n\n\n

            If you utilized choices #1 over, the HOME and SITE URLs were refreshed in the information base. You can affirm your site is presently utilizing the right URLs in your dashboard.<\/p>\n\n\n\n

            • Sign in to your WordPress Dashboard.<\/li>
            • Explore over to Settings > General.<\/li><\/ul>\n\n\n\n

              Here you’ll see the HOME and SITE URL your WordPress site is designed to utilize.<\/p>\n","protected":false},"excerpt":{"rendered":"

              You can change the area name for your WordPress site any time you like, yet there are a couple of significant settings that must be made to do the switch. Make a point to deliberately follow the means beneath to guarantee it’s done appropriately. Several reasons to change the URL Coming up next are directions […]<\/p>\n","protected":false},"author":8,"featured_media":1647,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_uag_custom_page_level_css":"","_genesis_hide_title":false,"_genesis_hide_breadcrumbs":false,"_genesis_hide_singular_image":false,"_genesis_hide_footer_widgets":false,"_genesis_custom_body_class":"","_genesis_custom_post_class":"","_genesis_layout":"","footnotes":""},"categories":[1],"tags":[],"class_list":["post-1452","post","type-post","status-publish","format-standard","has-post-thumbnail","category-general","entry"],"featured_image_src":"https:\/\/blog.hostingspell.com\/wp-content\/uploads\/2021\/03\/hspl-blog-default.png","featured_image_src_square":"https:\/\/blog.hostingspell.com\/wp-content\/uploads\/2021\/03\/hspl-blog-default.png","author_info":{"display_name":"Manjusri Mahalakshmi","author_link":"https:\/\/blog.hostingspell.com\/author\/manjusri\/"},"uagb_featured_image_src":{"full":["https:\/\/blog.hostingspell.com\/wp-content\/uploads\/2021\/03\/hspl-blog-default.png",580,290,false],"thumbnail":["https:\/\/blog.hostingspell.com\/wp-content\/uploads\/2021\/03\/hspl-blog-default-150x150.png",150,150,true],"medium":["https:\/\/blog.hostingspell.com\/wp-content\/uploads\/2021\/03\/hspl-blog-default-300x150.png",300,150,true],"medium_large":["https:\/\/blog.hostingspell.com\/wp-content\/uploads\/2021\/03\/hspl-blog-default.png",580,290,false],"large":["https:\/\/blog.hostingspell.com\/wp-content\/uploads\/2021\/03\/hspl-blog-default.png",580,290,false],"1536x1536":["https:\/\/blog.hostingspell.com\/wp-content\/uploads\/2021\/03\/hspl-blog-default.png",580,290,false],"2048x2048":["https:\/\/blog.hostingspell.com\/wp-content\/uploads\/2021\/03\/hspl-blog-default.png",580,290,false],"single-featured-image":["https:\/\/blog.hostingspell.com\/wp-content\/uploads\/2021\/03\/hspl-blog-default.png",580,290,false],"blog-featured-image":["https:\/\/blog.hostingspell.com\/wp-content\/uploads\/2021\/03\/hspl-blog-default.png",580,290,false],"home-featured":["https:\/\/blog.hostingspell.com\/wp-content\/uploads\/2021\/03\/hspl-blog-default-380x290.png",380,290,true],"ab-block-post-grid-landscape":["https:\/\/blog.hostingspell.com\/wp-content\/uploads\/2021\/03\/hspl-blog-default.png",580,290,false],"ab-block-post-grid-square":["https:\/\/blog.hostingspell.com\/wp-content\/uploads\/2021\/03\/hspl-blog-default.png",580,290,false],"author-pro-image":["https:\/\/blog.hostingspell.com\/wp-content\/uploads\/2021\/03\/hspl-blog-default.png",360,180,false],"gb-block-post-grid-landscape":["https:\/\/blog.hostingspell.com\/wp-content\/uploads\/2021\/03\/hspl-blog-default.png",580,290,false],"gb-block-post-grid-square":["https:\/\/blog.hostingspell.com\/wp-content\/uploads\/2021\/03\/hspl-blog-default.png",580,290,false]},"uagb_author_info":{"display_name":"Manjusri Mahalakshmi","author_link":"https:\/\/blog.hostingspell.com\/author\/manjusri\/"},"uagb_comment_info":0,"uagb_excerpt":"You can change the area name for your WordPress site any time you like, yet there are a couple of significant settings that must be made to do the switch. Make a point to deliberately follow the means beneath to guarantee it’s done appropriately. Several reasons to change the URL Coming up next are directions…","_links":{"self":[{"href":"https:\/\/blog.hostingspell.com\/wp-json\/wp\/v2\/posts\/1452","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.hostingspell.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.hostingspell.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.hostingspell.com\/wp-json\/wp\/v2\/users\/8"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.hostingspell.com\/wp-json\/wp\/v2\/comments?post=1452"}],"version-history":[{"count":1,"href":"https:\/\/blog.hostingspell.com\/wp-json\/wp\/v2\/posts\/1452\/revisions"}],"predecessor-version":[{"id":1780,"href":"https:\/\/blog.hostingspell.com\/wp-json\/wp\/v2\/posts\/1452\/revisions\/1780"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.hostingspell.com\/wp-json\/wp\/v2\/media\/1647"}],"wp:attachment":[{"href":"https:\/\/blog.hostingspell.com\/wp-json\/wp\/v2\/media?parent=1452"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.hostingspell.com\/wp-json\/wp\/v2\/categories?post=1452"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.hostingspell.com\/wp-json\/wp\/v2\/tags?post=1452"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}