ZachIT

I’m running wordpress multisite (3.13) and wanted to change the SiteAdmin login name for security reasons.

Changing the login name was pretty straightforward and there are a bunch of blogs that document how to do this. Basically, via sql (phpmyadmin) — update user_login in the wp_users table.

However, after changing the login name the account is no longer recognized as a SiteAdmin. As a result all access to the Network Admin area was lost and I was locked out of managing the multi-site features.

Poking around a bit more in the wordpress db I found these interesting entires in the site_meta table:

• Meta_key = site_admins
• Meta_value =  a:1:{i:0;s:5:”admin”;}

Tinkering around a bit more I was able to get my Network Admin access associated with my renamed SiteAdmin account by modifying the Meta_value:

• Meta_value =  a:1:{i:0;s:10:”fish-admin”;}
• Note: ’s:10′ is the length of the string that contains the login name. In this example the length of “fish-admin” is 10 so I modified accordingly.

There you have it. Leave me a comment if you have any questions.