Change WordPress prefix for only one table?

In wp-config.php for your second site, define the following two constants:

define('CUSTOM_USER_TABLE', 'yourfirstprefix_users');
define('CUSTOM_USERMETA_TABLE', 'yourfirstprefix_usermeta');

You’ll have to add some custom logic to your second site limiting logins by user role.

Related Posts:

  1. Multiple developers / editors working on a site in progress
  2. How many users can WordPress handle?
  3. WordPress Unit Testing – Cannot Create Tables
  4. Insert data in database using form
  5. How to track user progress?
  6. When is it appropriate to create a new table in the WordPress database?
  7. Has parent field in the table wp_term_taxonomy has term_id or term_taxonomy_id
  8. Performance tips for a large user base [closed]
  9. BuddyPress: What’s the use of wp_bp_xprofile_data table and how does it get updated? [closed]
  10. Efficiency on displaying random authors based on large database
  11. How to update BuddyPress xprofile fields programmatically? [closed]
  12. Extend the wp_users table
  13. stdObject stored in database. How does one convert it to usable format?
  14. How to use user table of a different database for WordPress users?
  15. Database with mixed collation (utf8mb4 & utf8_general_ci)
  16. Subscribers to posts
  17. Set Display Name to first and last name (phpmyadmin SQL Query)
  18. Select Multiple meta_value from WP DB; Single Query
  19. Getting all the users who have author privilege
  20. Does WordPress always create unique passwords?
  21. Moving to another host; which tables to move in a database
  22. WordPress mysql table double prefixes
  23. In what part of the WordPress core does the users table and usermeta table get joined?
  24. Why is it that not all users have a ‘session_tokens’ meta_key record in the usermeta table?
  25. Modify Database in Multi-Site wp_usermeta table
  26. wp_get_current_user always returns 0 continued
  27. input data and output table [closed]
  28. Is there a smart way to obtain a list of only some selected user meta data?
  29. How can i customize the export personal data file?
  30. What Is the Proper Way to Merge Usermeta Table to a an existing WP Database?
  31. Import users from old WP site to new one
  32. Retrieve data from the database to table such as comments in the admin control panel
  33. How to Access wp_usermeta Data Immediately After a New User is Created
  34. Logins from WP users table use on another page
  35. MS Access to manage WordPress Database
  36. 2 WordPress sites with 2 databases but sharing the same users
  37. Convert user passwords to MD5?
  38. Change options table prefix only
  39. Query multiple tables at once?
  40. Does WordPress store the username as a primary key in the database?
  41. Is there a way to execute a php script outside WordPress?
  42. multiple wordpress installation with shared usertable on an different database
  43. Best practice to import user base (subscribers) from one website to another?
  44. Share users across multiple sites on same database, but with different domains
  45. Users table missing from Database [closed]
  46. Some weird users in database
  47. Why does changing Database Table Prefixes result in loss of content?
  48. How to delete a particular row in a database table
  49. Recovering the table wp_usermeta from users
  50. Can I customised default WP table
  51. Regenerate user_nicename column
  52. Should I use an additional column in the DB?
  53. Storing user submitted forms [closed]
  54. WordPress where clauses in db select
  55. wp_insert_user not creating account correctly when ID is manually set
  56. Select From wpdb – Author/User Directory page
  57. Will adding & modifying default WordPress table index break future WordPress update
  58. What is wrong here? Issue with post_id and meta_value
  59. Can’t log into wordpress site – I have made a new user and still cant access
  60. Need help with creating a searchable user data by name or specific number like ID
  61. Migrate Users From laravel to wordpress
  62. How to edit custom table data in frontend
  63. Display user data in numbered list
  64. User input to database
  65. how add more field to wp user and save it to database
  66. Move Non-WordPress users table to WordPress database
  67. Change user_nickname for author page link
  68. how restrict user to give star ratings once for a post?
  69. How to map data on CSV to web pages?
  70. create a table using user meta custom data
  71. How to get the id of recently registered user from database?
  72. How to save dropdown slection by a user in the DB
  73. How to get specific table by current user login
  74. update multiple user meta field based on another meta field
  75. Hash user emails in database?
  76. Changed meta_key value in structures, now dashboard shows zero users
  77. What WordPress file is saving new users to database
  78. Get id from database
  79. WordPress sync with phpbb
  80. import (migration) user database to wp-users
  81. Import Excel (or csv) Table with user-data as subscribers to wordpress
  82. Create hundreds of users with just ID in phpMyAdmin
  83. WP Multisite Users Not Linking
  84. Have WordPress Use a Different Database for users
  85. Are There Any Plans for WordPress to Support Databases Other Than MySQL?
  86. how can get database name in wordpress?
  87. Long option names fail silently?
  88. WordPress and automated MySQL backups to a different host
  89. Size article thumbnails and retrieve them directly from database
  90. Switching Databases in LocalHost
  91. How to update the values when the featured image has changed?
  92. Does WordPress $wpdb functions wait when table is locked?
  93. Importing 10 Years of Media into the WP Database
  94. connecting to DB from custom php file
  95. Clear Terms from Taxonomy for Specific Post IDs?
  96. WordPress security [closed]
  97. How to split the WordPress database?
  98. Only allow user to access a link once a year, based on their joining date
  99. Error establishing database connection error during first WordPress run
  100. Install WordPress with SQL database