connecting the remote database server!

[rameshfaj]

How can i connect to the remote database server using PHP code,assuming that the remote server has default Mysql configuration.I have done like this:

 

<?php

mysql_connect("IP:PORT","username","password");

//where the paramters are only format not real values

?>

 

The error is like this:

 

Couldnot connect to the database....

[timmah1]

Not sure if I'm right, but did you try taking the PORT out?

 

I just remember reading somewhere that not all require the PORT

[revraz]

You need to specify the database as well.

 

mysql_select_db("databasename");

[trq]

It simply won't work with the default mysql configuration. You need to allow your username to connect from a specified remote ip address/domain name, or if you really like living on the edge you can enable a connection from any ip/domain.

 

mysql> GRANT ALL PRIVILEGES ON *.* TO 'yourname'@'your.ip.goes.here' IDENTIFIED BY 'yourpass' WITH GRANT OPTION;

[roshanbh]

to connect to the remote server you must have the permission from remote server. Please check the permission as well.

 

http://roshanbh.com.np