unable to access network admin of a blog

The problem was that the username of the super admin was changed and this did not reflect in other blogs of the system. The below query solved my problem,

update wp_sitemeta set `meta_value` = 'a:1:{i:0;s:6:"adminusername";}' where `meta_key` = 'site_admins'

and

update wp_sitemeta set `meta_value` = '[email protected]' where `meta_key` = 'admin_email'

Related Posts:

  1. Add additional Network constants to wp-config.php dynamically
  2. How do I change the Multisite URL?
  3. Post and Page Inheritance to subsites in a WordPress Network
  4. Roles other than Super admin accessing manage_network_themes
  5. How to add super admin to all sites
  6. Listing of all site options in dashboard
  7. Multisite: How to store global options vs. site options?
  8. Single-user registration to access all sites in WordPress MultiSite Network
  9. WPMU vs WordPress MultiSite is there a difference anymore?
  10. Generate a user list per site to communicate upgrade plans
  11. Timeout While Upgrading Network in Multi-site
  12. “Upgrade Network” error: stuck with SSL certificate verification
  13. Add new domain to ‘My Sites’ using network admin
  14. Favicon plugin for WordPress running in network mode (multisite)? [closed]
  15. No Network/Super admin after enabling Network
  16. Problem in Internationalizing a plugin built for network level usage
  17. Multisite network admin – URL / redirect error
  18. Change Username?
  19. Why does the My Site dropdown show only a single domain?
  20. WP Multisite – domain mapping to domain.com and separate site to domain.com/help
  21. Is there a way to run upgrade.php for one blog?
  22. Include only a domain path in multisite Network
  23. Possible to enqueue scripts and CSS to Multisite Network dashboard?
  24. Adding new sites to Multisite won’t register in Dashboard
  25. WordPress Network admin options page: how to store options and where will they be stored?
  26. Multi-Site Subdomain: Show master site under subdomain if no sub site exists
  27. How to force change Network site multi language subdirectory base URL?
  28. Merge Multisites with Shared Network Media Library
  29. Multisite Subdirectory with same domain subdomain
  30. How to create a Multi-Network subsite?
  31. Create Custom Multisite User Role to Reduce Capabilities
  32. Renaming admin user on multisite install by MySQL
  33. HTTPS Warning and Certificate Error when Updating Network
  34. Multisite, with virtual root
  35. How to exclude specified from all list of Multisite
  36. How to wordpress multi site [closed]
  37. Network of multisites in WordPress, create new site with all the contents of the main
  38. How do I check if the user is a site owner in a network?
  39. Locking one blog of many in a multi user/blog WordPress installation
  40. Programmatically creating site in a network
  41. switch_to_blog() not functioning while querying post_types, Why?
  42. WordPress Multisite with subdomains on different domains
  43. Can’t create a subdomain network – and WP is installed in webroot, not a folder
  44. How to have one installation at blog.example.com and multiple blogs in sub folders such as blog.example.com/userA?
  45. Forward and mask a WordPress website
  46. WordPress multisite with same content
  47. Can I use the same Folder name as a Multisite Blog?
  48. Website not listed under Sites (in a Network environment)
  49. Sites network with sub-folders
  50. How can I create network with different domains?
  51. multisite – unable to connect to network administration
  52. Add Network Sites are not working
  53. Getting stylesheet error after setting subdomain to false in multisite
  54. Admin users not able to see network menus
  55. How to hold posts and accounts for moderation on WordPress Network site
  56. My Sites link in multisite is incorrect
  57. Multisite network admin login redirect
  58. Multisite network subdomains doesn’t work
  59. Cannot enable WordPress Network – ‘MULTISITE’ already defined and false
  60. Change header.php of a specific WordPress Multisite
  61. Modify new user email notification in network admin screen wp multisite
  62. the menu of the network does not display my second website
  63. WordPress Multisite – Auto enable theme
  64. Issue when transforming an existing site to multi-site with subfolders setup
  65. network admin pages not linked to correctly
  66. How to split database of WordPress multi-site network into multiple database
  67. Move two independent sites to network
  68. How to configure CNAMES to be part of a WordPress Network
  69. Cannot access network admin panel on multi site
  70. How to apply specific plugins to affect all sites (Multisite Network)
  71. Admin user getting redirected to /wp-admin/user
  72. Getting 404 after Update in Multisite
  73. 4th Network Site Database Errors?
  74. Can admins on network install view and edit users accounts?
  75. How to display update message only to admin
  76. How to disable admin access on new site registration for user in Multisite?
  77. WordPress Multisite (Network) some site users added to main site users list as subscriber
  78. WordPress Multisite with multiple domains using Nginx
  79. How do I fix problems with users not being able to publish and only submit for review after upgrade of Multisites installation?
  80. subdomain archiving
  81. How to change the database prefix in multisite (WPMU) install
  82. Getting blank thumbnails in media library?
  83. Accessing multiple sites via FTP
  84. Multiple homes for multiple languages [closed]
  85. Multiple install for multilanguage. How to?
  86. Multsite redirecting to the main site
  87. How to make a php script(app) accessible to all wordpress subdomains in a wordpress multisite configuration?
  88. Multisite with 220+ sites painfully slow
  89. WordPress Mulitisite – Unable to create directory
  90. Multisite Login problem
  91. Multisite subdomain-site redirects to primary site
  92. Seeking solution to sync wordpress sites with Server
  93. Multisite with Different URLs on Local Server
  94. Applying Child Theme to another site, which has its own URL
  95. After cloning my WordPress database to another server, I cannot log in
  96. How can I have different langauges in wp-admin on a multisite installation?
  97. Multisite: should /blog go to a 404 page?
  98. why i cannot see some plugins while they are enabled on network admin page?
  99. Create service similar to wordpress.com [closed]
  100. WPML is blocking WP core update