How to change your WordPress url via the Database

How to change your WordPress installation’s site URL in the event you no longer have access to the previous domain name.

  1. Log into the cPanel account for the domain in question.

  2. Click on the “phpMyAdmin” icon within the “Databases” section.
    https://kenyawebexperts.com/images/Change%20WordPress%20Site%20URL%20Via%20phpMyAdmin1.png

  3. Expand the database associated with the WordPress installation and select the “wp_options” table.
    https://kenyawebexperts.com/images/Change%20WordPress%20Site%20URL%20Via%20phpMyAdmin2.png

  4. Search for “siteurl” within the “option_name” column and click the “Edit” link on the same row.
    https://kenyawebexperts.com/images/Change%20WordPress%20Site%20URL%20Via%20phpMyAdmin3.png

  5. Change the domain name within the “option_value” section.
    NOTE: Be sure to only change the domain name and not the directory.
    https://kenyawebexperts.com/images/Change%20WordPress%20Site%20URL%20Via%20phpMyAdmin4.png

  6. Click the “Go” button when done.
    https://kenyawebexperts.com/images/Change%20WordPress%20Site%20URL%20Via%20phpMyAdmin5.png

  7. This should take you back to the wp_options table where the new domain will now be listed.
    https://kenyawebexperts.com/images/Change%20WordPress%20Site%20URL%20Via%20phpMyAdmin6.png

  8. Navigate through the pages and search for “home” within the “option_name” column and click the “Edit” link on the same row.
    https://kenyawebexperts.com/images/Change%20WordPress%20Site%20URL%20Via%20phpMyAdmin7.png

  9. Repeat steps 5 and 6 to change the URL.

  10. Once done, you should now be able to access WordPress using the new domain name.

Was this answer helpful?

 Print this Article

Also Read

How to Move WordPress From Local Server to Live Site

Developing a WordPress site locally can help speed up the development process. In the past, we...

Moving Directories On Your Existing Server

Step 1: Updating Wordpress URLsLog in to your website Admin page ie yourdomain.com/wp/wp-adminGo...

WordPress is giving error: "Missing a temporary folder" while uploading image/media ?

WordPress is giving error on image upload : "image.jpg" has failed to upload due to an error...

HOW TO CHANGE A MULTISITE PRIMARY DOMAIN

If you want to change the primary domain of your WordPress multisite installation, there are 5...

How to install WordPress using Softaculous

WordPress is a free open source software that is available for install in your cPanel Softaculous...


Our official partners