How to Change WordPress URL in Database: A MySQL Tutorial Using phpMyAdmin

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 learn how to do it.

1. Determining the Name of WordPress MySQL Database

Skip this part if you only have one MySQL database. However, if you have multiple databases and are not sure which one is connected to your WordPress, then follow the steps below.

WordPress stores the MySQL database names and their credentials in the wp-config.php file. You can find this file in your root file directory:

  1. Access your hPanel and open File Manager.
  2. Select the domain name, then click Go to File Manager.
File Manager under the Files section of your hPanel.
  1. Open wp-config.php and search for DB_NAME. The value of this par#ameter is your database name. For instance, the name of our MySQL database is u923246418_gagap.
wp-config.php page, searching for DB_NAME
  1. Go to phpMyAdmin via your website’s control panel.
  2. The left panel lists all of your databases. Select the one connected to your WordPress site and head to the SQL tab.
phpMyAdmin run SQL query/queries on database
  1. Enter the following SQL query:

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.

Important! Your table prefix might not be wp_. See the correct table prefix on the left panel of phpMyAdmin, and update the SQL query.

  • Press Go. You will see success messages along with the number of changed rows. Note that the number of rows will be different for each WordPress website.
    This image shows that you have successfully changed your WordPress URLs
  • The last thing we need to do is verify the changes. Open the wp_options table and check the option_value ofsiteurl and home. You should see your new URL.
    The new URLs in wp_options table
  • 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.

    Conclusion

    We have 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!

    Change WordPress URL in Database FAQ

    Once you know how to change WordPress URLs in your database, here are some frequently asked questions about the topic.

    How Do I Change the URL in MySQL?

    Changing the URL in MySQL requires some technical knowledge. First, you’ll need to open the database where your URL is stored, often in the data folder within your MySQL installation directory. Then, use a text editor to find and replace all instances of the old URL with the new one.

    How Do I Connect My WordPress Website to MySQL Database?

    First, log in to your hosting account and launch phpMyAdmin. There, click on the Import link from the top menu and then the Choose file button. Select your WordPress database to connect the two.

    Can I Change My WordPress Database Name?

    Yes, it is possible to change your WordPress database name. Once you access the phpMyAdmin from your hosting account, click on the Operations tab. Under Rename database to, enter the new name and click Go.

    Author
    The author

    Domantas G.

    Domantas leads the content and SEO teams forward with fresh ideas and out of the box approaches. Armed with extensive SEO and marketing knowledge, he aims to spread the word of Hostinger to every corner of the world. During his free time, Domantas likes to hone his web development skills and travel to exotic places.