When you decide to change your site’s address, you have different options to do so. Sometimes, when you do it from your site’s dashboard, it might not work properly. So, the best solution is to use the MySQL database of your WordPress site.
In this tutorial, you will have a step by step guide that will help you change WordPress URLs using phpMyAdmin. I understand it can be a little bit technical, but there’s nothing to worry about.
Before you start, I suggest you have a backup of the database for safety.
Steps to Edit Site URLs From The Database
Editing the database can be overwhelming. So, please be careful while following these steps.
Search for the database section and open phpMyAdmin.
From the left-sidebar, click on the database name.If you have multiple sites, please ensure that you open the database of your current site you’re trying to make changes to.
You will see many database tables on the main content area.
Note: For security reasons, many users or security plugins change the prefix from wp_ to something else. So, look for _options.
Once you open the wp_options table, you will see many rows and columns.
Click on the “Edit” link from the left.
You will see the current URL of your site. You have to
It will be for the “option_value” field.
Follow the same procedure you follow for “siteurl” and save changes.
Once you do it, check your site after clearing your browser’s cache and cookies. Sometimes, the old data prevents you from seeing the updated version of a site.
Please note that links to the old address of your site might be broken. To fix them, you might need to install and activate a redirect plugin. However, there’s no surety of it. You have to search for broken links using an online tool.
Was it so hard to change WordPress URLs in MySQL database? Following a simple few steps isn’t so difficult.
You have to be careful about editing anything else instead of the wp_options table content. I suggest you check the screenshots properly.
- Check out our recommendations for the best wordpress web hosting.