Connect to external mysql host

[sandhuaman80]

Hello Everybody,
I have to connect to external mysql databse so that that i can import tables from that database. When i giving IP Address then this error displayed:
mysql_connect(): Lost connection to MySQL server during query in /home/pgcc/public_html/pgcc_tmn/modules/utility/index.php on line 9
Lost connection to MySQL server during query

and the code for above is :

// $server=trim($REQUEST['server_name']); // Commented
// $database=trim($REQUEST['database_name']); // commented
$username=trim($REQUEST['username']);
$password=trim($REQUEST['password']);
$connection = mysql_pconnect("67.15.80.3:2082",$username,$password) or die(mysql_error());

i have read rom somewhere that you need permission to connect to that site from hosting company. I have cpanel access to my mysql databse. How can i change permission or would i have to send separate email to hosting company to allow remote connections .

Thanks

[bretticus]

Are you sure that the database ip is directly accessible. I doubt a hosting company (Everyones Internet, Inc.) would allow a direct outside connection to their database (however, it is on a different port...that you've advertised to all :evilgrin: . This error can happen when the MySQL server simply times out. I would contact Everyones Internet and see if that's even possible.