Change WordPress Site URL Via phpMyAdmin

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

Log into the cPanel account for the domain in question.

Click on the “phpMyAdmin” icon within the “Databases” section.

web-hosting-india

Expand the database associated with the WordPress installation and select the “wp_options” table.

linux-web-hosting-india

Search for “siteurl” within the “option_name” column and click the “Edit” link on the same row.

web-hosting-india

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

reseller-hosting

Click the “Go” button when done.

linux-reseller-hosting

This should take you back to the wp_options table where the new domain will now be listed.

reseller-hosting-adhava-host

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

linux-web-hosting

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

Adhava Host