You should always use mysql.hosting-advantage.com as the database server

Sample Connection (PHP):
//set local variables
$dbhost = "mysql.hosting-advantage.com";
$dbuser = "user";
$dbpass = "pass";
$dbname = "database name";

$db = mysql_pconnect($dbhost,$dbuser,$dbpass);
mysql_select_db("$dbname",$db);

Sample Query:
mysql_query("SELECT * from table_name",$db);