Thread Starter
iwolf
(@ruud-axe)
Anyone? it’d really help me out. I took a peek as the other user i added but he didnt change into the admin so not sure what to do now?
The only thing I can think of is to go into the database and change the user’s level. I can’t remember the table or column name for the life of me, but I know it’s there, I’ve had to do it myself once or twice.
Thread Starter
iwolf
(@ruud-axe)
Thanks for your reply Jerry. I did go to my phpmyadmin and found -onder wp_usermeta: a:1:{s:6:”editor”;s:1:”1″;} . I’m tempted to change the “editor” into admin, but it might be more complicated than that and am afraid to mess up.
I don’t think it’s the user-meta data, let me go to my desktop and I’ll tell you exactly what to change. Worst case, I’ll do the same thing on my test server and fix it.
Thread Starter
iwolf
(@ruud-axe)
If you could do that, cheers!
Okay, seems it’s been awhile since I’ve had to do this haha. Anyhow, in the wp_usermeta table change wp_capabilites to:
a:1:{s:13:"administrator";s:1:"1";}
Also change wp_user_level to 10
That should do it, let me know.
Or maybe add another admin user: http://www.dnawebagency.com/how-to-add-an-admin-user-to-the-wordpress-database
With the new user change your old admin role back to admin and delete the new user.
That’s a little bit excessive, though should work also. Simple edit would be just to edit a specific user’s metadata based off of his/her user_id, which is default of 1 considering it’s the default administrator.
Thread Starter
iwolf
(@ruud-axe)
Thanks keesie for the alternative strategy but the usermetawatchamacallit worked! This made me very happy, i can’t tell you. 🙂 Thanks for your help, Jerry. Much appreciated!
Not a prob. Have a good day 🙂
