Reset Super Admin Credentials

If you have access to the database (via phpMyAdmin for example) you can find out both the username and change the password. The password must be encrypted however. This codex page explains the process: https://codex.www.ads-software.com/Resetting_Your_Password#Through_phpMyAdmin

The page also contains other possible solutions in case you want to try those instead.

Thanks Sebastian

I’ve already seen this codex page, but it’s useful to know I was looking in the right place ??

I favour using phpMyAdmin, so when I’m in the database, “structure > wp_users”, how do I identify the Network Admin from here?

We have two sites set up, but I can see the nicknames and login id’s of only one site’s admins. Should we able to see both sites users?

If we should, what would cause them to disappear? Is there any way to re-create them.

I’m not too worried about the admins, but I really do need to get the Network Admin back. Do you think there would be a method of doing this?

Thanks again.

Regards,

Mel

All depends on how you’ve set it up, but if you look in the table wp_sitemeta you should see your admins’ names, in the row with meta key “site_admins”. For example if you have one admin and he is named “admin”, it will be in the form of a:1:{i:0;s:5:”admin”;}

Make a database backup before you proceed. Then look up that user in the wp_user table (it *should* be the one with id 1, anyway). Try to change that user’s password, click edit on the row, enter a new password in the password field, then next to it select the function “MD5”, and save. Next try to log in with that user. If you land in your site instead of your network dashboard, manually go to yourdomain.com/wp-admin/network.php and log in there with the same credentials. If that works you should be able to set up new users from there if you need to.

Hi Sebastian,

Thanks for coming back to me so quickly!

We’ve had some web developers working for us, they took an offline copy of our WP database to work on. In the meantime I had set up the multi-site configuration and created some blogs for it.

What I think has then happened, is, when the developers had finished their project, they carelessly copied their offline copy database over our live one. Hence the missing users.

We needed the Network Admin, because we couldn’t change/add themes/plugins. I’ve since reverted the multi-site back to a single site following, https://blog.ashfame.com/2010/07/remove-wordpress-multisite-data/ and I’ve got control back again.

I’ll look again at WP multi-sites later in the year when things stabilise here.

Thanks again for your input it was really appreciated.

Kind regards,

Mel

Thanks For helping! it’S Working!

Below there is two article and it make no sense.

Super Admin problem

Recover super admin access after username change?

Before you start working make sure you backwps your database

1 step: Go to phpmyadmine
2 step: go to wp_sitemeta and change your admin mail and admin usur

3. step: Go to wp_usur change your usur login usur pass and usur mail

walla!

Chake your website!