Note: Super Admins only have meaning in WordPress Multisite. I’ve assumed below that you’re running Multisite, though your question isn’t tagged as such.
Super Admins are stored as a serialized array in the {$prefix}_sitemeta table in the site_admins record. In my local installation, with only the user ID adminpj as a Super Admin, here’s what I see:
mysql> SELECT meta_key, meta_value FROM wp_sitemeta WHERE meta_key='site_admins';
+-------------+--------------------------+
| meta_key | meta_value |
+-------------+--------------------------+
| site_admins | a:1:{i:0;s:7:"adminpj";} |
+-------------+--------------------------+
Unserializing the meta_value, I get:
Array (
[0] => adminpj
)
So you can either a) see what your existing Super Admins are, or b) add your own username to the site_admins record.
Related Posts:
- Create mobile site with same content just different theme
- How to hide or remove unwanted widgets on Multisite installation?
- How can I diagnose a slow WordPress admin?
- How to enable a site administrator to edit users in a WordPress network/ multisite setup?
- WP-Admin not working properly at WordPress multisite with subdirectories
- Security in WordPress plugin development
- Hide a theme on list of themes in wp-admin without editing core files
- Difference Between Admin and Super Admin in Database
- wp-admin slow in multisite
- Don’t allow access to wp-admin but allow admin-ajax requests to be fulfilled on frontend?
- Timeout While Upgrading Network in Multi-site
- Uploading Images to Multi-Site Causes Failure to HTTP Error
- Multisite wp-admin redirect loop
- WordPress network (multisite) /wp-admin/ redirect loop (ERR_TOO_MANY_REDIRECTS)
- Copy posts from one blog to another in multisite environment
- My subsites accidentally went from one multisite network to another. How do I change it back?
- Redirect loop (only for multisite network admin)
- Manipulate list of themes in wp-admin
- Creating a Post form outside of the Admin
- Subsites in Multisite installation throwing 404 error on wp-admin in IIS 7
- How to remove Broken Link Checker widget from admin menu
- How to set Active plugins as the default screen?
- Why can’t I delete original user in multisite? Options for manual removal
- Multisite network admin – URL / redirect error
- Cookie nonce is invalid – Multisite
- WordPress mutisite migration
- Why does the My Site dropdown show only a single domain?
- Iframe being removed only for some users when publishing a page
- WP Multisite with Domain Mapping : Preventing User Access to Dashboard
- 2 website 1 database… Local to online
- Moving wp-admin folder to a different host in a multisite environment
- Site’s admin created with wpmu_create_blog accessible only on 2nd attempt
- Is There A Plugin to Create WP Multisite Installs programatically
- Can’t log in to wp-admin after setting up Multisite
- Infamous admin login redirect
- WordPress multisite second site admin resulting in too many redirects error
- Multisite wp-admin redirecting to main wp-admin using NGINX
- WordPress Multisite: Login to all subsites at once
- How to Add Super Admin for WordPress multi-site
- network admin pages not linked to correctly
- Multisite – cannot remove specific sub-menu its parent menu. All sub-menus disappear
- How to have same admin login for more than one site?
- WP Admin Panel for Multi-site install not loading JavaScript for one Subdomain
- Backend freezing on certain pages of a subsite
- Admin user getting redirected to /wp-admin/user
- Pages redirect me to the homepage
- Many big issues in the website, WP_Debug not showing
- What could be changing my WP password and blocking plugins from installing?
- Wp-admin wrongly redirecting on multisite
- Unable to change blog language in multisite
- Multisite logged into one wp-admin, move to another sites wp-admin asked to login again
- Memory growth with new additions to WordPress Multisite
- How to run an activation function when plugin is network activated on multisite?
- Specific upload folder for PDFs in custom Post type in WP multisite
- How can I un-reserve a pending username registration?
- Redirect Main Site to Subsite in Multisite WordPress
- WordPress Multisite: Adding actions to only one site
- wordpress multisite, how to keep user on subdomain throughout registration process?
- Can I set some default pages to be created on every creation of a new blog
- get_current_blog_id returns 1 in multisite setting
- On WP Multi sites how many sites…!
- How do I share plugin settings across WordPress network?
- How would I use pre_get_posts to query another site for posts in my multisite network?
- How to set up WordPress Multisite on multiple domains without plugin?
- Blog Settings import/export in WordPress Network environment
- Multiple domain names under one WordPress Installation
- What is the most comprehensive backup plugin for WordPress (it does not have to be free)? [closed]
- Multisite wordpress and subdomain URL collisions
- WordPress Multisite: Automatically run importer upon creating new site
- Auto create pages on WordPress multi site register
- Add Rewrite Rule to point to a file on the server
- Multisite WordPress nginx uploaded files throw 404
- subdomain mulitsite on localhost in a subfolder
- Exclude main blog from get_blogs_of_user
- WordPress Network for regional company websites
- Subdirectory multisite installation with several domain names?
- Can’t access WordPress multisite after connecting to domain
- In MultiSite, can some users automatically have Site Admin rights on all sites, without granting them Network Admin access?
- Media library not loading after switching the main site of multisite
- Multisite media library uploads broken images
- Any downsides on using Multisite for many look-alike-websites?
- Login on Multiple Sub-Domains without Multisite
- Prevent images on self-hosted WordPress from being served from WordPress.com
- Use another author.php if different multisite subsite?
- Subsite with different template, and content
- What is best forum script available to integrate with wordpress?
- WordPress multisite fails to create a new site in the network
- Changing path for media upload folder in wordpress multisite
- Link to Network Admin Broken After Switching to HTTPS
- Making 2 WordPress sites mutually searchable and more
- Multi-site get_bloginfo(‘stylesheet_directory’) referring to sub-folder
- Unable to apply theme to WordPress Network Site install
- How to convert multi-site to single site
- Use WordPress MultiSite (WPMS) with a remote database for each created site
- Viewing / Editing A Multisite website after domain has expired
- Redirect old uploads after moving to multisite
- URL for images folder on Multisite
- Multisite Conversion White Screen Error
- something in database is causing me to not be able to log into network admin of multisite
- Show 404 when someone visits a non-existant Multisite site