{"id":8776,"date":"2019-12-20T07:37:44","date_gmt":"2019-12-20T07:37:44","guid":{"rendered":"https:\/\/www.milesweb.in\/hosting-faqs\/?p=8776"},"modified":"2022-02-15T15:45:54","modified_gmt":"2022-02-15T10:15:54","slug":"how-to-change-wordpress-url-using-phpmyadmin-in-cpanel","status":"publish","type":"post","link":"https:\/\/www.milesweb.in\/hosting-faqs\/how-to-change-wordpress-url-using-phpmyadmin-in-cpanel\/","title":{"rendered":"How To Change WordPress URL using phpMyAdmin in cPanel"},"content":{"rendered":"

This guide explains how to manually change a WordPress URL using phpMyAdmin and cPanel that can update your domain or WordPress installation path.<\/p>\n

Sometimes, there can be a need to manually change the URL for your WordPress site directly in the database. For example: if your domain name on the cPanel account gets changed to a different domain and you have a WordPress installed, then the domain name gets changed on the cPanel but not in the database. So, in such cases, you can manually change the WordPress URL by performing the following steps.<\/p>\n

1) First of all, find out the database name that is being used for the WordPress site whose URL needs to be changed<\/strong>. For this, locate the wp-config.php file<\/strong>, and navigate to the File Manager in cPanel<\/strong>.<\/p>\n

\"cPanel<\/a><\/p>\n

2) By default, the File Manager opens in the “home” directory. Double-click on it and navigate to the public_html<\/strong> directory. In this directory, your publicly accessible files are located.<\/p>\n

\"cPanel<\/a><\/p>\n

3) After entering into the public_html directory, you will see all your WordPress files. Remember, in case you have installed WordPress in another directory like “wp”, “blog”, etc. you will have to navigate into that folder.<\/p>\n

Navigate to “wp-config.php”<\/strong> file and right-click on the file and then click “view”<\/strong>.<\/p>\n

\"cPanel<\/a><\/p>\n

