How to Change WordPress URLs in MySQL Database Using phpMyAdmin

How to Change WordPress URLs in MySQL Database 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 know how to do it!

Upgrade to WordPress Hosting with Hostinger today! With a guaranteed 99.99% uptime!

Get Your Discount Here

1. Determining the Name of WordPress MySQL Database

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:

  1. Access your hPanel and open File Manager.
  2. Select the domain name, then click Go to File Manager.
    This image shows you how to go to the File Manager in hPanel
  3. Open wp-config.php and search for DB_NAME. The value of this parameter is your database name. For instance, the name of our MySQL database is u923246418_gagap.The DB_NAME parameter that contains the name of your MySQL database

2. Changing WordPress URLs in MySQL Database

Replacing your old URL is not difficult at all. Here’s what you need to do:

  1. Go to phpMyAdmin via your website control panel.
  2. The left panel list all of your databases. Select the one connected to your WordPress site and head to the SQL tab.Selecting the correct database in phpMyAdmin
  3. Enter the following SQL query:

    UPDATE wp_options SET option_value = replace(option_value, '', '') WHERE option_name = 'home' OR option_name = 'siteurl';UPDATE wp_posts SET guid = replace(guid, '','');UPDATE wp_posts SET post_content = replace(post_content, '', '');
    UPDATE wp_postmeta SET meta_value = replace(meta_value,'','');

    Replace with your current WordPress address and 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.

  4. 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
  5. The last thing we need to do is verify the changes. Open the wp_options table and check the option_value of siteurl 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.


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!

The Author


Domantas G. / @domantas

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.

Related tutorials


Pat Reply

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


    Domantas G.

    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


Apollos Reply

October 25 2019

This worked wonderfully well for me. Thank you!


Tawsif Shah Mostafa Reply

January 01 2020

helpful post for a developer, thanks!

Author Reply

February 08 2020

thanks for share this article


Joe Reply

June 20 2020

Excellent and well documented solution! Thanks


Christine Yeary Reply

June 26 2020

What if we don't have any table of wp_options ?


    Tomislav T.

    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 :)


Laura Reply

August 01 2020

Hi, I own a website hosted in the main domain, and the blog hosted in a subdomain. I want to change the blog URL, so it would have the same domain as the site. Do you think it will work if I use this tutorial? Or it might go wrong since the new domain already exists? Thank you for your attention, Laura


    Tomislav T.

    Replied on November 06 2020

    Hey Laura. If you want to make the subdomain have the exact same URL as the main domain, that would cause problems, and I'd advise against it :)


Larry G. Reply

August 04 2020

What about serialized data? If the URLs are not the same length, just replacing URLs might be a problem...


    Tomislav T.

    Replied on November 06 2020

    Hey Larry. This tutorial is more about the main website URL, not about URLs within the website (directories, posts, etc). I am afraid Serialized Data in WordPress is a bit out of my scope of knowledge so I'd recommend checking the great forum at which will surely offer some help on the topic! :)


Jerry Reply

August 10 2020

Hello, I have followed the process but now it sending Server IP not found error could you please help/?


    Tomislav T.

    Replied on November 06 2020

    Hey Jerry! I Can't see the error here but make sure the domain (URL) you've used is an active domain and is pointing correctly. Additionally make sure the domain is spelled correctly. For instance, if you used and your domain doesn't have WWW DNS record, the server IP won't be reached.


André Reply

September 06 2020

Replacing domains in your database in tables that uses the PHP serialize function to store its data, results in a corrupted database. A much simpler method of replacing all domains at once, and repairing these serialized structures is by using a tool like


    Tomislav T.

    Replied on November 11 2020

    Hey André. Great input - you can definitely achieve that with a tool such as search and replace. That being said - even the official WordPress guide mentions changing the URL via the database, so I believe it's quite rare that a database gets corrupted when doing this.


Oliur Rahman Reply

October 12 2020

Hello Excellent Information, I am highly recommended this blog. For these reasons, I have tried to find out a solution but, I don't get a very good solution. but I have got the right solution from here. Thanks



    Replied on February 02 2021

    Hi, Oliur! Happy it worked out ;)


Matthew Henderson Reply

October 20 2020

Worked great! thanks.

Leave a reply




This site uses Akismet to reduce spam. Learn how your comment data is processed.

Become a part of Hostinger now!

More in WordPress
How to Install WordPress Plugins