How to change WordPress URLs

    October 16, 2019


    Using phpMyAdmin

    ATTENTION: SiteWorx is only available to Nexcess clients on physical (non-cloud) servers. If you are a Nexcess Cloud client, learn about how to access phpMyAdmin from What is phpMyAdmin?, then begin at Step 3.

    1. Log in to your SiteWorx account.

      • If you do not know your password, click Forgot your password on the login page.
      • If you do not know the web address for your SiteWorx login page, either refer to your Welcome Email or contact our 24/7 support team for assistance.

    2. From the main menu, select Hosting Features > MySQL > PhpMyAdmin.
    3. From the main menu, select the desired database, then click wp_options.
    4. In the main table, locate the wp_options table.
    5. In the option_name column, locate the siteurl entry and click the corresponding Edit option.In the option_value field, enter the URL, then click Go.
    6. Under the option_name column, locate the home entry, and corresponding Edit option.As in Step 5, in the option_value field, enter the URL, and then click Go to save the change.

    7. If you have a WordPress caching module, flush the module's cache, and the new URLs should work correctly. 

    Using the command line (CLI)

    This method requires SSH access. If you are a Nexcess Classic (non-Cloud) client, first see How to enable SSH access. If you are a Nexcess Cloud client, SSH access is on by default.

    1. Log in to your server, using SSH credentials provided to you by a Nexcess support technician.

    2. Enter your MySQL database by executing the below command, but replace the angled brackets (<>) and everything between them with the name of the WordPress database:
      use <database>

    3. Execute the following commands, replacing the the angled brackets (<>) and everything between them with the indicated information:
      UPDATE wp_options SET option_value = replace(option_value, 'http://www.<old_url>', 'http://www.<new_url>') WHERE option_name = 'home' OR option_name = '<siteurl>';
      UPDATE wp_posts SET post_content = replace(post_content, 'http://www.<old_url>', 'http://www.<new_url>');
      UPDATE wp_postmeta SET meta_value = replace(meta_value,'http://www.<old_url>','http://www.<new_url>');
    4. If you have a WordPress caching module, flush the module's cache, and the new URLs should work properly.  


    For 24-hour assistance any day of the year, contact our support team by email or through your Client Portal.

    Was this article helpful?

    Send feedback

    Can’t find what you’re looking for?

    Our award-winning customer care team is here for you.

    Contact Support