About connect to other MySQL DB!

[malishew]

Hi, sorry about my bad english!

I have a question, how can i alow mySQL to accept other IP connections?
Example:
I am trying to get game statuss connecting to other mySQL DB

$host="80.233.140.100";
$user="OthePCUser" ;
$password="OthePCUsersPass";
$db="OthePCUserDatabase";
$database_encoding = 'CP1251';
$img_base = "img/";
$server = "OthePCUserServer";

But i get error:
Error: Unable to connect to MySQL server. MySQL reported: Can't connect to MySQL server on '80.233.140.100' (10060).

Mby i have to change something in php.ini
Thanks!

[developer_nc]

According to the error it looks like you are using the wrong IP Address or the wrong port. Make sure the IP Address is correct and if that dont work try to specify and force connection with the default port 3306. Not sure , but you may have to open another port to support the other connection.

PHP Code:

$link = mysql_connect("$host:3306", "mysql_user", "mysql_password");
if (!$link) {
    die('Could not connect: ' . mysql_error());
}
echo 'Connected successfully';
mysql_close($link); 


[Xnuiem]

The MySQL database you are attempting to connect to, may not allow remote connections. Make sure the user you are attempting to connect as, has a host entry for your host. Or just use a wildcard if you are not worried about security,

[graetz]

How to allow remote connections?