I have two databases (identical, but serving two different purposes) that I want to share the sign up and log in. Right now they have separate sign ups and log ins. How do I connect just the sign up and log in part without sharing the rest of it?
Well, the easiest way would be to just make it into one database (copy the tables from one into the other) and separate them with prefixes if the names of the tables are the same. You'd need some tweaking of the code for accessing the different information of course, but that should be trivial
Oh, I see. Will give it a try tonight. Will let you know how it went. Added later: My hat's off to you. Just did it and it's working perfectly.
Bear in mind if the reason you might want two is in case on fails.. if this database fails you're out both.
My hat's off to you. Just did it an it's working perfectly. Thank you for the reminder. I backup my databases regularly and save them to an external hard drive.
As I understood it, this was separate databases with a joint login (or at least a provision for that) - say two different Wordpress schemes, with the same information in the user-tables. Combining them into one larger database, sharing the user-tables, are trivial, and doesn't do anything to limit security compared to having them in separate databases. However, the point you bring up is a good one, and one should always make sure that data-integrity and backups are current and up-to-date.