How to change the WordPress site URLs using phpMyAdmin

There are many reasons which warrant a change of WordPress site URL. Top reasons include:

• Moving WordPress site from HTTP to HTTPS
• Migrating WordPress site to a new domain
• Moving WordPress site from local site to a live site
• Moving WordPress site to a different directory.

There are three ways to change or update WordPress URLs; this article describes how to change WordPress site URLs using phpMyAdmin.

Changing the WordPress site URL

To change the website URL in WordPress, follow these steps:

1. Log in to cPanel.
   If you do not know how to log in to your cPanel account, please see this article.
2. In the Databases section of the cPanel home screen, click phpMyAdmin:

   

3. In the left-hand pane of phpMyAdmin, click the WordPress database. A list of tables in the database appears:
   

   

   Typically, the WordPress database is username_wpXXX or username_a2wpXXX, where username represents your cPanel username, and XXX is a three-digit number.

4. Under the Table heading, click the wp_options table. A list of data rows appears:
   

   

5. Under the option_name heading, locate siteurl and home, and then click the pencil icon next to Edit the option value for each row:

6. 

7. Update the option_value field to the new site URL:
   

   • Make sure you type the correct URL, or your WordPress installation will be inaccessible.
   • Make sure the URL begins with http://.
   • Make sure the URL does not end with a forward slash (/).

8. Under the option_name heading, locate home, and then click Edit:
   

   

9. Click Go. phpMyAdmin saves the changes in the table. WordPress should now function correctly using the new URL.