Accidently changed my role from admin to —

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.

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.

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: https://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.

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 ??

cheers. you too