Change WordPress Site URL Via phpMyAdmin

Published on: March 30, 2014
Difficulty: Easy

How to change your WordPress installation’s site URL in the event you no longer have access to the previous domain name.
NOTE: Before proceeding with any change, it is HIGHLY recommended you save a backup of your database prior to making any changes: https://www.hostdime.com/resources/backup-mysql-how-to-backup-your-mysql-database-in-cpanel/

 

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

  2. Click on the “phpMyAdmin” icon within the “Databases” section.
    Wordpress SiteURL phpMyAdmin 1

  3. Expand the database associated with the WordPress installation and select the “wp_options” table.
    Wordpress SiteURL phpMyAdmin 2

  4. Search for “siteurl” within the “option_name” column and click the “Edit” link on the same row.
    Wordpress SiteURL phpMyAdmin 3

  5. Change the domain name within the “option_value” section.
    NOTE: Be sure to only change the domain name and not the directory.
    Wordpress SiteURL phpMyAdmin 4

  6. Click the “Go” button when done.
    Wordpress SiteURL phpMyAdmin 5

  7. This should take you back to the wp_options table where the new domain will now be listed.
    Wordpress SiteURL phpMyAdmin 6

  8. Navigate through the pages and search for “home” within the “option_name” column and click the “Edit” link on the same row.
    Wordpress SiteURL phpMyAdmin 7

  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.



Back To Top