connecting to external php database

[NancyJ]

I'm moving my site from one server to another and eventually I will be rebuilding the site with a new DB etc but for now I just want to access my mySql database from a different domain and server - is this possible?

[dmmh]

Yes it possible

$ip = '222.333.666.44';
$user = 'mysql_user';
$pass = 'password';
@mysql_connect($ip, $user, $pass);

if you get an message you cannot connect, uncomment "skip-networking" in my.cnf (mysql)

[NancyJ]

how do I find out my IP? heh I have the IP for my new server but I dont think I ever got one for the old one....

[jatar_k]

the hostname works as well

[dreamcatcher]

I think it depends on the server and if they block access or not. Some servers (like mine) require you to have a static IP address for you to make an external connection to their databases.

Just a thought.

[NancyJ]

dug out my old welcome email and it did have the IP in, its working great! Thanks :)

[dmmh]

welcome :)