Access database on another server?

[siddscool19]

How to access database on another server?

What codings should i use?

[trq]

Pass the host to the host argument of mysql_connect().

[genericnumber1]

just use their host/username/password in your mysql_connect() statement. if they have it firewalled where you can only connect internally, you really can't.

[siddscool19]

I own it myself just the thing is that i want to access my database from another site

[genericnumber1]

then, as we've said, use the host address in your mysql_connect().

[siddscool19]

for example

my database name is hi_name

Username is  hi_user

Pass is hipass

 

Then how to access database if my database is on http://hii.com

 

I mean can u explain me by this example?

 

 

[trq]

mysql_connect('http://hii.com','hi_user','hipass');

 

You'll also need to make sure mysql allows you to connect from your remote domain. eg;

 

GRANT ALL PRIVILEGES ON *.* TO 'hi_name'@'DOMAIN_YOUR_CONNECTING_FROM' IDENTIFIED BY 'hipass' WITH GRANT OPTION;