Single User database + capabilities for multiple wordpress sites

CMS & WordPress
1

Greetings,
I have around 4 wordpress websites but each website has a different database like site1_db site2_db site3_db and site4_db.

Now the issue is that for each site a user has to create a new login so I was thinking if there is a way to integrate multiple wordpress sites to use user table from any one user table rather than a user having to enter all logins again.

I checked and find that there is a similar option if its a multi user site by using CUSTOM_USER_TABLE where in I can define the prefix of that site. But this is only possible if all sites are using the same database. But in my case I have 4 different databases (all on the same server)

So is there any plugin / code via which the same can be achieved?

Thanks a lot!

2

It wouldn’t be all that difficult to convert them to use one copy of wordpress with multisite enabled then so that the users are all shared.

3

Thanks for your response. But wont it affect performance? Like the 4 sites have around 2000~3000 records each so in all close to 12000 products via woocommerce so when each site tries to access a single database wont it create additional performance issues? Not sure so just wanted to confirm before trying something.

4

not with a tiny database like that ( now if it were a million times as many records then you might start to have performance issues.

Anyway all the mysql databases you define on a single server are effectively all the one database anyway.

5

I see. Was not aware of that. Thanks a ton! Best Wishes.

6

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.