Different hosting servers but same backend

amaxe

Hi all,

I would like to know whether it is possible to use a single database backend, which
would be wired to different web sites present at different servers in different part of world. I am at a situation to build an application which would be uploaded into
different sites and act as a part of the site, but need to collect data from all these
sites into same database table. Is this possible ? .Thanks in advance. 🙂

bradgrafelman

If your host allows it, you can allow access to your database from remote hosts.

amaxe

Thank you very much dude.but, could you please tell me how to configure the server for allowing connections from different sites to our database.

jkurrle

You can allow access one way from within MySQL, via the GRANT statement. You can specify a specific user, from a specific IP address, identified by a specific password, and what specific rights/capabilities you want them to have.

If you are doing this, I'd recommend that you secure a SSH connection between your servers first, so that the data stream is encrypted...