newby question !

I need to access my database from another server.
When i was connecting from my server i used

$hostname="localhost";
$username="user";
$password="pass";

MYSQL_CONNECT($hostname, $username, $password) OR DIE( "Unable to connect to database");

But what $hostname do i use from the other server ?! the IP address or what !?

thanks

Hi,

you can use both the ip address or the hostname of the mysql server.

Examples:

mysql_connect("mysql.something.com",$user,$pass)

mysql_connect("mysql",$user,$pass)

mysql_connect("192.168.12.10",$user,$pass)

Make sure that the client host has the rights to access the mysql server.