Title: Super Admin problem
Last modified: August 19, 2016

---

# Super Admin problem

 *  [isaak-wells](https://wordpress.org/support/users/isaak-wells/)
 * (@isaak-wells)
 * [15 years, 9 months ago](https://wordpress.org/support/topic/super-admin-problem/)
 * right here is the deal,
 * I successfully changed my table prefix and and all is well except one problem.
   I installed my new wordpress but when I migrated users and user meta I do not
   have Super Admin Control on any user because I did not set it up with my old 
   prefix database.
 * Now here is the question.
    Is there a way I can go into the sql file though phpmyadmin
   or something and give myself super admin access?

Viewing 9 replies - 1 through 9 (of 9 total)

 *  [Andrea Rennick](https://wordpress.org/support/users/andrea_r/)
 * (@andrea_r)
 * [15 years, 9 months ago](https://wordpress.org/support/topic/super-admin-problem/#post-1572278)
 * Yep.
 * Go inot phpmyadmin, find the sitemeta table and there will be a field there for
   siteadmins. Yes, it means Super admins now.
 *  Thread Starter [isaak-wells](https://wordpress.org/support/users/isaak-wells/)
 * (@isaak-wells)
 * [15 years, 9 months ago](https://wordpress.org/support/topic/super-admin-problem/#post-1572356)
 * Thanks for the reply. Bare with me though because I am very new at the back end
   stuff.
 * I found the table you are talking about. now what do i do?
 *  Thread Starter [isaak-wells](https://wordpress.org/support/users/isaak-wells/)
 * (@isaak-wells)
 * [15 years, 9 months ago](https://wordpress.org/support/topic/super-admin-problem/#post-1572381)
 * Never mind I figured it out. Thanks so much for the help.
 *  [satomom](https://wordpress.org/support/users/satomom/)
 * (@satomom)
 * [15 years, 9 months ago](https://wordpress.org/support/topic/super-admin-problem/#post-1572519)
 * I noticed today that the “network” option under tools is gone. And I don’t have
   super admin access anymore, though I do have admin access.
 * Checked phpmyadmin and made sure my username was listed in site_admins in wp_sitemeta.
   It is, though I don’t know what the other numbers and code in there means.
 * Also checked to make sure the `define('WP_ALLOW_MULTISITE', true);` command was
   still in wp-config. It is.
 * Also deactivated all plugins in unlikely event something there was the culprit.
   No change.
 * I’ve done something awful, no doubt, but have no idea what and how to get network
   and my super admin privileges back!
 * Can anyone help me?
 *  [Andrea Rennick](https://wordpress.org/support/users/andrea_r/)
 * (@andrea_r)
 * [15 years, 9 months ago](https://wordpress.org/support/topic/super-admin-problem/#post-1572520)
 * > and made sure my username was listed in site_admins in wp_sitemeta. It is, 
   > though I don’t know what the other numbers and code in there means.
 * Paste it in here, and I’ll tell ya.
 *  [satomom](https://wordpress.org/support/users/satomom/)
 * (@satomom)
 * [15 years, 9 months ago](https://wordpress.org/support/topic/super-admin-problem/#post-1572521)
 * Hi, Andrea –
 * Here you go:
 * `a:1:{i:2;s:11:"username";}` (where ‘username’ is my admin username)
 * Any ideas?
 *  [satomom](https://wordpress.org/support/users/satomom/)
 * (@satomom)
 * [15 years, 9 months ago](https://wordpress.org/support/topic/super-admin-problem/#post-1572522)
 * I’m also noticing I can’t add or change the status of users, like I typically
   could with regular admin privileges.
 *  [satomom](https://wordpress.org/support/users/satomom/)
 * (@satomom)
 * [15 years, 9 months ago](https://wordpress.org/support/topic/super-admin-problem/#post-1572523)
 * Found the answer here:
 * [http://wordpress.org/support/topic/406599](http://wordpress.org/support/topic/406599)
 *  [Andrea Rennick](https://wordpress.org/support/users/andrea_r/)
 * (@andrea_r)
 * [15 years, 9 months ago](https://wordpress.org/support/topic/super-admin-problem/#post-1572524)
 * > a:1:{i:2;s:11:”username”;} (
 * see the i:2 ? It shoudl be a 1 since there’s only one username following. not
   two.
 * and the s:11 – the 11 should be how many characters are in your username.

Viewing 9 replies - 1 through 9 (of 9 total)

The topic ‘Super Admin problem’ is closed to new replies.

## Tags

 * [admin](https://wordpress.org/support/topic-tag/admin/)

 * In: [Networking WordPress](https://wordpress.org/support/forum/multisite/)
 * 9 replies
 * 3 participants
 * Last reply from: [Andrea Rennick](https://wordpress.org/support/users/andrea_r/)
 * Last activity: [15 years, 9 months ago](https://wordpress.org/support/topic/super-admin-problem/#post-1572524)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics