{"id":23905,"date":"2022-04-14T19:42:33","date_gmt":"2022-04-14T19:42:33","guid":{"rendered":"https:\/\/iserversupport.com\/?p=23905"},"modified":"2022-09-06T05:46:04","modified_gmt":"2022-09-06T05:46:04","slug":"how-to-change-wordpress-website-and-home-url-in-phpmyadmin-and-command-line","status":"publish","type":"post","link":"https:\/\/iserversupport.com\/blog\/how-to-change-wordpress-website-and-home-url-in-phpmyadmin-and-command-line\/","title":{"rendered":"How to change wordpress url ?"},"content":{"rendered":"

This blog explains how to change the wordpress site and home URL using both command line and phpMyAdmin methods. Firstly we discuss using the command line method.<\/p>\n

 <\/p>\n

How to change wordpress site url\u00a0 from commandline ?<\/h2>\n

Before going to the command line method, make sure that we have root access to the mysql server. If we have\u00a0 root access, then access the mysql server using the below command.<\/p>\n

$mysql -u root -p<\/pre>\n
Then provide the mysql root password.<\/p>\n
Then it will take us to the mysql console.<\/p>\n
or simply type mysql on the command prompt.<\/p>\n
$ mysql<\/pre>\n
\"Change<\/p>\n
After that we need to change the database to a wordpress database specified the wp-config.php using the below command.<\/p>\n
$ use database_name;<\/pre>\n
Then show tables on the database.<\/p>\n
$ show tables;<\/pre>\n
You will see something like this:<\/p>\n
 <\/p>\n
 +\u2014\u2014\u2014\u2014+\u2014\u2014\u2014\u2014+\u2014\u2014\u2014\u2014+\u2014\u2014\u2014\u2014\u2014+\u2014\u2014\u2014\u2014\u2014+\r\n\r\n\u00a0| Tables_in_database |\r\n\r\n\u00a0+\u2014\u2014\u2014\u2014+\u2014\u2014\u2014\u2014+\u2014\u2014\u2014\u2014+\u2014\u2014\u2014\u2014\u2014+\u2014\u2014\u2014\u2014\u2014+\r\n\r\n\u00a0| wp_commentmeta \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 |\r\n\r\n\u00a0| wp_comments\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 |\r\n\r\n\u00a0| wp_links \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 |\r\n\r\n\u00a0| wp_options \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 |\r\n\r\n\u00a0| wp_postmeta\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 |\r\n\r\n\u00a0| wp_posts \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 |\r\n\r\n\u00a0| wp_term_relationships\u00a0 \u00a0 |\r\n\r\n\u00a0| wp_term_taxonomy \u00a0 \u00a0 \u00a0 \u00a0 |\r\n\r\n\u00a0| wp_terms \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 |\r\n\r\n\u00a0| wp_usermeta\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 |\r\n\r\n\u00a0| wp_users \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 |\r\n\r\n\u00a0+\u2014\u2014\u2014\u2014+\u2014\u2014\u2014\u2014+\u2014\u2014\u2014\u2014+\u2014\u2014\u2014\u2014\u2014+\u2014\u2014\u2014\u2014\u2014+\r\n\r\n\u00a011 rows in set (0.00 sec)\r\n\r\n<\/pre>\n
Then follow up the below commands to change the URLs.<\/p>\n
mysql> SELECT * from wp_options WHERE option_name = 'home' OR option_name = 'siteurl';<\/pre>\n
 <\/p>\n
mysql> UPDATE wp_options SET option_value = http:\/\/www.example.com\/blog \u00a0 WHERE option_name = 'home' OR option_name = 'siteurl';<\/pre>\n
How to change WordPress URL\u00a0 using PhpMyadmin ?<\/h2>\n
1. Open PhpMyAdmin.<\/p>\n
2.Click your database in the left pane. Several tables appear below it. Click on your wp_options table.<\/p>\n
\"Change<\/p>\n
3.Locate the siteurl and home rows. Click the Edit option to make changes.<\/p>\n
\"Change<\/p>\n
4. Click the pencil icon next to each to edit.<\/p>\n
\"Change<\/p>\n
5. Change the URL by typing a new one.<\/p>\n
6. Click the Go button to save the settings. Do this for both the site URL and home options.<\/p>\n
Now we have learned how to change wordpress website and home url\u00a0 using\u00a0 PhpMyAdmin and Command line.At Iserversupport we have dedicated and trained\u00a0 team for windows server management<\/a>. If you want to get any support don’t hesitate to contact our server management<\/a> team.<\/p>\n","protected":false},"excerpt":{"rendered":"
This blog explains how to change the wordpress site and home URL using both command line and phpMyAdmin methods. Firstly we discuss using the command line method.   How to […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"yoast_head":"\nHow to Change Wordpress Website and Home Url in PhpMyAdmin & Command line<\/title>\n<meta name=\"description\" content=\"Here is the step by step solution for changing wordpress website & home url using\u00a0 the command line and PhpMyAdmin\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/iserversupport.com\/blog\/how-to-change-wordpress-website-and-home-url-in-phpmyadmin-and-command-line\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Change Wordpress Website and Home Url in PhpMyAdmin & Command line\" \/>\n<meta property=\"og:description\" content=\"Here is the step by step solution for changing wordpress website & home url using\u00a0 the command line and PhpMyAdmin\" \/>\n<meta property=\"og:url\" content=\"https:\/\/iserversupport.com\/blog\/how-to-change-wordpress-website-and-home-url-in-phpmyadmin-and-command-line\/\" \/>\n<meta property=\"og:site_name\" content=\"Server Management Company - Outsourced Webhosting Service\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/facebook.com\/iserversupport\" \/>\n<meta property=\"article:published_time\" content=\"2022-04-14T19:42:33+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-09-06T05:46:04+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/iserversupport.com\/wp-content\/uploads\/2022\/03\/wordpresshomeurl1.png\" \/>\n<meta name=\"author\" content=\"iServerSupport\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@iserversupport\" \/>\n<meta name=\"twitter:site\" content=\"@iserversupport\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"iServerSupport\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/iserversupport.com\/blog\/how-to-change-wordpress-website-and-home-url-in-phpmyadmin-and-command-line\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/iserversupport.com\/blog\/how-to-change-wordpress-website-and-home-url-in-phpmyadmin-and-command-line\/\"},\"author\":{\"name\":\"iServerSupport\",\"@id\":\"https:\/\/iserversupport.com\/blog\/#\/schema\/person\/414757a5feb39cada3a64aece076ce39\"},\"headline\":\"How to change wordpress url ?\",\"datePublished\":\"2022-04-14T19:42:33+00:00\",\"dateModified\":\"2022-09-06T05:46:04+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/iserversupport.com\/blog\/how-to-change-wordpress-website-and-home-url-in-phpmyadmin-and-command-line\/\"},\"wordCount\":259,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/iserversupport.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/iserversupport.com\/blog\/how-to-change-wordpress-website-and-home-url-in-phpmyadmin-and-command-line\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/iserversupport.com\/wp-content\/uploads\/2022\/03\/wordpresshomeurl1.png\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/iserversupport.com\/blog\/how-to-change-wordpress-website-and-home-url-in-phpmyadmin-and-command-line\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/iserversupport.com\/blog\/how-to-change-wordpress-website-and-home-url-in-phpmyadmin-and-command-line\/\",\"url\":\"https:\/\/iserversupport.com\/blog\/how-to-change-wordpress-website-and-home-url-in-phpmyadmin-and-command-line\/\",\"name\":\"How to Change Wordpress Website and Home Url in PhpMyAdmin & Command line\",\"isPartOf\":{\"@id\":\"https:\/\/iserversupport.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/iserversupport.com\/blog\/how-to-change-wordpress-website-and-home-url-in-phpmyadmin-and-command-line\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/iserversupport.com\/blog\/how-to-change-wordpress-website-and-home-url-in-phpmyadmin-and-command-line\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/iserversupport.com\/wp-content\/uploads\/2022\/03\/wordpresshomeurl1.png\",\"datePublished\":\"2022-04-14T19:42:33+00:00\",\"dateModified\":\"2022-09-06T05:46:04+00:00\",\"description\":\"Here is the step by step solution for changing wordpress website & home url using\u00a0 the command line and PhpMyAdmin\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/iserversupport.com\/blog\/how-to-change-wordpress-website-and-home-url-in-phpmyadmin-and-command-line\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/iserversupport.com\/blog\/how-to-change-wordpress-website-and-home-url-in-phpmyadmin-and-command-line\/#primaryimage\",\"url\":\"https:\/\/iserversupport.com\/wp-content\/uploads\/2022\/03\/wordpresshomeurl1.png\",\"contentUrl\":\"https:\/\/iserversupport.com\/wp-content\/uploads\/2022\/03\/wordpresshomeurl1.png\"},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/iserversupport.com\/blog\/#website\",\"url\":\"https:\/\/iserversupport.com\/blog\/\",\"name\":\"Server Management Company - Outsourced Webhosting Service\",\"description\":\"Complete server management service\",\"publisher\":{\"@id\":\"https:\/\/iserversupport.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/iserversupport.com\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/iserversupport.com\/blog\/#organization\",\"name\":\"iServerSupport\",\"url\":\"https:\/\/iserversupport.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/iserversupport.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/iserversupport.com\/wp-content\/uploads\/2020\/09\/I-SERVER-SUPPORT-07-1-e1606382474222.png\",\"contentUrl\":\"https:\/\/iserversupport.com\/wp-content\/uploads\/2020\/09\/I-SERVER-SUPPORT-07-1-e1606382474222.png\",\"width\":20,\"height\":19,\"caption\":\"iServerSupport\"},\"image\":{\"@id\":\"https:\/\/iserversupport.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/facebook.com\/iserversupport\",\"https:\/\/x.com\/iserversupport\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/iserversupport.com\/blog\/#\/schema\/person\/414757a5feb39cada3a64aece076ce39\",\"name\":\"iServerSupport\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/iserversupport.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/ab568d65092a1e7994bb3aa6f4a4a1ba?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/ab568d65092a1e7994bb3aa6f4a4a1ba?s=96&d=mm&r=g\",\"caption\":\"iServerSupport\"},\"sameAs\":[\"https:\/\/iserversupport.com\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Change Wordpress Website and Home Url in PhpMyAdmin & Command line","description":"Here is the step by step solution for changing wordpress website & home url using\u00a0 the command line and PhpMyAdmin","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/iserversupport.com\/blog\/how-to-change-wordpress-website-and-home-url-in-phpmyadmin-and-command-line\/","og_locale":"en_US","og_type":"article","og_title":"How to Change Wordpress Website and Home Url in PhpMyAdmin & Command line","og_description":"Here is the step by step solution for changing wordpress website & home url using\u00a0 the command line and PhpMyAdmin","og_url":"https:\/\/iserversupport.com\/blog\/how-to-change-wordpress-website-and-home-url-in-phpmyadmin-and-command-line\/","og_site_name":"Server Management Company - Outsourced Webhosting Service","article_publisher":"https:\/\/facebook.com\/iserversupport","article_published_time":"2022-04-14T19:42:33+00:00","article_modified_time":"2022-09-06T05:46:04+00:00","og_image":[{"url":"https:\/\/iserversupport.com\/wp-content\/uploads\/2022\/03\/wordpresshomeurl1.png"}],"author":"iServerSupport","twitter_card":"summary_large_image","twitter_creator":"@iserversupport","twitter_site":"@iserversupport","twitter_misc":{"Written by":"iServerSupport","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/iserversupport.com\/blog\/how-to-change-wordpress-website-and-home-url-in-phpmyadmin-and-command-line\/#article","isPartOf":{"@id":"https:\/\/iserversupport.com\/blog\/how-to-change-wordpress-website-and-home-url-in-phpmyadmin-and-command-line\/"},"author":{"name":"iServerSupport","@id":"https:\/\/iserversupport.com\/blog\/#\/schema\/person\/414757a5feb39cada3a64aece076ce39"},"headline":"How to change wordpress url ?","datePublished":"2022-04-14T19:42:33+00:00","dateModified":"2022-09-06T05:46:04+00:00","mainEntityOfPage":{"@id":"https:\/\/iserversupport.com\/blog\/how-to-change-wordpress-website-and-home-url-in-phpmyadmin-and-command-line\/"},"wordCount":259,"commentCount":0,"publisher":{"@id":"https:\/\/iserversupport.com\/blog\/#organization"},"image":{"@id":"https:\/\/iserversupport.com\/blog\/how-to-change-wordpress-website-and-home-url-in-phpmyadmin-and-command-line\/#primaryimage"},"thumbnailUrl":"https:\/\/iserversupport.com\/wp-content\/uploads\/2022\/03\/wordpresshomeurl1.png","inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/iserversupport.com\/blog\/how-to-change-wordpress-website-and-home-url-in-phpmyadmin-and-command-line\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/iserversupport.com\/blog\/how-to-change-wordpress-website-and-home-url-in-phpmyadmin-and-command-line\/","url":"https:\/\/iserversupport.com\/blog\/how-to-change-wordpress-website-and-home-url-in-phpmyadmin-and-command-line\/","name":"How to Change Wordpress Website and Home Url in PhpMyAdmin & Command line","isPartOf":{"@id":"https:\/\/iserversupport.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/iserversupport.com\/blog\/how-to-change-wordpress-website-and-home-url-in-phpmyadmin-and-command-line\/#primaryimage"},"image":{"@id":"https:\/\/iserversupport.com\/blog\/how-to-change-wordpress-website-and-home-url-in-phpmyadmin-and-command-line\/#primaryimage"},"thumbnailUrl":"https:\/\/iserversupport.com\/wp-content\/uploads\/2022\/03\/wordpresshomeurl1.png","datePublished":"2022-04-14T19:42:33+00:00","dateModified":"2022-09-06T05:46:04+00:00","description":"Here is the step by step solution for changing wordpress website & home url using\u00a0 the command line and PhpMyAdmin","inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/iserversupport.com\/blog\/how-to-change-wordpress-website-and-home-url-in-phpmyadmin-and-command-line\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/iserversupport.com\/blog\/how-to-change-wordpress-website-and-home-url-in-phpmyadmin-and-command-line\/#primaryimage","url":"https:\/\/iserversupport.com\/wp-content\/uploads\/2022\/03\/wordpresshomeurl1.png","contentUrl":"https:\/\/iserversupport.com\/wp-content\/uploads\/2022\/03\/wordpresshomeurl1.png"},{"@type":"WebSite","@id":"https:\/\/iserversupport.com\/blog\/#website","url":"https:\/\/iserversupport.com\/blog\/","name":"Server Management Company - Outsourced Webhosting Service","description":"Complete server management service","publisher":{"@id":"https:\/\/iserversupport.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/iserversupport.com\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/iserversupport.com\/blog\/#organization","name":"iServerSupport","url":"https:\/\/iserversupport.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/iserversupport.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/iserversupport.com\/wp-content\/uploads\/2020\/09\/I-SERVER-SUPPORT-07-1-e1606382474222.png","contentUrl":"https:\/\/iserversupport.com\/wp-content\/uploads\/2020\/09\/I-SERVER-SUPPORT-07-1-e1606382474222.png","width":20,"height":19,"caption":"iServerSupport"},"image":{"@id":"https:\/\/iserversupport.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/facebook.com\/iserversupport","https:\/\/x.com\/iserversupport"]},{"@type":"Person","@id":"https:\/\/iserversupport.com\/blog\/#\/schema\/person\/414757a5feb39cada3a64aece076ce39","name":"iServerSupport","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/iserversupport.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/ab568d65092a1e7994bb3aa6f4a4a1ba?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ab568d65092a1e7994bb3aa6f4a4a1ba?s=96&d=mm&r=g","caption":"iServerSupport"},"sameAs":["https:\/\/iserversupport.com"]}]}},"_links":{"self":[{"href":"https:\/\/iserversupport.com\/blog\/wp-json\/wp\/v2\/posts\/23905"}],"collection":[{"href":"https:\/\/iserversupport.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/iserversupport.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/iserversupport.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/iserversupport.com\/blog\/wp-json\/wp\/v2\/comments?post=23905"}],"version-history":[{"count":5,"href":"https:\/\/iserversupport.com\/blog\/wp-json\/wp\/v2\/posts\/23905\/revisions"}],"predecessor-version":[{"id":24312,"href":"https:\/\/iserversupport.com\/blog\/wp-json\/wp\/v2\/posts\/23905\/revisions\/24312"}],"wp:attachment":[{"href":"https:\/\/iserversupport.com\/blog\/wp-json\/wp\/v2\/media?parent=23905"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/iserversupport.com\/blog\/wp-json\/wp\/v2\/categories?post=23905"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/iserversupport.com\/blog\/wp-json\/wp\/v2\/tags?post=23905"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}