In WordPress, the URLs of your website are stored in the MySQL database. If you need to change the URLs of your WordPress site, whether due to a domain change or moving from a local development environment to a live server, you can make the necessary changes directly in the database. In this guide, we will walk you through the steps to change the WordPress URLs in the MySQL database using the command line.<\/p>\n
First, you need to access your MySQL database using the command line. Open your terminal or SSH into your server and execute the following command:<\/p>\n
\r\nmysql -u username -p\r\n<\/pre>\nReplace ‘username’ with your MySQL username. You will be prompted to enter your MySQL password.<\/p>\n
Step 2: Select the WordPress Database:<\/h2>\n
Once you are logged into MySQL, you need to select the WordPress database. If you know the name of your WordPress database, use the following command:<\/p>\n
\r\nuse database_name;\r\n<\/pre>\nReplace ‘database_name’ with the actual name of your WordPress database.<\/p>\n
For example:<\/p>\n
\r\nmysql> use wordpressdb;\r\nReading table information for completion of table and column names\r\nYou can turn off this feature to get a quicker startup with -A\r\n\r\nDatabase changed\r\n<\/pre>\nCheck current value for ‘siteurl’ and ‘home’:<\/p>\n
\r\nmysql> SELECT option_name, option_value FROM wp_options WHERE option_name IN ('siteurl', 'home');\r\n+-------------+-----------------------------------+\r\n| option_name | option_value |\r\n+-------------+-----------------------------------+\r\n| home | https:\/\/www.webhostinggeeks.local |\r\n| siteurl | https:\/\/www.webhostinggeeks.local |\r\n+-------------+-----------------------------------+\r\n2 rows in set (0.00 sec)\r\n<\/pre>\nIf you are not sure about the database name, you can list all the available databases using the following command:<\/p>\n
\r\nshow databases;\r\n<\/pre>\nThen, select the appropriate database using the use command as shown above.<\/p>\n
Step 3: Update the URLs:<\/h2>\n
To change the URLs in the database, you need to update two specific tables: wp_options and wp_posts. Execute the following commands:<\/p>\n
\r\nUPDATE wp_options SET option_value = replace(option_value, 'old_url', 'new_url') WHERE option_name = 'home' OR option_name = 'siteurl';\r\n<\/pre>\nReplace ‘old_url’ with the current URL of your WordPress site and ‘new_url’ with the new URL you want to set.<\/p>\n
For example:<\/p>\n
\r\nmysql> UPDATE wp_options SET option_value = 'https:\/\/webhostinggeeks.com\/howto' WHERE option_name IN ('siteurl', 'home');\r\nQuery OK, 2 rows affected (0.00 sec)\r\nRows matched: 2 Changed: 2 Warnings: 0\r\n<\/pre>\nCheck the updated value for ‘siteurl’ and ‘home’ :<\/p>\n
\r\nmysql> SELECT option_name, option_value FROM wp_options WHERE option_name IN ('siteurl', 'home');\r\n\r\n+-------------+-----------------------------------+\r\n| option_name | option_value |\r\n+-------------+-----------------------------------+\r\n| home | https:\/\/webhostinggeeks.com\/howto |\r\n| siteurl | https:\/\/webhostinggeeks.com\/howto |\r\n+-------------+-----------------------------------+\r\n2 rows in set (0.00 sec)\r\n<\/pre>\nNext, execute the following command to update the URLs in the wp_posts table:<\/p>\n
\r\nUPDATE wp_posts SET post_content = replace(post_content, 'old_url', 'new_url');\r\n<\/pre>\nAgain, replace ‘old_url’ with the current URL and ‘new_url’ with the new URL.<\/p>\n
Step 4: Confirm the Changes:<\/h2>\n
To ensure that the changes have been made successfully, execute the following commands:<\/p>\n
\r\nSELECT option_value FROM wp_options WHERE option_name = 'home' OR option_name = 'siteurl';\r\nSELECT guid FROM wp_posts WHERE post_type = 'post' OR post_type = 'page';\r\n<\/pre>\nThese commands will display the updated URLs in the wp_options table and the guid column of the wp_posts table.<\/p>\n
Step 5: Exit MySQL:<\/h2>\n
Once you have confirmed the changes, you can exit the MySQL prompt by typing:<\/p>\n
\r\nexit\r\n<\/pre>\nCommands Mentioned:<\/h2>\n
\n
- sudo htpasswd<\/span> – Command to create a password file and set a password for a user.<\/li>\n
- cat<\/span> – Command to display the contents of a file.<\/li>\n
- sudo service apache2 restart<\/span> – Command to restart Apache web server on Ubuntu\/Debian systems.<\/li>\n
- sudo systemctl restart httpd<\/span> – Command to restart Apache web server on CentOS\/RHEL systems.<\/li>\n
- sudo apachectl restart<\/span> – Command to restart Apache web server on general systems.<\/li>\n
- mysql -u username -p<\/span> – Command to access MySQL database using the command line.<\/li>\n
- use database_name;<\/span> – Command to select a specific MySQL database.<\/li>\n
- show databases;<\/span> – Command to display all available MySQL databases.<\/li>\n
- UPDATE wp_options SET option_value = replace(option_value, ‘old_url’, ‘new_url’) WHERE option_name = ‘home’ OR option_name = ‘siteurl’;<\/span> – Command to update the URLs in the `wp_options` table of a WordPress database.<\/li>\n
- UPDATE wp_posts SET post_content = replace(post_content, ‘old_url’, ‘new_url’);<\/span> – Command to update the URLs in the `wp_posts` table of a WordPress database.<\/li>\n
- SELECT option_value FROM wp_options WHERE option_name = ‘home’ OR option_name = ‘siteurl’;<\/span> – Command to display the updated URLs in the `wp_options` table of a WordPress database.<\/li>\n
- SELECT guid FROM wp_posts WHERE post_type = ‘post’ OR post_type = ‘page’;<\/span> – Command to display the updated URLs in the `guid` column of the `wp_posts` table of a WordPress database.<\/li>\n
- exit<\/span> – Command to exit the MySQL prompt.<\/li>\n<\/ul>\n
Conclusion:<\/h2>\n
In this guide, we have learned how to change the WordPress URLs in the MySQL database using the command line. By following these steps, you can update the URLs of your WordPress site directly in the database, which is useful when you need to change domains or migrate your site. Remember to take a backup of your database before making any changes and double-check the URLs to avoid any errors.<\/p>\n
Feel free to comment below if you have any questions or suggestions for improvement.<\/p>\n","protected":false},"excerpt":{"rendered":"
In WordPress, the URLs of your website are stored in the MySQL database. If you need to change the URLs of your WordPress site, whether due to a domain change…<\/p>\n","protected":false},"author":6,"featured_media":6188,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"wds_primary_category":0,"footnotes":""},"categories":[2056,1008],"tags":[1585,1933],"class_list":["post-6014","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-cms","category-mysql","tag-mysql","tag-wordpress"],"_links":{"self":[{"href":"https:\/\/webhostinggeeks.com\/howto\/wp-json\/wp\/v2\/posts\/6014","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/webhostinggeeks.com\/howto\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/webhostinggeeks.com\/howto\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/webhostinggeeks.com\/howto\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/webhostinggeeks.com\/howto\/wp-json\/wp\/v2\/comments?post=6014"}],"version-history":[{"count":0,"href":"https:\/\/webhostinggeeks.com\/howto\/wp-json\/wp\/v2\/posts\/6014\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/webhostinggeeks.com\/howto\/wp-json\/wp\/v2\/media\/6188"}],"wp:attachment":[{"href":"https:\/\/webhostinggeeks.com\/howto\/wp-json\/wp\/v2\/media?parent=6014"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/webhostinggeeks.com\/howto\/wp-json\/wp\/v2\/categories?post=6014"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/webhostinggeeks.com\/howto\/wp-json\/wp\/v2\/tags?post=6014"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}