mysql_connect problem

Anon

Hi,
can any one give me source code to connect to mysql server through ipaddress which is located at a remote location.

i tried to connect in this way
mysql_coonect("192.1.8.45","root")
but it's giving me an error message.

So please help me in this matter

Thanks in advance.
Arvind

Anon

I don't know if you copied and pasted that from your code, but you spelled "connect" incorrectly, and you forgot a ; semicolon at the end.

Anon

Hi,
can any one give me source code to connect to mysql server through ipaddress which is located at a remote location.

i tried to connect in this way
$db=mysql_connect("http://192.1.8.45/","root");
but it's giving me an error message saying
"Host 192.1.8.45 is not allowed to connect to this mysql server".

So please help me in this matter

Thanks in advance.
Arvind

Anon

a)Well the problem seems to be a syntax problem
coonect!= connect

AND

b)when you say "root" that only works in cases where the IP is "localhost" otherwise you cant connect to a Unix server remotely by simply saying "root". The remote IP suggests a remote MySQL server. Talk to your Admin, or the Admin of your Hosting Company (in the event that the MySQL dbase you need to connect to is a website dbase), ask for the MySQL server URL

it may be say MySQLX.yourdomain.com

that way your syntax becomes
mysql_connect("MySQLX.yourdomain.com","Username","password");
note: password is admin password

NB: I connect with mine via PHP scripts

Good luck!