You may have tried to change your wordpress username in phpadmin and found that you no longer have the Network Admin option on the Dashboard menu. If you did, you need to check with the procedure below and see if you followed it correctly, to change your multiuser admin username:
In Phpmyadmin,
Edit the follwing:
wp_users table:
Find the row corresponding to “ID” of 1. On the same row, edit the user_login field and change “admin” to a new user name.
wp_sitemeta table:
Find site_admins field containing the string “admin“.
It may be like:
a:2:{i:0;s:6:"totaluser";i:3;s:5:"admin";}
Note that the 5 just before admin is the character count of admin. So you need to change admin to your new user name, and substitute 5 by the new character count of your username.
There, that’s it! Now you’ve successfully changed your admin username and thus hardened your wordpress installation a bit further. If you need to secure it further, pick an alphanumeric long username, and a very long password containing alphanumerics and special characters.
To drive home the point, I will reiterate. If Network Admin menu is not visible under “My Sites” on WordPress, the main thing you need to check is whether your username and its character count are correctly set in the table wp_sitemeta, field site_admins.
Three cheers to [email protected] for his post regarding this.
Joel G Mathew, known in tech circles by the pseudonym Droidzone, is an opensource and programming enthusiast.
He is a full stack developer, whose favorite languages are currently Python and Vue.js. He is also fluent in Javascript, Flutter/Dart, Perl, PHP, SQL, C and bash shell scripting. He loves Linux, and can often be found tinkering with linux kernel code, and source code for GNU applications. He used to be an active developer on XDA forums, and his tinkered ROMS used to be very popular in the early 2000s.
His favorite pastime is grappling with GNU compilers, discovering newer Linux secrets, writing scripts, hacking roms, and programs (nothing illegal), reading, blogging. and testing out the latest gadgets.
When away from the tech world, Dr Joel G. Mathew is a practising ENT Surgeon, busy with surgeries and clinical practise.