4) Once you click on view, the wp-config.php file should get open in another tab in your browser. Now, scroll down till you find the section named as \/* The name of the database for WordPress*\\<\/strong> line.<\/p>\n

\"cPanel<\/p>\n

You can see the database name is “mileswebdemo_w209”<\/strong>. In your case, this entry will be different from the same format.<\/p>\n

5) Now, you will have to locate a database in phpMyAdmin via cPanel<\/strong>. So, go back to cPanel and click on phpMyAdmin<\/strong>.<\/p>\n

\"cPanel<\/a><\/p>\n

6) You can see, phpMyAdmin will be opened in another tab on your browser. Now, you will have to locate the database name that has been previously identified from viewing the wp-config.php file. In case you have multiple databases, make sure that you are choosing the one that is specifically noted in the wp-config.php file in the previous step. Now click on +<\/strong> sign to expand the tables.<\/p>\n

\"cPanel<\/a><\/p>\n

7) Once tables get expanded, locate the wp_options<\/strong> table. Remember, the prefix of your database doesn’t need to be wp_ so just look for the second of the prefix which would be _options<\/strong>.<\/p>\n

After locating the _options table, click on the table to display the entries. Identify 2 entries that you want to modify:<\/p>\n

\u2013 option_name: siteurl<\/strong><\/p>\n

\u00a0\u2013 option_name: home<\/strong><\/p>\n

\"cPanel<\/a><\/p>\n

In option value section we can see our URL as :<\/p>\n

https:\/\/www.mileswebdemo.com\/wordpress<\/p>\n

https:\/\/www.mileswebdemo.com\/wordpress<\/p>\n

Similarly, you should see your site’s URL.<\/p>\n

Once the URL entries are located, click on the edit option on the left side of each entry to enter a new domain. While entering your new URL in this file, remember to include the http:\/\/or https:\/\/<\/strong> portion of your domain. After entering the new domain in a proper format, click on the Go<\/strong> button.<\/p>\n

\"cPanel<\/a><\/p>\n

8) After clicking on Go, you will be redirected back to the previous page where you can perform the same activities for the 2nd entry, the home URL. Make sure that both entries listed to match. For example for MilesWeb the entries should be :<\/p>\n

https:\/\/www.mileswebdemo.com\/wordpress<\/p>\n

https:\/\/www.mileswebdemo.com\/wordpress<\/p>\n

If these two don’t match, the site will not get load properly.<\/p>\n

9) After changing both URLs to the new URL your site will load properly. You will have to clear some caching plugins or browser caches as well. In case you have any issues reach out to our support helpline.<\/p>\n

That’s it!<\/p>\n

Also Read :<\/strong><\/p>\n

\u00a0Learn to stage a WordPress website using Softaculous in cPanel<\/strong><\/a><\/p>\n

\u00a0How to configure WordPress Permalink Structure?<\/strong><\/a><\/p>\n

\u00a0A Complete Guide to Customization of WordPress Fonts<\/strong><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

This guide explains how to manually change a WordPress URL using phpMyAdmin and cPanel that can update your domain or WordPress installation path. Sometimes, there can be a need to manually change the URL for your WordPress site directly in the database. For example: if your domain name on the cPanel account gets changed to […]<\/p>\n","protected":false},"author":18,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[41],"tags":[1182,1183,152,629,78],"class_list":["post-8776","post","type-post","status-publish","format-standard","placeholder-for-hentry","category-howtos","tag-change-wordpress-url","tag-change-wordpress-url-using-phpmyadmin-in-cpanel","tag-cpanel","tag-phpmyadmin","tag-wordpress-2"],"yoast_head":"\nHow To Change WordPress URL using phpMyAdmin in cPanel - Web Hosting FAQs by MilesWeb<\/title>\n<meta name=\"description\" content=\"This article is an easy guide on how to change WordPress URL using phpMyAdmin in cPanel.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.milesweb.in\/hosting-faqs\/how-to-change-wordpress-url-using-phpmyadmin-in-cpanel\/\" \/>\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 URL using phpMyAdmin in cPanel - Web Hosting FAQs by MilesWeb\" \/>\n<meta property=\"og:description\" content=\"This article is an easy guide on how to change WordPress URL using phpMyAdmin in cPanel.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.milesweb.in\/hosting-faqs\/how-to-change-wordpress-url-using-phpmyadmin-in-cpanel\/\" \/>\n<meta property=\"og:site_name\" content=\"Web Hosting FAQs by MilesWeb\" \/>\n<meta property=\"article:published_time\" content=\"2019-12-20T07:37:44+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-02-15T10:15:54+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2019\/12\/cPanel-File-Manager.jpg\" \/>\n<meta name=\"author\" content=\"Sonam Wagh\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Sonam Wagh\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.milesweb.in\/hosting-faqs\/how-to-change-wordpress-url-using-phpmyadmin-in-cpanel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.milesweb.in\/hosting-faqs\/how-to-change-wordpress-url-using-phpmyadmin-in-cpanel\/\"},\"author\":{\"name\":\"Sonam Wagh\",\"@id\":\"https:\/\/www.milesweb.in\/hosting-faqs\/#\/schema\/person\/dc645d02823c86e07e53798ebe02c6f4\"},\"headline\":\"How To Change WordPress URL using phpMyAdmin in cPanel\",\"datePublished\":\"2019-12-20T07:37:44+00:00\",\"dateModified\":\"2022-02-15T10:15:54+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.milesweb.in\/hosting-faqs\/how-to-change-wordpress-url-using-phpmyadmin-in-cpanel\/\"},\"wordCount\":642,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.milesweb.in\/hosting-faqs\/how-to-change-wordpress-url-using-phpmyadmin-in-cpanel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2019\/12\/cPanel-File-Manager.jpg\",\"keywords\":[\"change WordPress URL\",\"change WordPress URL using phpMyAdmin in cPanel\",\"cPanel\",\"phpmyadmin\",\"WordPress\"],\"articleSection\":[\"How-Tos\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.milesweb.in\/hosting-faqs\/how-to-change-wordpress-url-using-phpmyadmin-in-cpanel\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.milesweb.in\/hosting-faqs\/how-to-change-wordpress-url-using-phpmyadmin-in-cpanel\/\",\"url\":\"https:\/\/www.milesweb.in\/hosting-faqs\/how-to-change-wordpress-url-using-phpmyadmin-in-cpanel\/\",\"name\":\"How To Change WordPress URL using phpMyAdmin in cPanel - Web Hosting FAQs by MilesWeb\",\"isPartOf\":{\"@id\":\"https:\/\/www.milesweb.in\/hosting-faqs\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.milesweb.in\/hosting-faqs\/how-to-change-wordpress-url-using-phpmyadmin-in-cpanel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.milesweb.in\/hosting-faqs\/how-to-change-wordpress-url-using-phpmyadmin-in-cpanel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2019\/12\/cPanel-File-Manager.jpg\",\"datePublished\":\"2019-12-20T07:37:44+00:00\",\"dateModified\":\"2022-02-15T10:15:54+00:00\",\"author\":{\"@id\":\"https:\/\/www.milesweb.in\/hosting-faqs\/#\/schema\/person\/dc645d02823c86e07e53798ebe02c6f4\"},\"description\":\"This article is an easy guide on how to change WordPress URL using phpMyAdmin in cPanel.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.milesweb.in\/hosting-faqs\/how-to-change-wordpress-url-using-phpmyadmin-in-cpanel\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.milesweb.in\/hosting-faqs\/how-to-change-wordpress-url-using-phpmyadmin-in-cpanel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.milesweb.in\/hosting-faqs\/how-to-change-wordpress-url-using-phpmyadmin-in-cpanel\/#primaryimage\",\"url\":\"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2019\/12\/cPanel-File-Manager.jpg\",\"contentUrl\":\"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2019\/12\/cPanel-File-Manager.jpg\",\"width\":1022,\"height\":588,\"caption\":\"cPanel File Manager\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.milesweb.in\/hosting-faqs\/how-to-change-wordpress-url-using-phpmyadmin-in-cpanel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.milesweb.in\/hosting-faqs\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How To Change WordPress URL using phpMyAdmin in cPanel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.milesweb.in\/hosting-faqs\/#website\",\"url\":\"https:\/\/www.milesweb.in\/hosting-faqs\/\",\"name\":\"Web Hosting FAQs by MilesWeb\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.milesweb.in\/hosting-faqs\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.milesweb.in\/hosting-faqs\/#\/schema\/person\/dc645d02823c86e07e53798ebe02c6f4\",\"name\":\"Sonam Wagh\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.milesweb.in\/hosting-faqs\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2019\/12\/Sonam-Wagh-150x150.jpg\",\"contentUrl\":\"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2019\/12\/Sonam-Wagh-150x150.jpg\",\"caption\":\"Sonam Wagh\"},\"description\":\"With an interest in doing something creative daily, Sonam works as a Digital Marketing Executive. She likes to write technical blogs related to web hosting, digital marketing, and other IT topics. She also likes to spend her leisure time on social media to find different strategies for client engagement.\",\"url\":\"https:\/\/www.milesweb.in\/hosting-faqs\/author\/sonam\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How To Change WordPress URL using phpMyAdmin in cPanel - Web Hosting FAQs by MilesWeb","description":"This article is an easy guide on how to change WordPress URL using phpMyAdmin in cPanel.","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:\/\/www.milesweb.in\/hosting-faqs\/how-to-change-wordpress-url-using-phpmyadmin-in-cpanel\/","og_locale":"en_US","og_type":"article","og_title":"How To Change WordPress URL using phpMyAdmin in cPanel - Web Hosting FAQs by MilesWeb","og_description":"This article is an easy guide on how to change WordPress URL using phpMyAdmin in cPanel.","og_url":"https:\/\/www.milesweb.in\/hosting-faqs\/how-to-change-wordpress-url-using-phpmyadmin-in-cpanel\/","og_site_name":"Web Hosting FAQs by MilesWeb","article_published_time":"2019-12-20T07:37:44+00:00","article_modified_time":"2022-02-15T10:15:54+00:00","og_image":[{"url":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2019\/12\/cPanel-File-Manager.jpg","type":"","width":"","height":""}],"author":"Sonam Wagh","twitter_misc":{"Written by":"Sonam Wagh","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.milesweb.in\/hosting-faqs\/how-to-change-wordpress-url-using-phpmyadmin-in-cpanel\/#article","isPartOf":{"@id":"https:\/\/www.milesweb.in\/hosting-faqs\/how-to-change-wordpress-url-using-phpmyadmin-in-cpanel\/"},"author":{"name":"Sonam Wagh","@id":"https:\/\/www.milesweb.in\/hosting-faqs\/#\/schema\/person\/dc645d02823c86e07e53798ebe02c6f4"},"headline":"How To Change WordPress URL using phpMyAdmin in cPanel","datePublished":"2019-12-20T07:37:44+00:00","dateModified":"2022-02-15T10:15:54+00:00","mainEntityOfPage":{"@id":"https:\/\/www.milesweb.in\/hosting-faqs\/how-to-change-wordpress-url-using-phpmyadmin-in-cpanel\/"},"wordCount":642,"commentCount":0,"image":{"@id":"https:\/\/www.milesweb.in\/hosting-faqs\/how-to-change-wordpress-url-using-phpmyadmin-in-cpanel\/#primaryimage"},"thumbnailUrl":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2019\/12\/cPanel-File-Manager.jpg","keywords":["change WordPress URL","change WordPress URL using phpMyAdmin in cPanel","cPanel","phpmyadmin","WordPress"],"articleSection":["How-Tos"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.milesweb.in\/hosting-faqs\/how-to-change-wordpress-url-using-phpmyadmin-in-cpanel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.milesweb.in\/hosting-faqs\/how-to-change-wordpress-url-using-phpmyadmin-in-cpanel\/","url":"https:\/\/www.milesweb.in\/hosting-faqs\/how-to-change-wordpress-url-using-phpmyadmin-in-cpanel\/","name":"How To Change WordPress URL using phpMyAdmin in cPanel - Web Hosting FAQs by MilesWeb","isPartOf":{"@id":"https:\/\/www.milesweb.in\/hosting-faqs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.milesweb.in\/hosting-faqs\/how-to-change-wordpress-url-using-phpmyadmin-in-cpanel\/#primaryimage"},"image":{"@id":"https:\/\/www.milesweb.in\/hosting-faqs\/how-to-change-wordpress-url-using-phpmyadmin-in-cpanel\/#primaryimage"},"thumbnailUrl":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2019\/12\/cPanel-File-Manager.jpg","datePublished":"2019-12-20T07:37:44+00:00","dateModified":"2022-02-15T10:15:54+00:00","author":{"@id":"https:\/\/www.milesweb.in\/hosting-faqs\/#\/schema\/person\/dc645d02823c86e07e53798ebe02c6f4"},"description":"This article is an easy guide on how to change WordPress URL using phpMyAdmin in cPanel.","breadcrumb":{"@id":"https:\/\/www.milesweb.in\/hosting-faqs\/how-to-change-wordpress-url-using-phpmyadmin-in-cpanel\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.milesweb.in\/hosting-faqs\/how-to-change-wordpress-url-using-phpmyadmin-in-cpanel\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.milesweb.in\/hosting-faqs\/how-to-change-wordpress-url-using-phpmyadmin-in-cpanel\/#primaryimage","url":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2019\/12\/cPanel-File-Manager.jpg","contentUrl":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2019\/12\/cPanel-File-Manager.jpg","width":1022,"height":588,"caption":"cPanel File Manager"},{"@type":"BreadcrumbList","@id":"https:\/\/www.milesweb.in\/hosting-faqs\/how-to-change-wordpress-url-using-phpmyadmin-in-cpanel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.milesweb.in\/hosting-faqs\/"},{"@type":"ListItem","position":2,"name":"How To Change WordPress URL using phpMyAdmin in cPanel"}]},{"@type":"WebSite","@id":"https:\/\/www.milesweb.in\/hosting-faqs\/#website","url":"https:\/\/www.milesweb.in\/hosting-faqs\/","name":"Web Hosting FAQs by MilesWeb","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.milesweb.in\/hosting-faqs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.milesweb.in\/hosting-faqs\/#\/schema\/person\/dc645d02823c86e07e53798ebe02c6f4","name":"Sonam Wagh","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.milesweb.in\/hosting-faqs\/#\/schema\/person\/image\/","url":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2019\/12\/Sonam-Wagh-150x150.jpg","contentUrl":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2019\/12\/Sonam-Wagh-150x150.jpg","caption":"Sonam Wagh"},"description":"With an interest in doing something creative daily, Sonam works as a Digital Marketing Executive. She likes to write technical blogs related to web hosting, digital marketing, and other IT topics. She also likes to spend her leisure time on social media to find different strategies for client engagement.","url":"https:\/\/www.milesweb.in\/hosting-faqs\/author\/sonam\/"}]}},"_links":{"self":[{"href":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-json\/wp\/v2\/posts\/8776","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-json\/wp\/v2\/users\/18"}],"replies":[{"embeddable":true,"href":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-json\/wp\/v2\/comments?post=8776"}],"version-history":[{"count":4,"href":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-json\/wp\/v2\/posts\/8776\/revisions"}],"predecessor-version":[{"id":15838,"href":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-json\/wp\/v2\/posts\/8776\/revisions\/15838"}],"wp:attachment":[{"href":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-json\/wp\/v2\/media?parent=8776"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-json\/wp\/v2\/categories?post=8776"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-json\/wp\/v2\/tags?post=8776"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}