Change WordPress Site URL Via phpMyAdmin

How to change your WordPress installation 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.

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

Click on the "phpMyAdmin" icon within the "Databases" section.

 

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



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



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



Click the “Go†button when done.



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



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



Repeat steps to change the URL.

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

  • 7 Users Found This Useful
Was this answer helpful?

Related Articles

WordPress Fatal Memory Error

If you see an “allowed memory size exhausted” error in WordPress, this is one of the most...

How to reduce comment SPAM in WordPress

Spam in the comments section of your WordPress posts can quickly become an aggravating problem....

How to Manually Upgrade WordPress

This article covers how to upgrade WordPress. WordPress described the requirements for One-click...

Changing your WordPress URL and Site URL

This article covers changing your WordPress URL. For many people out there, the “WordPress...

How to Install Wordpress via Softaculous in cPanel?

1. Log into your cPanel account. 2. In the "Software" section, click on "Softaculous App...