Problem with WordPress 1 click install pre DNS change

wordpress

#1

Hello,

I’m building a new site on a fresh VPS. I’ve set up the domain print-2-media.com on the VPS but don’t want to propogate the actual domain name until I’ve built the development site (obviously).

I’ve mirrored the domain at print-2-media.dreamhosters.com.

I’ve setup a mysql hostname at mysql.print-2-media.dreamhosters.com.

I’ve used the WordPress 1 click install to install WordPress on print-2-media.com.

It says the install was successful, but when I visit print-2-media.dreamhosters.com/wp-admin/install.php I get “Error establishing a database connection […] can’t contact the database server at mysql.print-2-media.com”.

I can get into PHPMyAdmin at:

http://www.print-2-media.dreamhosters.com/dh_phpmyadmin/mysql.print-2-media.dreamhosters.com

and there is a print_2_media_com database (the database that was automatically generated by the 1 click install), but it contains no tables.

Anyone know what else I need to do to get the database connection recognised and finish the WordPress install?

Cheers,

Dave


#2

use ftp/sftp and check the file wp-config.php it should be in the top level of whatever folder you installed wordpress in, the db hostname is at ~line 28


#3

/** MySQL hostname */
define(‘DB_HOST’, ‘mysql.print-2-media.com’);


#4

update that to ‘mysql.print-2-media.dreamhosters.com


#5

Would that still work once DNS has propogated? I’m guessing it would, as long as I didn’t remove the dreamhosters.com domain, but it seems a little flaky.

If I do change it back to mysql.print-2-media.com after DNS propogation, will it still be pointing to the same database? So I won’t lose anything added during development?

Cheers for the help.

-Dave


#6

Yes, you can change it back after the DNS change. In most cases, all the databases for your account are on one database server and all of the hostnames are interchangeable. (the exception being some older customers that might have more than one database sever.)


#7

Thanks for the info LakeRat. 'Tis working a treat now. Much appreciated.