WordPress.org

1. pwizard
   Member
   Posted 9 months ago #

   I went into phpmyadmin and changed my site admin user name from "administrator" to something else. I searched the entire mysql databases and found only 2 references to the administrator username, so I changed both of them.

   Then I logged into wordpress. On the top right where it says "howdy" and my name, clicking that, I cannot see "NETWORK ADMIN". So as a super admin, I can log into each blog, but I can't get network access (to do the plugins and other admin stuff)

   I went back into the databases and renamed them back, and all is fine.

   So I am wondering why the new username did not work?

   The two tables are wp_usermeta, which had

   8, 1, 'site_admins', 'a:1:{i:0;s:8:"original-admin-name";}'),

   and wp_users.
   (1, 'original-admin-name', 'xxxx.', 'Vin', 'vin@myemail.com', '', '2011-08-01 17:00:28', '', 0, 'Vincent', 0, 0),

   So if I just changed those 2 admin names, why should I not be able to log in to network?

   There must be someplace else this data is passed through from - perhaps a file?

   any help would be appreciated

   v

2. Jackson
   Member
   Posted 9 months ago #

   The wp_usermeta entry is serialized. So if you change the length of the string it gets corrupted.

   'a:1:{i:0;s:8:"original-admin-name";}'

   That doesn't work because "original-admin-name" is a string longer than 8 characters

   You could also just create a new user for yourself and make them a site admin. Then log in as the new user and delete the old, reattributing all posts to the new user.

Reply

You must log in to post.