Accessing remote database with php

[chazzy69]

Hi, iv made a php script which searches and retrieve rows from a database on server A, What i want to do now is to be able to access the same database on another server (server B), the reason for this is that multiple websites will have to be able to access the database which are all on different servers.


Thanks for any information,

[Atli]

What's the problem?

All you should have to do is change the host address accordingly.

[Markus]

What's the problem?

All you should have to do is change the host address accordingly.

Well, considering the database doesn't change (If I'm not mistaken), you should just mysql_connect().

Cheers,

Mark.

[chazzy69]

Ok i tried just the connecting it didn't work i got an error saying could not connect, couldn't find the address.

I fiddled a bit with the address trying to change it but it didn't seem to work.

for example the origional server name i used looked something like this

mysql.myservername.net (not really this)

this works locally but not on a remote server,

next i tried using the ip address that was associated witht he name for example

10.255.255.255 (not really this)

And neither option seemed to allow me to connect remotely,

Any suggestions???


Thanks for the help

[Atli]

Are you sure the host allows remote connections?
You will need to connect as a user that has been given remote access.

It's also possible that the server's firewall blocks the port MySQL uses. (usually 3306)

[chazzy69]

That could be the case i will have to check if i can allow remote connections to the server.