Query MySql Database from Another Server

[transfield]

Hello,
I have a html form which I'm using to query my MySql database. At present, both the form & the database reside on my server. Everything is working fine.

I now want to place the same html form on another server(belonging to my customer) & allow them to query my database(which will remain on my server under my control). This arrangement will be exclusively provided for a selected group of customers only.

What do I need to learn / read / know in order to make this arrangement work? Could you provide me some keywords to Google / Yahoo or point me to some sites that provide some tutorials / information on this matter?

Thanks a lot :-)

[Drakla]

mysql access hosts

mysql grants

[NogDog]

I believe there may be some server settings required to allow access from remote hosts. This is typically over a specific port, so your mysql_connect() would require a port number at the end of the host, e.g.:

mysql_connect("hostname.com:123", $dbUser, $dbPwd);

You'll need to find out from the database host's administrator what port to use (assuming they've even set it up to allow remote connections).

[transfield]

Thank you Drakla & NogDog for your replies. I am now doing some reading on Yahoo / Google based on your advice.

I appreciate your guidance on this matter.