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

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.

Related Posts:

  1. How to get user ID during registration and add it to a custom table
  2. How to allow an user role to create a new user under a role which lower than his level only?
  3. Display user registration date
  4. WordPress auto login after registration not working
  5. What the user_status column?
  6. Problem with Hebrew characters in username
  7. Remove email verification when new user register
  8. How to set up User email verification after Signup?
  9. How to let user set password on registration
  10. How to display custom user meta from registration in backend?
  11. Multi-steps WordPress registration : in 4 steps how to?
  12. Force users to complete their profile after they register? How to
  13. How do i auto approve new user?
  14. Copy a user from one WordPress site to another
  15. Can I hook into the invite user process to verify their email address is from a certain domain?
  16. Get user info outside WordPress
  17. Limit content by user registration date
  18. What is the best way to avoid spammers registering to my blog?
  19. ACF Upload Image in front-end with custom form
  20. How to customize wp_signon()
  21. How Do I Prevent Junk Account Creation?
  22. Can I bulk register contributors for a new blog
  23. New user notification doesn’t include activation link
  24. WordPress to use Drupal users’ credentials
  25. Create not-activated user in code, wordpress
  26. Front End Registration Form Code – Password Field Not Saving
  27. How can I verify users facebook ID that he provides during signup process
  28. Plugin for limiting user registration based on ip with expiry period?
  29. Restricted registrations or removing the ability to edit your password/email
  30. Creating user in Firebase after WordPress user registration
  31. Can user login details be used for other applications?
  32. Users managed to register on website with no register button?
  33. Add value in user table when user is created
  34. Displaying different in-page content to cliente/admin
  35. Should I encrypt the response that triggers an Ajax action? Is nonce sufficient?
  36. User Meta Data in a Sortable Table
  37. Can i add password field into my wp registration form?
  38. wordpress disable login for unverified user
  39. How can I attach a user to another user with user meta
  40. Register user when after filling contact form
  41. Creating user without username and password
  42. WordPress registration without wp-login.php and wp-admin folder, is it possible?
  43. Check for valid email after user inactivity?
  44. How to set custom avatar for users?
  45. Assign random (and unique) user meta upon registration
  46. How to add registration date and last login date to user list page
  47. What is correct way to change user’s email?
  48. Send clear password via mail
  49. Querying specific table row by current user login
  50. How to programmatically read the plan text password when user register?
  51. Custom registration and pending approval
  52. Automatic Website user password generation
  53. Customising “user ids” and add to ‘user’ panel in the admin area
  54. How to hide some users to unlogged users [closed]
  55. Unique password to access a section site
  56. Make new users automatically approved
  57. Use members from 1 site on another one
  58. Adding more fields to the add user page on dashboard
  59. Edit text of WordPress “Register” button
  60. User with same Mail but a different additional info(like domain)
  61. set automatically email address for WordPress users
  62. WordPress 5.8 – Hide or Remove personal fields from admin Profile page
  63. Can I add a unique code for each user based on the location?
  64. Perform multiple actions after wp_insert_user()
  65. Send user auto generated password on different email
  66. How can i display pagination in custom comment list?
  67. Safely changing UserID’s, re-using deleted UserID’s and automatically using deleted userID’s instead of an increment
  68. Single Sign On (SSO) between two WordPress websites
  69. Auto approve new users if their username is included in a predefined list
  70. Disable emails for new user registration
  71. Insert user register into my own user table instead of wp own user
  72. What is the best user experience for user to perform an action using email?
  73. Custom registration fields not appearing in user info
  74. How to restrict Admin from creating new users from Add new user screen in dashboard to only of one domain?
  75. Registration page as homepage
  76. New User ID not working in custom function with user_register hook
  77. Set user role on registration so can upload file to own media library area
  78. Disallow user registration/checkout via Hotmail/Yahoo
  79. Retrieve New user’s ID
  80. Let admin users edit member profiles from front end
  81. view and update form only for registered users
  82. Integrating Facebook Registration (and Login) on a WordPress page
  83. New User Registration email
  84. how can i inform other users about new user registration? [closed]
  85. Add custom input field in new user page
  86. MySQL query to list users who never signed in
  87. Wordpres password as plain text in email
  88. WordPress password as plain text in email
  89. how to use joomla password format in wordpress?
  90. How to do get_users() with multiple meta_keys
  91. wp-admin: Sort users by surname
  92. Prevent Admin user to edit/see super admin from users list
  93. Remove user profile field [duplicate]
  94. Does an AJAX call on the Admin Side Automatically include the User Data/Capabilities?
  95. Allow WooCommerce existing customers to checkout without being logged in [closed]
  96. How to allow access based on the user meta flag
  97. Return all users that have one or more published blog posts
  98. Change “logged in as a ” link in comments form
  99. force registered user as seller
  100. Not able to call value in the core files

Leave a Comment