I have a website all set up and working using MySQL.
My client now want the website hosted on their own servers. However it's a bit of a game to get database's set up there so I want to keep the database on my server but move the website files to his server.
Until now I have only ever connected a website with a database on the same server using the Dreamweaver created connection script like this...
$hostname_iafl = "localhost";
$database_iafl = "database";
$username_iafl = "username";
$password_iafl = "password";
$iafl = mysql_pconnect($hostname_iafl, $username_iafl, $password_iafl) or trigger_error(mysql_error(),E_USER_ERROR);
How would I edit this to link to another server? I have tried changing 'localhost' to the ip address but that didn't work?