|
My Domain name isn't resolving to my new UCwebhost.com account yet, so I have to visit my Word Press install with a url like http://67.19.144.178/~username/wordpress/
. 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 Word Press Blog before my domain name resolves?
This requires a little MySQL trick. It's one simple edit in the database.
First, make sure that your Word Press 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.
Next, log into your cPanel. Select the function "MySQL Databases". Down
at the bottom, there is a link to phpMyAdmin (looks like a sailboat.)
Once here, you need to select your database name from the drop down box on the left. (ie "_wrdp1")
This will display the names of the Tables underneath the dropdown box. Click on the one called "wp_options".
Now there is a list of tabs at the top of the page to the right of the
drop down box. The First one is called "Browse". Click there.
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")
Once you've clicked the Pencil Icon, you will see your domain name listed something like this:
http://ineedtotest.com
You want to change that to something like this:
http://67.19.144.178/~username/wordpress/
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.
Once you've changed the url, down at the bottom there is a Dropdown Box
that says "Save". If it does not say Save, change it to Save, then
select the "Go" button. After you hit "Go", you're done. Visit your
temporary URL 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 Bluehost.com account, you don't have to go back into phpMyAdmin to
make the change again. Simply log into your Admin Panel, there is a tab
for "Options". In there you will see:
WordPress address (URI):
Is set to your temporary url. Change this to your domain name with any folders required, and you're back to normal.
|
 Add to Favourites
 Print this Article
|
