Connecting to a db not on localhost, PHP and MYSQL 1

[solex]

Hi,

I want to connect to a db at a different address than the local host, how can i do this?
I have the log in details (username and pass etc includeing the address of the web site

http://www.tormentedflame.com).

Thanx in advance

solex (charles)

 

[sleipnir214]

That is explained in the PHP online manual page for mysql_connect()

Want the best answers? Ask the best questions!

TANSTAAFL!!

 

[Chacalinc]

In addition to sleipnir's post, you must add a user in the MySQL DB, providing user & passwd AND the host from where the user will connect..

 

[solex]

No offence sleipnir, but some people find the manual unhelpfull. So they come here for help. Just quoteing pages from the manual does not allways help.

The page shows the example of localhost, not of an address out side of it, and that was my q.

thanx

solex

 

[Chacalinc]

$handler = mysql_connect ("your_db_server", "usr","password")

solex, the command is the same, just change the server, but take care.. you must have the user, pass and host of the web server...

 

[solex]

so i would use:

mysql_connect ("

http://www.tormentedflame.com",

"[usr]","[password]")

?

thanx solex

 

[Chacalinc]

if

http://www.torm..com

get the IP, yes...

but I insist regarding the user in the Mysql db