Wordpress not working with Temporary URL

There are a few cases where you might need to go in and change a URL in the WordPress database.

  • My domain name isn't resolving to my new account yet, so I have to visit my WordPress install with a URL like http://70.103.189.86/~username/blog/. I don't get any images or themes to show up, just the text.
  • I also can't log into my Administrator Panel, because logging in wants to take me to a URL with my domain name in it. How can I change my settings to allow me to view my WordPress blog before my domain name resolves?
  • The URL appears like http://www.domain.com/addondomain/ and there are no redirects in the .htaccess
  • If WordPress was installed to an addon domain, then the database URL will need to be changed to something like http://www.addondomain.com

This requires a little MySQL trick. It's two simple edits in the database.

1. First, make sure that your WordPress installation is complete, and you know what the name of the database is. If Fantastico installed WordPress for you, it's likely the name of the database is something like:

  • username_wrdp1

or

  • username_wrdp2

and so forth.

If Simple Scripts installed WordPress for you, it's likely the name of the database is something like:

  • username_ss4868

2. If you don't know the database name, you can use the File Manager to look inside the wp-config.php file to find out its name.

3. Right click wp-config.php and select Code Edit. You can now see the database name.


4. Next, log into your cPanel. Look for the Databases section.

5. Select the icon named phpMyAdmin (looks like a sailboat.)

6. Once here, you need to select the database name on the left. (i.e. "_wrdp1")

7. This will display the names of the Tables to the right. Click on the one called "options".

8. Now there are icons to the right of the tables. The First one is called "Browse". Click "Browse".

9. Next, the database entries are listed in columns and rows. You want to select the pencil icon (for Edit) on the left for the VERY TOP row (option_name is "site url")

10. Once you've clicked the pencil icon, you will see your domain name listed something like this:

  • http://domain.com/blog

11. You want to change that to something like this:

  • http://70.103.189.86/~username/blog/

12. This step is crucial you don't make a mistake. Please take a moment to verify the URL you are typing in here is correct, or you won't see any change.

13. Once you've changed the URL, down at the bottom there is a "Go" button. Select the "Go" button.

14. This will save your URL change and should show a screen like this:

  1. Select the ">" button to go to the next page
  2. Look for the option_name home

15. Select the pencil icon for Edit.

16. Make the same URL change here as you did for siteurl earlier. And click the "Go" button.

17. Visit your Temporary URL (http://70.103.189.86/~username/blog/) for your blog, and all the images will show up just fine.

***Follow-up

  • Once you've changed your name servers so your domain name resolves to your account, you don't have to go back into phpMyAdmin to make the change again.
  • Simply log into your WordPress Admin Panel, there is a tab for "Options".
    In there you will see WordPress address (URI):
    It is set to your Temporary URL (http://70.103.189.86/~username/blog/). Change this to your domain name with any folders required, and you're back to normal.

Was this answer helpful?

 Print this Article

Also Read

How to host the Primary Domain from a subfolder (.htaccess)

The main domain on the hosting account uses the public_html directory for all of its Web site...

FTP Setup using Dreamweaver MX

Configuring FTP for Dreamweaver (Version MX) Open DreamWeaver MX. Click on Site and...

IonCube installation

Ioncube is already installed on all of our servers. Before your scripts may use Ioncube, you will...

cPanel Login from the Customer Centre

To login to cPanel directly from the Customer Centre do the following: Login to your Customer...

How to change primary domain

Changing the primary domain of your account is something we would be happy to help with. Before...