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?
- restore_current_blog() vs switch_to_blog()
- Anyone figured out how to use WordPress MultiSite with Domain Mapping & SSL?
- What do I need to do to convert my MultiSite from HTTP to HTTPS?
- How can I display all Multisite blogs where this user is administrator?
- Create unique robots.txt for every site on multisite-installation
- WPDB Multiple site’s posts and get featured images
- Using WP CLI to set options in WP Multisite
- Ideal WP multisite server setup for up to 1000 sites?
- WordPress 3.2(Multisite) – How to add custom user meta fields to signup form?
- WordPress 3.8.1 Multisite blog slug problem
- Transients API and multisite
- Importing Multiple DB to one MU database
- Downgrading a WP3.3.1 Network Install
- Retrieving data from specific multisite blog
- Network Plugin Creating Pages for Different Subdomains
- Problem uploading images
- Multisite – 404 when accessing sub-sites
- Multisite: How can I have the admin bar (toolbar) use the language of the user instead of the language of the sub-site being viewed?
- .htaccess rules for blocking bots with an extra condition
- Wrong filepaths and admin page infinite reload after migrating to aws bitnami
- How to host unrelated pages on WordPress domain
- How can I overhaul a live MultiSite network?
- Update configured themes
- Multi-Site Subfolder User Permission Issue
- Programmatically Add Item to WP Multisite Menus
- why there is a large file named core in wpmu’s directory?
- wp_get_attachment_image_src on multisite
- Problem with parked domain for my mutisite
- WordPress multisite – What’s the ideal setup for development/staging/production environments?
- WordPress self hosted site asking to login again when used www
- Multisite – big hosting package or several hosting packages?
- WordPress network vs Separate installs
- 404 on page 2 multisite
- How can I append blog_id to … echo [functions-defined-constant]?
- Page Builders and WP Multisite
- Is a multisite install what I need?
- Manually Moving Posts/Pages/Comments/Tags from WPMU to WP3.0
- Create link preview for theme wordpress
- Language per user role, how can I achieve this?
- Internet explorer not finding right content from multisite
- Change WordPress multisite to sub-folder installation
- How to add a link of “one” website in posts of “second” website in multisite WordPress
- Themes are visible in Network, but invisible in sites
- No debug log for WP multisite is created
- Multisite – each site with it’s own set of users
- Migrate site from WordPress multisite to another WordPress multisite
- Split a Multisite Into Single WordPress Websites
- Is it possible to put a site other than #1 as a Multisite top-level domain?
- Should I go for Multisite or separate WP Installation?
- Single installation with sub-domains for admin and separate domains for sites
- The wpmu_blogs_columns filter is not working
- Map WP Multisite blog.example.com to anotherdomain.com/blog?