You hosting server should provide you with the ip address and password of your hosted database.
so, if your local connections file, connectionname.php looks something like this...
<?php
# FileName="Connection_php_mysql.htm"
# Type="MYSQL"
# HTTP="true"
$hostname_connectionname = "localhost";
$database_connectionname = "NAME";
$username_connectionname = "root";
$password_connectionname = "PASSWORD";
$connectionname = mysql_pconnect($hostname_connectionname, $username_connectionname, $password_connectionname) or trigger_error(mysql_error(),E_USER_ERROR);
?>
create a duplicate file called (for example) connectionname_live.php and put the correct info in.
<?php
# FileName="Connection_php_mysql.htm"
# Type="MYSQL"
# HTTP="true"
$hostname_connectionname = "0.0.0.0";
$database_connectionname = "databasename";
$username_connectionname = "connectionname";
$password_connectionname = "password";
$connectionname = mysql_pconnect($hostname_connectionname , $username_connectionname , $password_connectionname ) or trigger_error(mysql_error(),E_USER_ERROR);
?>
publish this file to the remote, hosting server, than rename it