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 Manage Your Plugins in WordPress

This tutorial will teach you how to manage your plugins in WordPress. First you need to log in...

How to Update Your WordPress Installation

This tutorial will teach you how to update your WordPress installation. You should be logged in...

How to Manage Categories in WordPress

This tutorial will help you learn how to manage your categories in the WordPress program. You...

How to install WordPress using Quickinstall

Log into your cPanel. In the Software/Services section, click on the Quick Install icon: In...

How to Edit Your Profile in WordPress

This tutorial will teach you how to edit your profile in WordPress. You should be logged in, and...


Our official partners