I tried to connect to a remote mysql server ( 192.168.1.197 ) from a server with IP 192.168.1.193.

My php connect:

$host = "192.168.1.197";

$user = "root";

$pass = "rootpassword";

$database = "sample1";

#$con=@mysql_connect("$host","$user","$pass") or die('Error connecting to mysql');

$con = mysql_connect("$host", "username", "password") or die(mysql_error());

$db="$database"; @mysql_select_db($db, $con);

When i run this in the web, I'm getting the (13) error. I've search the web but could not find any concrete answer.

If i type this in the command prompt:

[root include]# mysql -u root -h 192.168.1.197 -p

Enter password:

Welcome to the MySQL monitor. Commands end with ; or \g.

Your MySQL connection id is 71

Server version: 5.0.51a Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>

I was able to connect..

Can someone help me on this one?

I even created a user rights for root ( both 193 & 197 )

User Host Password Global privileges Grant

root 192.168.1.193 Yes ALL PRIVILEGES Yes

root 192.168.1.197 Yes ALL PRIVILEGES Yes