Difference Between Admin and Super Admin in Database

Site admins are stored in a site option as an array of usernames.

For example, using SQL in MySQLWorkbench you can do a query such as this:

SELECT * FROM wp_sitemeta where meta_key='site_admins';

To get back a serialised PHP array. Modifying this value by adding your username and user ID will make you a site admin.

If you’re just looking to see who is a site admin, you have these functions:

get_site_admins();
is_super_admin();

If on a single site rather than a multisite, any user with the delete_users capability will be regarded as a super admin.

Related Posts:

  1. Create mobile site with same content just different theme
  2. How to hide or remove unwanted widgets on Multisite installation?
  3. How can I diagnose a slow WordPress admin?
  4. How to enable a site administrator to edit users in a WordPress network/ multisite setup?
  5. WP-Admin not working properly at WordPress multisite with subdirectories
  6. Security in WordPress plugin development
  7. Hide a theme on list of themes in wp-admin without editing core files
  8. wp-admin slow in multisite
  9. Don’t allow access to wp-admin but allow admin-ajax requests to be fulfilled on frontend?
  10. Timeout While Upgrading Network in Multi-site
  11. Uploading Images to Multi-Site Causes Failure to HTTP Error
  12. Multisite wp-admin redirect loop
  13. WordPress network (multisite) /wp-admin/ redirect loop (ERR_TOO_MANY_REDIRECTS)
  14. Copy posts from one blog to another in multisite environment
  15. My subsites accidentally went from one multisite network to another. How do I change it back?
  16. Redirect loop (only for multisite network admin)
  17. Manipulate list of themes in wp-admin
  18. Creating a Post form outside of the Admin
  19. Subsites in Multisite installation throwing 404 error on wp-admin in IIS 7
  20. How to remove Broken Link Checker widget from admin menu
  21. How to set Active plugins as the default screen?
  22. Why can’t I delete original user in multisite? Options for manual removal
  23. Multisite network admin – URL / redirect error
  24. Cookie nonce is invalid – Multisite
  25. WordPress mutisite migration
  26. Why does the My Site dropdown show only a single domain?
  27. Super admin access to a forgotten WP instance?
  28. Iframe being removed only for some users when publishing a page
  29. WP Multisite with Domain Mapping : Preventing User Access to Dashboard
  30. 2 website 1 database… Local to online
  31. Moving wp-admin folder to a different host in a multisite environment
  32. Site’s admin created with wpmu_create_blog accessible only on 2nd attempt
  33. Is There A Plugin to Create WP Multisite Installs programatically
  34. Can’t log in to wp-admin after setting up Multisite
  35. Infamous admin login redirect
  36. WordPress multisite second site admin resulting in too many redirects error
  37. Multisite wp-admin redirecting to main wp-admin using NGINX
  38. WordPress Multisite: Login to all subsites at once
  39. How to Add Super Admin for WordPress multi-site
  40. network admin pages not linked to correctly
  41. Multisite – cannot remove specific sub-menu its parent menu. All sub-menus disappear
  42. How to have same admin login for more than one site?
  43. WP Admin Panel for Multi-site install not loading JavaScript for one Subdomain
  44. Backend freezing on certain pages of a subsite
  45. Admin user getting redirected to /wp-admin/user
  46. Pages redirect me to the homepage
  47. Many big issues in the website, WP_Debug not showing
  48. What could be changing my WP password and blocking plugins from installing?
  49. Wp-admin wrongly redirecting on multisite
  50. Unable to change blog language in multisite
  51. Multisite logged into one wp-admin, move to another sites wp-admin asked to login again
  52. Memory growth with new additions to WordPress Multisite
  53. How to disable a network enabled plugin for just one site?
  54. Set default avatar network-wide
  55. wp-activate.php causing white screen of death
  56. Multisite: Develop locally using production images with .htaccess
  57. Multisite with entirely different domains?
  58. How To Modify New Sub Blog Immediately When Super Administrator Creates It?
  59. Can you set up a wordpress (multi-site) network to work across multiple hosting accounts?
  60. Possible to create a multisite network where the main site is non-WP?
  61. Multiple WP Sites Same Server – Share WP Base?
  62. Poor performance on multisite install
  63. Cannot access wp-admin after disabling all plugin
  64. Auto Redirect after login
  65. Start with multi-site feature now or later?
  66. Adding new sites to Multisite won’t register in Dashboard
  67. Add menu items/actions for multisite users who are registered on the network but do not have a role or capability in any sites
  68. Blocks Rest API rest_cannot_delete
  69. htaccess file for multiple CMS’s (multisite wordpress + wolfcms) on same domain but different subdirectories
  70. Redirect One Multisite to Another
  71. Multisite Installation is all the same site
  72. Some doubts related to Multi Installation → Media of one of the site can be used on the others?
  73. Redirect to localhost after installing Multisite on server
  74. How can I hide certain sidebars from some users?
  75. Hosting 2 WordPress websites in /public_html/ & /public_html/subdirectory/ at the same time
  76. wp_get_attachment_image_src returns incorrect URL on multisite
  77. Locking one blog of many in a multi user/blog WordPress installation
  78. How to modify wp_config file for set up subdirectory?
  79. Activation Account Email
  80. How to automatically translate plugin using translate.wordpress.org
  81. May I do multiple micro-sites with different themes in a single wordpress without subdirectory nor subdomain separation?
  82. Multisite htaccess file causing segfault (Segmentation fault 11)
  83. Multisite Smtp Server
  84. Images uploaded after adding multisite do not get loaded in any domain of the multisite network
  85. When hooking wp-cron to system
  86. WordPress network, add extra directory to subsite urls
  87. Register a user only to the root blog – WP Multisite
  88. Update Same Contents on every Page
  89. WooCommerce API Returns 401
  90. Define default settings for new sites on multisite network with mu-plugin
  91. Multisite + wp_mail – Route Via Site Conditionally
  92. MU domain mapping without using a plugin
  93. Multisite authorization error 401
  94. How create a multisite setup with “phantom” accounts and passwords?
  95. is there a if multisite have posts function?
  96. Multisite – mix sites that use subdomains with sites that use paths
  97. Pick your brain on wp-config.php if statement for multisite
  98. WordPress Multisite restict user access
  99. get_category_link() or get_tag_link() return wrong category/tag base in wordpress multisite
  100. WordPress Multisite Domain Mapping Issue: Subsite Domain Redirecting to Primary Domain

Leave a Comment