Hi,
Can somebody show me how can i grant a mysql permission to a remote host?
Let say I want to let a RemoteServerA access to my DB, how can I grant the user?
I do add in the user record in mysql DB - 'user' and 'db' for the username and password(via phpMyAdmin). and then flush the privileges.
But somehow, I sitll can't connect it from the RemoteServerA to my DB.
condition : currently my RemoteServerA is act as virtual domain at a Host.
This is my code:
<?
$Conn = mysql_connect("207.277.21.20", "site", "password");
if (!$Conn) echo "FAILES";
else "YES";
mysql_select_db("turflive");
$strSQL = "SELECT * FROM tblMembership";
$result = mysql_query ($strSQL);
if ($row = mysql_fetch_array($result)) {
echo $row['id'];
}
?>
But, it return me this error:
Warning: Can't connect to MySQL server on '207.277.21.20' (110) in /usr/local/apache/htdocs/test1.php on line 2
Warning: MySQL Connection Failed: Can't connect to MySQL server on '207.277.21.20' (110) in /usr/local/apache/htdocs/test1.php on line 2
FAILES
why there is a (110) there?? Is there anything do with server port permission or access?
Thanks
Louis
