Whats the best way to share user data across multiple WordPress websites?

by

First of all, Multisite isn’t what I’m looking for. I have 5 websites using WordPress all on separate domains that I would like to enable user accounts for. I need user data to be shared across the entire network and when a user creates an account, they would have instant access to all other websites as well. What I’m trying to do isn’t recommended by WordPress when using Multisite:

If you plan on creating sites that are strongly interconnected, that share data, or share users, then a multisite network might not be the best solution.
-http://codex.wordpress.org/Before_You_Create_A_Network (1st paragraph, 3rd sentence)

I’ve tried using the “shared user table trick” as mentioned here http://wordpress.org/support/topic/multiple-sites-same-users-how and here http://xentek.net/articles/528/implementing-the-wordpress-shared-users-table-trick/ and a number of other places…the problem is that this information is 2-7 years old and I’m using WordPress 3.5.1 and this “trick” doesn’t seem to work.

I’ve attempted to insert this code into wp-config around the $table_prefix line.

define('CUSTOM_USER_TABLE', 'wp_users');
define('CUSTOM_USER_META_TABLE', 'wp_usermeta');

Long story short, I don’t think this trick works any more as I am unable to log in to the second site on the admin side at all.

Any suggestions on what the best way to link this data would be?

3 s
3

Ok, first of all, I feel like an idiot, although in my defense most of the articles that talk about this don’t mention a very crucial detail in making this work. The answer is that you need to set permission for at least one admin in the database. This info can be found in the Codex here: http://codex.wordpress.org/Editing_wp-config.php#Custom_User_and_Usermeta_Tables

After you set up the wp-config.php file, it’s imperative that you make a change to the master usermeta table (in my case wp_usermeta) field wp_capabilities row, and meta_value column. Do this via phpMyAdmin.

Note: Do this for at least one user admin to log in. You can adjust all other users/admin roles from the backend once you get in.

Screenshot of what users permissions will be changed

For each website that is created, it needs to have that new sites prefix assigned the admin user role.

In my case since I’ve only got this working on 2 sites at the moment it looks like this:

a:1:{s:13:"administrator";s:1:"1";}
tbs_capabilities = a:1:{s:13:"administrator";s:1:"1";}

Screenshot of wp_usermeta value

The first line sets permissions for the default table prefix (in this case wp_), and the second line sets the permissions for the second website (in this case with the tbs_ prefix).

Thanks to brasofilo for the comment that pointed me to dig a little further to finally solve my issue!

I hope that this answer can help other who were having the same issue I was.

Leave a Comment