PDA

View Full Version : same users in two sql databases


nonner
10-23-03, 05:20 PM
Can anyone tell me if htere is code or a utility that can replicate database users so a user can lo gin to one database and automatically be a user in another on a different server?

I have to sites with diff databases and I want them to only have to log in to one to access both sites.

Atomic-Design
10-23-03, 05:53 PM
You can just have both sites use the same database and table. Just make them both connect to the same database and grab the query from the same table.

nonner
10-24-03, 12:41 AM
This sounds interesting.

Hi have two nuke sites of different versions.

Each would need their own database and tables except that one site user database would need to connect and use a user table on another server.

I would somehow have to make one nuke site connect to two databases. This would be a challenge for me but if I can confirm this is possible, I would be glad to attempt it.

Do you think this is possible? Any suggestions on how to do this would be welcome.

HalfaBee
10-24-03, 12:50 AM
You could always copy the user tables across.
Maybe a hack into the registration section could update both DB's at the same time.

HalfaBee

ibejohn
10-24-03, 12:56 AM
http://www.mysql.com/doc/en/Replication.html