Duplicating user credentials in multiple single sites

  • Resolved uschesch

    (@uschesch)


    8 years, 2 months ago

    I have four standalone WordPress sites. I am importing the same users into each site, and they all have the same password. I have email turned off in all but one site, so that when users get a message indicating that they have credentials, the message will only come from one site. My problem is, when users get that message, they are instructed to change their password. However, the password will not change in the other sites, and consequently the login to the other sites won’t work. Does anyone have a potential solution for this?

    Thank you.

Viewing 6 replies - 1 through 6 (of 6 total)

  • Hello,

    You could share your user table between the sites. Have a look at the article Sharing user tables between two WordPress installs and see if that is what you had in mind.

    Cheers,

    Rob

    Thread Starter uschesch

    (@uschesch)

    Thanks Rob. This looked promising until I got to the statement that the sites must share the same database. Each of our sites has its own database. ??

    It shouldn’t be a problem if you were to merge the tables of the different databases into one database. Each site’s tables would be prefixed with a unique prefix (you can have multiple installations in one database if you give each a unique prefix (use only numbers, letters, and underscores)) and each site’s wp-config.php file would define that prefix.

    You would need to do a little work exporting the tables and modifying their prefixes if they’re not already unique but once you’ve done that and imported them into one database, the instructions in the link I shared earlier should help you get shared users working.

    As always, please make sure you have a working backup of your site before you start hacking away at the database etc.

    I haven’t tried this myself but it should work.

    Cheers,

    Rob

    This might be useful if you need to change the table prefixes: How to Change the WordPress Database Prefix to Improve Security

    Thread Starter uschesch

    (@uschesch)

    Thanks for the feedback. We ended up using the wp-oauth-server and single sign on plugins along with our own service for downloading users.

    Glad to hear you’ve come right. Thanks for posting.

    Cheers,

    Rob

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘Duplicating user credentials in multiple single sites’ is closed to new replies.