Hi all,
i have a small lan in my office with 3 systems connected. Each system has it's own mysql database. But i want to access database tables in other system.
I have the following simple php code to access mysql database that resides in my other system that connected to lan.
CODE
mysql_connect("192.168.0.7","root","password") or die(mysql_error());
mysql_select_db("test") or die(mysql_error());
$query="show tables";
$result=mysql_query($query);
while($row=mysql_fetch_assoc($result))
{
print $row['tables_in_test'];
print "<br>";
}
but i'm getting following error
CODE
Warning: mysql_connect() [function.mysql-connect]: Can't connect to MySQL server on '192.168.0.7' (10060) in C:\Inetpub\wwwroot\filewar\first.php on line 150
Can't connect to MySQL server on '192.168.0.7' (10060)PHP Warning: mysql_connect() [function.mysql-connect]: Can't connect to MySQL server on '192.168.0.7' (10060) in C:\Inetpub\wwwroot\filewar\first.php on line 150
i don't know y i'm getting this error can any one help me out this
This post has been edited by kummu4help: 31 Aug, 2008 - 10:17 PM
| 