User roles aren’t stored in the user or user meta table, they have their own table, and they’re on a per site basis so reusing them isn’t so simple for setups like this.
In your case it would be significantly easier to use a multisite install using subdirectories rather than subdomains, then all of this would be taken care of for you automatically.
Related Posts:
- Login in WordPress using external database data
- Where is custom template file chosen for a post stored in the DB?
- Finding the login page from database?
- SQL Query to Update Admin Email
- How do I get WordPress login to ignore the password input if a particular username is used?
- Why is it that not all users have a ‘session_tokens’ meta_key record in the usermeta table?
- Finding the original login information in the database
- Database Table for customer user
- Permit Login if table row exists
- Auto login subdomain from main domain on single sites with different DB
- Logins from WP users table use on another page
- Is it possible to rebuild the website while not accesseing the original database?
- Adding prefix to WordPress database tables breaks admin capabilities?
- Recovering the table wp_usermeta from users
- WordPress has been updated! Before we send you on your way, we have to update your database to the newest version
- Unable to login to a https website via the app after changing from http
- How to protect my credentials on my clients website
- Saving zero as meta value
- Migration: Copying database content to a different server
- Remove empty rows from the database
- Check if post id exist in table than only update instead of inserting new row
- Detail explanation of wordpress database fields and metatag list [closed]
- CreateOrUpdate in WordPress
- $wpdb->get_results($wpdb->prepare(… You have an error in your SQL syntax;
- How to convert srcset links from https to http?
- How to get a list of WordPress default database tables?
- Can local WordPress installs share /wp-content/ folder and database?
- Does deleting the table users prevent all logins?
- Changing order of db results when encoding to JSON
- How to transfer from localHost to live but use the already existing database on the server?
- Backing up WordPress database and files
- Safely store code(html/js..) into database
- Creating and Using Tables in the WordPress Database
- How not to display ALL items of a database
- Connect a membership plugin to an external database
- Compare User meta_value with Product meta_value
- How to get the records from start with A to G in php and mysql
- Storing user’s data on external database on other server
- Link multiple user databases together?
- is it right choose to connect database in template page directly in WordPress site?
- How to insert a value to decimal type field using wpdb->prepare?
- Sql query to get all metadata for a post
- I wanted to Know that how can I give ingore to 0000-00-00 in my config file
- Set a cron job to delete a specific database table table every midnight
- Two separate wordpress installations at one domain
- Is there a way to edit the WP content database in an admin panel or external page?
- Where do I put my create_new_table function()?
- SQL database import #1046 error
- Get all top categories, then only 3 posts for each
- Having all “non-PHP” files on a different server
- syntax error for changing user role from database
- Error establishing a database connection in wordpress
- Where is the HTML-handler part in the wpdb class?
- Finding a page holding a specific string/URL that is used in the content
- “wordpress error in establishing database connection” and missing tables
- get_option() does unserialize and don’t remove \
- next comment id number wordpress
- Trying to login to my site redirects me to the first page
- Adding last value from Database as text in WordPress Page
- Want to update value in database. But it says update() on null
- Migrate not successful, DB is broken. How to fix, or at least output static HTML without plugins?
- Admin Login Checks
- Merging development site with live site
- Backup Restore turns carriage returns to literal strings
- I have a WordPress 4.6 database dump – how do I use it in a new install?
- Find/ascertain latest wordpress db from multiple database copies
- Local Content different from Remote Content
- Check if a database is well installed
- Checking if the data already exsis in the wp database – custom plugin
- live site do not update after importing sql database
- Transforming an wp_options database array into a javascript obect?
- save content in to wordpress wp_post table of database
- WordPress + Postgresql
- WordPress login process is hanging
- How can I retrieve data from alternate database using wpdb class?
- Database connection close
- Author ID mismatch from database
- MySQL Database User: Which Privileges are needed?
- Import Excel (or csv) Table with user-data as subscribers to wordpress
- Automatic add record after refreshing page
- User accounts for saving form data?
- Trying to edit a WP site locally using MAMP
- SQL query : Select a thumbnail for a media
- trying to install wp but i have no clue on hosting and servers [closed]
- What is table `wp_woocommerce_termmeta` for? [closed]
- WordPress API standard compliance and specification for external database [closed]
- Log IP of users who click a button? [closed]
- DROP TABLE IF EXISTS `wp_options` error?
- Problem with form database connectivity
- Server database problem
- Best way to search and replace within serialized database strings?
- How can i change the nicename and the displayname in a bulk in the database?
- cannot access wp-admin after options table crash and repair
- How to update multiple row by one query
- Have WordPress Use a Different Database for users
- WordPress post on home page of my website
- large number (bigint) for post ID issue in database
- Count views without get_post_meta
- How to stop wordpress from redirecting from the post’s old slug after changing title and slug?
- Error of ‘P404 Migration skipped. Already completed.’ on error_log file