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
- Checking if Database Table exists
- Staging sites, how do you manage synchronising updates in the DB?
- How To Export/Import WordPress (MySQL) Database Properly Via Command-Line?
- Using transients in conjunction with memcached
- Has parent field in the table wp_term_taxonomy has term_id or term_taxonomy_id
- Forcing nickname as display_name in custom edit profile template
- Syncing local content with development / staging sites
- Export WP database for import using WP-CLI on Vagrant Box
- Improve or optimize a very slow query
- What is the advantage of separating wp_users and wp_usermeta table?
- Showing content from another wordpress installation database in the page template loop?
- “MySQL server has gone away” since update to 3.8
- WordPress page title repeated in SOME pages
- Why is $wpdb->get_results failing on certain tables but not others (which have data)?
- How to correctly add a table to the WordPress MySQL database
- MySQL Syntax Error upon restoring database from backup [closed]
- Help running a MySQL query to update all wp_#_options tables in a Multisite install
- Error thrown. Cannot create references to/from string offsets
- Is it safe to convert tables from MyISAM to InnoDB?
- Use one WordPress database with multiple instances of one site
- Who is responsible for data sanitization in WordPress development?
- How do I properly update the WordPress database password?
- wpdb_prepare with multiple or condition
- How to check if a core update, like 4.9.8 → 5.0, involves a database update (migration)?
- $wpdb->insert is not working
- WordPress Install and Database on separate hosting?
- Moving a site from a temporary domain to the live domain [duplicate]
- What is this in my tables
- Exporting table to csv works in the admin but exports HTML data when used on the front end
- wp search-replace (not executing)
- Create table from array with prepare
- Migrate database between 2 different wordpress version
- SSO system between 2 WordPress installs on different servers
- Form that sends data to an admin panel and can export it
- All text disappeared (seems to be a database problem) [closed]
- Convert user passwords to MD5?
- is wordpress stores Role Id in WP database?
- Why do database examples sometimes finish with an add_option call?
- Does post_meta data need to be unserialzed?
- How to backup my site and restore my wordpress site
- How to fetch records from database WordPress
- How and where is wordpress adding mySQL content to database?
- How get Data form wordpress database as array not stdclass?
- cannot connect database
- How to delete a particular row in a database table
- Brandoo WordPress Unable to Update to WordPress 4.2.2
- Connecting to wordpress database in my application [closed]
- Remote database -> massive response time increase?
- Custom Post Type not showing anything added by code anymore?
- “sufficient permissions” error for admin after duplicating WP database to new install
- How do I have a user upload a blog post and then retrieve that to display in a card on the site?
- Delete user with only subscriber role
- WordPress keeps redirecting to localhost
- get value from ‘terms’ table
- custom tables in wordpress Database? (can i just create them with sql?)
- How to rename custom table name programatically in wordpress?
- Displaying requested data from a the database in wordpress
- How to edit custom table data in frontend
- pre_get_posts causings DB error when using ( ‘posts_per_page’, -1)?
- generate PDF from member information
- mysqli_query(): MySQL server has gone away for Curl Request
- Help posting values to DB on submit using $wpdb->query
- I can’t access login page
- create a table using user meta custom data
- wpdb query to insert images in to post/page gallery
- Creating a database in my plugin not working
- How to create index (sql) to a meta_key?
- Not sure what to do next to optimize
- get_user_meta and umeta_id
- $wpdb not working
- Accessing content from third party as native posts in WordPress
- Send data to database after redirect (and popping out of iframe)
- Fetch data from another site, but the same database
- Simple email input store in database
- Pulling values from a sepcific row in table
- import (migration) user database to wp-users
- $wpdb->insert not working for last select option
- How to create a table [closed]
- Upload wordpress from localhost to 000webhost
- wp_usermeta key problem
- How to properly configure SSL connection to remote azure database for running queries within a WordPress environment
- Database Queries are crashing the server
- Uploading to WordPress Database