June 16, 2020
June 16, 2020
WordPress uses MySQL database to store all its data, including site URLs. So if for some reason you need to change your WordPress URL, it’s necessary to tweak some data in MySQL. Keep reading to know how to do it!
Upgrade to WordPress Hosting with Hostinger today! With a guaranteed 99.99% uptime!
You can skip this part if you only have one MySQL database. However, if you have multiple databases and not sure which one is connected to WordPress, then follow the steps below.
WordPress stores MySQL database name and its credentials in the wp-config.php file. You can find this file in your root file directory:
Replacing your old URL is not difficult at all. Here’s what you need to do:
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');
Replace oldurl.com with your current WordPress address and newurl.com with your new WordPress address.
Your table prefix might not be wp_. See the correct table prefix on the left panel of phpMyAdmin, and update the SQL query.
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.
We just learned how to change WordPress URLs in the MySQL database using phpMyAdmin.
As we can see, all the steps above are quite straightforward. You just need to determine the correct database and then input some lines of code.
We hope this tutorial can give you clear guidance on how to change WordPress URLs in the MySQL database. Kindly leave any questions you have below!
April 04 2018
Hi, I followed your instructions but it seems my new site still redirects to the old URL. I've checked the wp_options as you said and it's all pointing to the new. Very weird. Pat
Replied on April 28 2018
Hey Pat, Do you have any kind of caching plugin installed? if so, try to clear cache or disable the plugin
October 25 2019
This worked wonderfully well for me. Thank you!
January 01 2020
helpful post for a developer, thanks!
February 08 2020
thanks for share this article
June 20 2020
Excellent and well documented solution! Thanks
June 26 2020
What if we don't have any table of wp_options ?
Replied on July 07 2020
Hey Christine! :) Perhaps you can check if you are using a custom prefix for the tables? In wp-config.php you can change the prefix of the tables, so if you set it to for example blog, your table would be blog_options. Additionally, make sure to select "Show ALL" instead of "Show 25" which is the default value for the shown tables in phpMyAdmin :)