Need help organizing multiple sites with a common account table

Databases
1

Hello guys,

I have a situation where I have 2 sites that are somewhat related. I was hoping to organize these sites as sub-domains within a parent domain and registration would create a “global” account for both.

The problem i’m having is how this user and account table should handled since site1 and site2 each has it’s own database.

Or do I just forget about this and keep two separate accounts/users table?

Any help is greatly appreciated since i’m at a total loss as to how to make this work :frowning:
Thanks!

2

you can have one user accounts table for both sites, but you should have suserSites table where you will manage who was access on which site

3

Are the two sites different web apps, for example a forum and a blog?

4

it is not a problem as long as you have access to database server from both sites