Shared Members between two different wordpress installations with different databases

I had to do something similar. What you need to do first is in each of your config files define the table prefix … make sure that they are different.

Example: WordPress installation 1: wp123_ WordPress installation 2: wp124_

Your first installation would be your main installation the one with the user table you want to use. Then in the second installation’s config file you need to add this in it:

//Adding so that this blog uses the same user tables as the main

define('CUSTOM_USER_TABLE', 'wp123_users');
define('CUSTOM_USER_META_TABLE', 'wp123_usermeta');

Also what you need to do is put the sites in a shared database. So that the database name is the same, database user is the same, and database password is the same. Basically connection is the same. If this make sense.

What i have above is what will allow for two different WordPress installations to share the same user base.

Related Posts:

  1. What is the fastest way to generate a unique id number when registering a user
  2. How to share plugin created database tables between two WordPress sites
  3. SSO system between 2 WordPress installs on different servers
  4. Enter user registration information in the database
  5. multiple wordpress installation with shared usertable on an different database
  6. User accounts for saving form data?
  7. Insert Extra fields added in the front end registration form to DB
  8. wp_usermeta key problem
  9. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  10. Relaunch 4.2 utf8mb4 database upgrade
  11. Get error messages when $wpdb->insert() returns false?
  12. Does dbDelta delete columns as well?
  13. Where can I find the database changes between WordPress versions?
  14. When is it appropriate to create a new table in the WordPress database?
  15. Special characters in WordPress UTF-8 [closed]
  16. How to delete outdated, wrongly sized images in _wp_attachment_metadata?
  17. Prevent changing the length of post_name column on WordPress Update
  18. Why does dbDelta() not catch MysqlErrors?
  19. how to transfer wordpress sql/database from local to live
  20. Is altering a default WordPress database table update safe?
  21. Get Database Credentials from within the themes file
  22. what to do when your WordPress database is too large?
  23. Change all http to https in mysql databse?
  24. WordPress DB: options-table –> 32 gzipcompression?
  25. Having issues with wp_postmeta and wp_usermeta tables too big
  26. WordPress site uses MyISAM, should I switch to InnoDB necessary?
  27. How to prevent WordPress from retrieving data for the last 10 posts in the database?
  28. WP Database Table to CSV file
  29. Uppercase to sentence case for post titles
  30. How to retrieve and show database table in wordpress dashboard
  31. Moving to another host; which tables to move in a database
  32. WordPress mysql table double prefixes
  33. Merge two WordPress installations into one, and keep posts separated?
  34. Moving online website to MAMP or dumb idea?
  35. How can I transition a site from using the Beta Tester plugin to a “normal” install?
  36. Storing data for a wordpress plugin
  37. Transient feeds and caching error
  38. get_tags() return an empty array after added tags with wp_insert_term()
  39. WordPress database import: Row size too large
  40. Advanced SELECT query with condtional statements
  41. Why do mass updates to post_content shows in front end, but not in edit screen?
  42. How to disable (get rid of) home page main loop entirely?
  43. How can I (semi) automate a database export and import to a different location?
  44. Insert post in another database
  45. Improve performance by removing unnecessary database queries
  46. Redirecting to old domain after migration website
  47. Localhost keeps redirecting to live domain
  48. How to get membershiplevel from WordPress Database?
  49. Child parent relationship inside WP DB
  50. Copying database tables to new database
  51. Duplicating Complete WordPress Install for Development and then Redeployment?
  52. What does wp_term_taxonomy.parent reference?
  53. How to combine multiple wp_insert_post into one in order to gain better performance
  54. How to get nav_menu_item_id and slug from wp database
  55. Two prefixes in database? Which one is valid?
  56. Is there a way to execute a php script outside WordPress?
  57. Problem in using wpdb
  58. How can I restrict php mail() to only send me one email after a db error
  59. pull data from a remote wordpress database
  60. Create database on installation
  61. How to delete post comments from the database via SQL statement?
  62. Users table missing from Database [closed]
  63. Why does changing Database Table Prefixes result in loss of content?
  64. Options on how to Display member specific data from a MS SQL database
  65. How to connect and insert data in database of wordpress?
  66. wp_option table error while importing
  67. wp_insert_user not creating account correctly when ID is manually set
  68. Installing local to live WP into subdirectory
  69. What is wrong here? Issue with post_id and meta_value
  70. Counting post and changing roles in mysql database. Query not code
  71. MSQL database wp_postmeta has meta key tve_revision
  72. Deleting empty meta key values
  73. Occasional Error Establishing a Database Connection
  74. WP 5.5, child themes, customizer and a weird cache issue
  75. Display user data in numbered list
  76. Removing old_slug and old_date from WordPress Database
  77. How do I change several broken URLs in a several wordpress databases in the fastest way?
  78. Best way to store 1 billion+ posts?
  79. Optimize WP site for millions of posts
  80. Why am I being prompted to reinstall wordpress?
  81. What’s the easiest way to connect external database and display data on wordpress?
  82. Character encoding issue – black diamond question marks on imported post excerpts
  83. WordPress Migration – Issue with admin panel changes
  84. Reinstall wordpress/mySQL caused database problem
  85. How To connect to the same WordPress database with different database user
  86. Call to a member function insert()
  87. I have include wp-config, should I add global $wpdb also?
  88. Localize strings from db
  89. Create a new table on the database and save parameters from a contact form
  90. How to have WP Search widget index dynamically generated content?
  91. Preventing concurrent update of data
  92. Redirect Issue: WordPress database
  93. Changing starting number of User ID
  94. Category not displaying in add post, edit post, and categories page.
  95. Creating Tables in WordPress Database
  96. Calling update_user_meta inside of another function doesn’t work
  97. $wpdb->prepare returns empty array
  98. Prevent creation of unused database tables?
  99. How to store a plain password in WordPress database in another field
  100. How to stop WordPress from using utf8mb4_unicode_ci collation

Leave a Comment

tech