Take the 2-minute tour ×
WordPress Development Stack Exchange is a question and answer site for WordPress developers and administrators. It's 100% free, no registration required.

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?

share|improve this question
1  
I don't get why CUSTOM_USER_TABLE wouldn't work... See if there's something here: wordpress.stackexchange.com/search?q=CUSTOM_USER_TABLE –  brasofilo Feb 12 '13 at 0:13
    
When I use CUSTOM_USER_TABLE users do get shared between website, however, on the second website, I cannot log in as an admin whatsoever. Searching around for hours and finding plugins and articles that are 2-7 years old lead me to believe that this trick no longer works in 3.5.1... –  Ian Feb 12 '13 at 6:40
    
The question is that this is not a trick, it's a core feature. Seems that no bug has been reported, and nothing relevant shows up in [wp-hackers] list... –  brasofilo Feb 12 '13 at 6:50
    
Thanks for your comments. I was able to find the answer by taking a deeper look into some things that I saw in your links. I've posted my solution below. Thanks again @brasofilo –  Ian Feb 12 '13 at 7:24
    
Really great you almost covered all the ways on how to share the users. but ive a little different situation here. Ive 5 wordpress website that each particular website has its own db. How can i use your solution to connect all separate user tables in a way when a new user registers on any of 5 websites, he could immediately login to any of other websites using a single registration ? Im aware of some way to accomplish this in a single database using the WPMU but im not really finding any way to do it on seperate installations of wordpress. Will appriciate any help. Thank you –  user47152 Feb 4 at 19:32
add comment

1 Answer

up vote 3 down vote accepted

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 crutial 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.

share|improve this answer
    
Never used this feature, but glad to know that there is this little trick to make it work ;) Nice write-up +1 –  brasofilo Feb 12 '13 at 7:30
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.