hi,
i have a small problem, i'll explain you with you an example.
We are doing a project on hospital Management systems.
so we will set up branches in different locations of INDIA.
if patient information is located in some location and he is accessing his information from different location,
i need to connect to his database (MySql) and retrieve his information and display to him.
So i'm unable to connect to mysql server.
here is my code
<?php
$db=mysql_connect("192.1.8.12:3306","root","");
mysql_select_db("auto",$db);
$qrystr = "select * from topfive";
$result = mysql_query($qrystr,$db);
if ($row=mysql_fetch_array($result))
{
do
{
$dept_name = $row["filename"];
}while($row=mysql_fetch_array($result));
}
echo $dept_name;
?>
here 192.1.8.12 is a remote system ip address
my operating system is :- linux
when i'm connecting from one linux system (ip address is 192.1.8.45) and my program is in 192.1.8.45 and in that program i'm giving the remote linux system (ip address is 192.1.8.12) when i do that it's giving an error message as
Warning: MySQL Connection Failed: Host '192.1.8.45' is not allowed to connect to this MySQL server in /home/httpd/html/test.php3 on line 2
Warning: 0 is not a MySQL link index in /home/httpd/html/test.php3 on line 3
Warning: 0 is not a MySQL link index in /home/httpd/html/test.php3 on line 5
Warning: 0 is not a MySQL result index in /home/httpd/html/test.php3 on line 6
can you please help me in this matter.
eagerly waiting for your reply
thanks in advance
bye
arvind
