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:

    phpMyAdmin - WordPress options table

  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. phpMyAdmin - Edit siteurl value

  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:

    phpMyAdmin - Edit home value

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


Get Managed WordPress Hosting

Article Details

Other Articles in This Category

Show More

Did you find this article helpful? Then you'll love our support. Experience the A2 Hosting difference today and get a pre-secured, pre-optimized website. Check out our web hosting plans today.

We use cookies to personalize the website for you and to analyze the use of our website. You consent to this by clicking on "I consent" or by continuing your use of this website. Further information about cookies can be found in our Privacy Policy.