Page 1 of 1

connecting to offsite databases

Posted: Wed Feb 16, 2005 4:53 pm
by thegreatone2176
i searched the forums and didnt find a thread about this even though im sure there would be one

someone asked me if i could do this for them:

he runs two sites that are membership required and hes getting a third site and he wants when people register on one to be registered on all three...

first off i know that if more than one mysql server runs off localhost then i dont think it would be possible, but if only one did then users could register from the site containing that one.

so if none or one of them runs on localhost could i connect to the database of site A from site B?

I dont see why not but since i dont have his ftp+sql details yet i cant test and i dont have multiple sites of my own to test

Posted: Wed Feb 16, 2005 4:57 pm
by feyd
it's possible in the connect function of the database architecture you use. However, most hosts disallow access from outside localhost to the database. So you will very likely need a script on the all the servers for each of them to access each other, to perform selections, insertions and updates. I'd strongly suggest using strong encryption to pass information.

Posted: Thu Feb 17, 2005 2:15 am
by patrikG
Please post in the appropriate forum. Your question is about databases, we have a forum called "Databases". Coincidence? I think not. :wink: