Within the database, where is the flag which says that a user has Super Admin rights?

This is actually stored in the {prefix}sitemeta table. The meta key is site_admins, and it’s a serialized PHP array of usernames.

Related Posts:

  1. find a random blogid across my multisite network that has at least one post published
  2. Split a database will improve performance?
  3. Bulk activate a theme on multisite
  4. Database Tables Lost Indexes? How to Recover?
  5. Will changing the folder name two directories above a fresh wordpress installation break the site?
  6. new multisite, old db
  7. WP MultiSite: Can’t select database error after changing to new domain
  8. Get multisite count without php?
  9. WordPress and SQL – Update and Insert from another table if column value doesn’t exist
  10. MySql Database In WordPress Multisite
  11. Plugin data shared in Multisite
  12. Merging versions of wp_posts based on post_title
  13. Where are available Roles Defined in the wp_ database?
  14. Site admin in a network install can’t edit users?
  15. DB connection error after copying a WordPress Multisite instance to a second location
  16. what are pmxi tables? [closed]
  17. Issue with Custom Roles in Multisite
  18. How to enable a site administrator to edit users in a WordPress network/ multisite setup?
  19. Shared table across network
  20. WP-CLI methods for get_current_blog_id, get_blog_details or $wpdb->prefix
  21. How can I display all Multisite blogs where this user is administrator?
  22. Restrict users on multisite WordPress install
  23. Possible to make custom role in multisite that can add sites?
  24. Built to scale, or worry later?
  25. Uploading/Deploying a Multi Site Install
  26. Configure WordPress to read from database only, never write
  27. Multiple Domains and Subdomains Using Multisite Installation
  28. SQL Query to Get list of all users along with their blogs
  29. Is it possible to fix/repair all Index, Primary Key, Unique (and all other) structure of a WordPress MS Database
  30. Synchronizing Two WordPress Sites Content
  31. How to clone and locally run a network for testing
  32. How To Remove Dashboard Menu Items for Multisite Users?
  33. How to get a user role of a specific blog in multisite?
  34. Can wp-cli display all users and their roles across all sites in a multisite instance?
  35. Two WordPress sites sharing the same database
  36. Using $wpdb Class to Pull Recent Comments Across a Network
  37. Is it possible to import a wordpress backup from a single site in to a multi-site configuration?
  38. Multisite Subdomain Using More Resources Than Others?
  39. How to change the database prefix in multisite (WPMU) install
  40. Importing Multiple DB to one MU database
  41. Make WordPress Search for Both Main Domain and Subdomain
  42. Does WordPress MultiSite use separate MySql databases?
  43. Bootstrapping WordPress MultiSite Outsite of WordPress – No $wpdb
  44. Performance on WPMS
  45. Migrating Multisite – Database error, missing wp_blogs table
  46. WPML tables not deleted when removing multisite subsite, need help clearing up my sql-file! [closed]
  47. Removing a wordpress multisite installation and preserving the database before migrate to nginx
  48. access the plugins for each role in WordPress multisite
  49. How to change user starting role in WordPress MultiSite?
  50. Allow Author on Site A capability to upload files on Site B in Multi Site
  51. Installed domain-based Multisite but can’t access wp-admin (redirect loop)
  52. Pushing stored procedure to a multisite database in WordPress
  53. Create a database for each site created in multisite?
  54. WordPress Multisite blogs not working after domain swap
  55. Multisite user roles – capabilities not working
  56. Create Custom Multisite User Role to Reduce Capabilities
  57. 2 website 1 database… Local to online
  58. Obtaining user table for one site on multisite set up
  59. Restrict Capability of Administrator to Create, Edit and Delete Pages in Multisite
  60. Copy user role on multisite so the user can access subsites with same role
  61. How to change a user role after registering in multisite?
  62. How many databases do I need?
  63. How do I display offsite database info on my wordpress site?
  64. Locking one blog of many in a multi user/blog WordPress installation
  65. How to sync roles across Multisite?
  66. WordPress Multisites or Multiple WP Single sites?
  67. Delete all user’s meta without knowing all the ‘key’
  68. Combining user database tables while keeping all other data in seperate for multiple sites?
  69. How to make multi site with single Database?
  70. Multisite network admin – User’s role not showing up
  71. WordPress Multisite Add User
  72. Sharing users across multiple sites, each on their own database
  73. importing data into wordpress db
  74. add_blog_option blog ID
  75. How long is “as long as possible” in wp_cache_set()?
  76. WPMU on MySQL limited to 1GB of space?
  77. Give users acces to admin a single post or set up WP network?
  78. How to create a blogs category page with Blog-Types Plugin
  79. Language per user role, how can I achieve this?
  80. Can I use the main Multisite as a backend only?
  81. Problems with WordPress multisite directories/url structures and admin access after migration
  82. Redirect a user roll to a page after login in mutlisite network
  83. Search returns “Nothing Found” on a sub directory
  84. How To Upload Existing WordPress Site To WordPress Multisite Using SSH
  85. wordpress multisite – handle Database
  86. Importing Posts into New Website with Same User ID’s
  87. WordPress automatic Login on other page?
  88. How to reconnect database to existing wordpress multisite setup after changing site name
  89. WordPress Multisite with thousands of blog
  90. Multiple domain with one database
  91. WP DB Location for “Next Post to Create” Index Value
  92. How create a multisite setup with “phantom” accounts and passwords?
  93. Multisite Tables the same as Single Install?
  94. Multisite vs Role Scoper
  95. How can I display all Multisite blogs where this user is administrator?
  96. WordPress Multisite platform for different city for single db
  97. Multisite and users being listed on network administration dashboard and not main site dashboard
  98. 4th Network Site Database Errors?
  99. Is there a full explanation on how to share a database with two WordPress sites on same server?
  100. Too much slow queries with my multisite