How to use user table of a different database for WordPress users?

It might work to use a view as essentially a table alias, by doing the something like the following with the WordPress instance mysql database

 DROP TABLE wp_users
 CREATE VIEW wp_users AS SELECT * FROM CI.users;

However

  • will probably need to tweak the view creation to map the columns
  • the password encoding may well be different, so you might have hack WP core anyway to handle this
  • you probably need to manually modify the wp_usermeta table to properly signify admins.

Related Posts:

  1. Multiple developers / editors working on a site in progress
  2. How many users can WordPress handle?
  3. How to track user progress?
  4. Performance tips for a large user base [closed]
  5. Efficiency on displaying random authors based on large database
  6. Extend the wp_users table
  7. Subscribers to posts
  8. Set Display Name to first and last name (phpmyadmin SQL Query)
  9. Select Multiple meta_value from WP DB; Single Query
  10. Getting all the users who have author privilege
  11. Does WordPress always create unique passwords?
  12. In what part of the WordPress core does the users table and usermeta table get joined?
  13. Why is it that not all users have a ‘session_tokens’ meta_key record in the usermeta table?
  14. Modify Database in Multi-Site wp_usermeta table
  15. Change WordPress prefix for only one table?
  16. wp_get_current_user always returns 0 continued
  17. Is there a smart way to obtain a list of only some selected user meta data?
  18. How can i customize the export personal data file?
  19. What Is the Proper Way to Merge Usermeta Table to a an existing WP Database?
  20. Import users from old WP site to new one
  21. How to Access wp_usermeta Data Immediately After a New User is Created
  22. Logins from WP users table use on another page
  23. MS Access to manage WordPress Database
  24. 2 WordPress sites with 2 databases but sharing the same users
  25. Convert user passwords to MD5?
  26. Does WordPress store the username as a primary key in the database?
  27. Is there a way to execute a php script outside WordPress?
  28. multiple wordpress installation with shared usertable on an different database
  29. Best practice to import user base (subscribers) from one website to another?
  30. Share users across multiple sites on same database, but with different domains
  31. Users table missing from Database [closed]
  32. Some weird users in database
  33. How to delete a particular row in a database table
  34. Recovering the table wp_usermeta from users
  35. Regenerate user_nicename column
  36. Storing user submitted forms [closed]
  37. WordPress where clauses in db select
  38. wp_insert_user not creating account correctly when ID is manually set
  39. Select From wpdb – Author/User Directory page
  40. Can’t log into wordpress site – I have made a new user and still cant access
  41. Need help with creating a searchable user data by name or specific number like ID
  42. Migrate Users From laravel to wordpress
  43. Display user data in numbered list
  44. User input to database
  45. how add more field to wp user and save it to database
  46. Move Non-WordPress users table to WordPress database
  47. Change user_nickname for author page link
  48. how restrict user to give star ratings once for a post?
  49. create a table using user meta custom data
  50. How to get the id of recently registered user from database?
  51. How to save dropdown slection by a user in the DB
  52. How to get specific table by current user login
  53. update multiple user meta field based on another meta field
  54. Hash user emails in database?
  55. Changed meta_key value in structures, now dashboard shows zero users
  56. What WordPress file is saving new users to database
  57. Get id from database
  58. WordPress sync with phpbb
  59. import (migration) user database to wp-users
  60. Import Excel (or csv) Table with user-data as subscribers to wordpress
  61. WP Multisite Users Not Linking
  62. Failed to connect to mysql at 127.0.0.1:3306 with user root access denied for user ‘root’@’localhost'(using password:YES)
  63. Can I have multiple primary keys in a single table?
  64. How to create bulk page and content? [closed]
  65. The revisions table in my database is at 70% capacity and growing. What should I do?
  66. WordPress for a very large website
  67. WP_list_table bulk_action get edit and delete
  68. How to display data from custom table in wordpress database?
  69. How to update BuddyPress xprofile fields programmatically? [closed]
  70. stdObject stored in database. How does one convert it to usable format?
  71. How wordpress accesses its own database
  72. Migrating database / content of non-CMS site to WordPress
  73. Show last modified date of database
  74. What generates these very slow postmeta queries? [closed]
  75. How to migrate a website based on a custom database to wordpress?
  76. How to scan barcode and store data into a database [closed]
  77. Fetching values from database for select box
  78. fastest replacement DB
  79. Have working sql query… trying to adjust it to use $wpdb
  80. Best host for running large mem and processor intensive WordPress sites?
  81. Strange characters added to the database
  82. Sharing users across multiple sites, each on their own database
  83. Website displays old version of page
  84. Image link issues after importing a database backup to my local web server
  85. multiple wordpress installs w/shared user database but separate content databases
  86. Updating seperate database when post attachment is changed
  87. add featured image dialog box disappear
  88. How to get a list of articles related to a particular category from my other WordPress website?
  89. /wp-admin not accessible after migrating to local host (no plugin issue)
  90. set_transient fails if the value has more than 60.000 characters
  91. Is there a way to save different data when USER interacts with the same POST?
  92. How can I get $wpdb to show MySQL warnings?
  93. About wp database hooks (error establishing connection)
  94. Database for JQuery Autocomplete field
  95. Create Tables in WordPress
  96. WordPress Failed to Login (DB Error)
  97. Share WordPress Database
  98. ERROR: “Table Prefix” must not be empty
  99. How do you build a database-centric site in WP?
  100. WordPress: Interact with Database Query Data and Login