Call Anytime 1-888-278-9780 or
Live Chat

Changing WordPress URLs Using phpMyAdmin

This article shows how to change a URL for a website built in WordPress using phpMyAdmin, such as for example, changing "http://example.com/blog" to "http://example.com".

 Table of Contents
Make a selection to browse categories

Why Should I Change a WordPress URL?

Changing the location of your WordPress installation can be a somewhat challenging task. To do so, you need to find and work with the database name for your WordPress site. Overall, you will need to make a total of two URL changes inside of the database using phpMyAdmin.

NOTE: Changing the URL of your WordPress site will cause post images to not display if they are linked using a full image path. 

Change a WordPress URL

First, you need to locate the database name.

Locate the database name when WordPress was installed through SimpleScripts

  1. Log in to SimpleScripts via your account's control panel.
  2. Locate the WordPress site URL that you want to change, then select the Advanced link located directly below the URL for the WordPress site.



  3. Locate the name of the database, which is listed under "Database Connect Information."



  4. Continue to the instructions for logging in to your WordPress database using phpMyAdmin.
     

 

Locate the database name when WordPress was manually installed

  1. Locate the wp-config.php file in the root directory of your WordPress installation.
  2. The database name will be located as shown in the image below:



  3. Continue to the instructions for logging in to your WordPress database using phpMyAdmin.
     

 



Once you have located the database name, you next need to log in to your WordPress database using phpMyAdmin.

  1. Click the MySQL icon located in the Website section of your control panel.
  2. Select the database for your WordPress installation.
  3. Select Access phpMyAdmin, which will appear to the right after your database has been selected.
  4. Once logged in, all of the tables listed in your database will appear. Locate and click the table labeled wp_options.

    NOTE: The wp_ prefix may be different for manual installs.

  5. Once the table is selected, click the Browse icon located at the top of the screen.
  6. You will now be viewing the contents of the wp_options table. From here, click the Edit option for the siteurl listed under the option_name column.



  7. The text field will list the current URL for your WordPress installation. To change this, type the new URL and click Go.

    NOTE: http:// is required at the beginning of the URL.



  8. You will be redirected back to the contents of the wp_options table. From here, find the option_name listed as home and select Edit (it may be located on page 2).
  9. Follow the instructions in steps 6 and 7 above to change the URL.



 

Your WordPress URL should now be changed. To access your admin panel, go to http://NewWordPressURL/wp-admin (where NewWordPressURL is the the new URL name that you selected for your WordPress installation).


 

Update WordPress information in SimpleScripts after changing a URL

If you prefer to log in to WordPress through SimpleScripts, there is a easy way to modify the WordPress information to make the "admin link" accessible via SimpleScripts after changing the URL.

NOTE: This will only work after modifying the WordPress URL via the database.

  1. Log in to SimpleScripts via your account's control panel.
  2. Locate the WordPress installation whose URL was just changed using phpMyAdmin, and select the Uninstall link located below the WordPress URL.
  3. You will be redirected to a screen that allows you to either uninstall WordPress completely or remove it from the list. Select Remove From List.

    NOTE: DO NOT select uninstall, as it will remove your entire WordPress site.



  4. After removing WordPress from the list, you will be redirected back to the SimpleScripts main screen. From here, scroll through the list of applications and select WordPress.
  5. You will be redirected to the WordPress installation screen. Since you have a version of WordPress already installed, you do not need to select a URL location. Instead, select Import.



  6. You will be directed to a screen with a text field. Type your new WordPress URL in the text field, then select Import.

    NOTE: Be sure to include http:// when typing your new WordPress URL in the text field.
  7. SimpleScripts will automatically locate the configuration file for your WordPress site and will update the admin link. Once the import is complete, you will be redirected back to the SimpleScripts main page, where you can access WordPress using the admin URL.



Still Need Help? - Contact FatCow Support
Submit a
Support Ticket
Call Support
888.278.9780
Live Chat