Connect to remote mysql server

scialom

I try to connect from remote website to mysql db server.

On my db server I created a new user with the ip of the remote user, but no mater what I do, I can't connect.

Any ideas?

Assaf

cassius

Post your code so that the boardmembers can have a look at it and find a solution that works.

scialom

$dbcnx = mysql_connect("serverip:3306","username","password");
if (! @mysql_select_db("mydb") ) {
echo( "<P>Unable to locate the DB " .
"at this time.</P>" );
exit();
}

Thanks,
Assaf

cassius

This works fine for me:

<?php
$uplink = mysql_pconnect("ip.number.to.server:3306", "username", "password")
or die("Error: " . mysql_error());

mysql_selectdb("svs")
or die("Error: " . mysql_error());
?>