Connecting to mysql server through ip

[Anon]

Hi,

I got a problem when i am connecting to mysql server through ip address it's showing some errors.

here is my code

<?php
$db=mysql_connect("http://192.1.8.45:3306/","root","");
mysql_select_db("departments",$db);
$qrystr = "select * from Dept_Details";
$result = mysql_query($qrystr,$db);
while($row=mysql_fetch_array($result))
{
$dept_name = $row["Dept_name"];

}
echo $dept_name;
?>

Here are error messages

Warning: MySQL Connection Failed: Unknown MySQL Server Host 'http' (111) in /home/httpd/html/nims/departments/test.php3 on line 3

Warning: 0 is not a MySQL link index in /home/httpd/html/nims/departments/test.php3 on line 4

Warning: 0 is not a MySQL link index in /home/httpd/html/nims/departments/test.php3 on line 6

Warning: 0 is not a MySQL result index in /home/httpd/html/nims/departments/test.php3 on line 7

So, Please help me

Thanks in advance

Bye
Arvind

[Anon]

Hi
Your problem is with the connec statement. You do not construct HTTP URL to connect to a remote ip address. Your connect should look like below:

mysql_connect("192.1.8.45:3306","root","");