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_usermetatable to properly signify admins.
Related Posts:
- Multiple developers / editors working on a site in progress
- How many users can WordPress handle?
- How to track user progress?
- Performance tips for a large user base [closed]
- Efficiency on displaying random authors based on large database
- Extend the wp_users table
- Subscribers to posts
- Set Display Name to first and last name (phpmyadmin SQL Query)
- Select Multiple meta_value from WP DB; Single Query
- Getting all the users who have author privilege
- Does WordPress always create unique passwords?
- In what part of the WordPress core does the users table and usermeta table get joined?
- Why is it that not all users have a ‘session_tokens’ meta_key record in the usermeta table?
- Modify Database in Multi-Site wp_usermeta table
- Change WordPress prefix for only one table?
- wp_get_current_user always returns 0 continued
- Is there a smart way to obtain a list of only some selected user meta data?
- How can i customize the export personal data file?
- What Is the Proper Way to Merge Usermeta Table to a an existing WP Database?
- Import users from old WP site to new one
- How to Access wp_usermeta Data Immediately After a New User is Created
- Logins from WP users table use on another page
- MS Access to manage WordPress Database
- 2 WordPress sites with 2 databases but sharing the same users
- Convert user passwords to MD5?
- Does WordPress store the username as a primary key in the database?
- Is there a way to execute a php script outside WordPress?
- multiple wordpress installation with shared usertable on an different database
- Best practice to import user base (subscribers) from one website to another?
- Share users across multiple sites on same database, but with different domains
- Users table missing from Database [closed]
- Some weird users in database
- How to delete a particular row in a database table
- Recovering the table wp_usermeta from users
- Regenerate user_nicename column
- Storing user submitted forms [closed]
- WordPress where clauses in db select
- wp_insert_user not creating account correctly when ID is manually set
- Select From wpdb – Author/User Directory page
- Can’t log into wordpress site – I have made a new user and still cant access
- Need help with creating a searchable user data by name or specific number like ID
- Migrate Users From laravel to wordpress
- Display user data in numbered list
- User input to database
- how add more field to wp user and save it to database
- Move Non-WordPress users table to WordPress database
- Change user_nickname for author page link
- how restrict user to give star ratings once for a post?
- create a table using user meta custom data
- How to get the id of recently registered user from database?
- How to save dropdown slection by a user in the DB
- How to get specific table by current user login
- update multiple user meta field based on another meta field
- Hash user emails in database?
- Changed meta_key value in structures, now dashboard shows zero users
- What WordPress file is saving new users to database
- Get id from database
- WordPress sync with phpbb
- import (migration) user database to wp-users
- Import Excel (or csv) Table with user-data as subscribers to wordpress
- WP Multisite Users Not Linking
- Failed to connect to mysql at 127.0.0.1:3306 with user root access denied for user ‘root’@’localhost'(using password:YES)
- Can I have multiple primary keys in a single table?
- How to create bulk page and content? [closed]
- The revisions table in my database is at 70% capacity and growing. What should I do?
- WordPress for a very large website
- WP_list_table bulk_action get edit and delete
- How to display data from custom table in wordpress database?
- How to update BuddyPress xprofile fields programmatically? [closed]
- stdObject stored in database. How does one convert it to usable format?
- How wordpress accesses its own database
- Migrating database / content of non-CMS site to WordPress
- Show last modified date of database
- What generates these very slow postmeta queries? [closed]
- How to migrate a website based on a custom database to wordpress?
- How to scan barcode and store data into a database [closed]
- Fetching values from database for select box
- fastest replacement DB
- Have working sql query… trying to adjust it to use $wpdb
- Best host for running large mem and processor intensive WordPress sites?
- Strange characters added to the database
- Sharing users across multiple sites, each on their own database
- Website displays old version of page
- Image link issues after importing a database backup to my local web server
- multiple wordpress installs w/shared user database but separate content databases
- Updating seperate database when post attachment is changed
- add featured image dialog box disappear
- How to get a list of articles related to a particular category from my other WordPress website?
- /wp-admin not accessible after migrating to local host (no plugin issue)
- set_transient fails if the value has more than 60.000 characters
- Is there a way to save different data when USER interacts with the same POST?
- How can I get $wpdb to show MySQL warnings?
- About wp database hooks (error establishing connection)
- Database for JQuery Autocomplete field
- Create Tables in WordPress
- WordPress Failed to Login (DB Error)
- Share WordPress Database
- ERROR: “Table Prefix” must not be empty
- How do you build a database-centric site in WP?
- WordPress: Interact with Database Query Data and Login