Change a WordPress user from editor to admin in PhpMyAdmin

A web consulting agency recently took over my admin account essentially locking me out of a website. Fortunately, if you have access to the database via a tool like PhpMyAdmin, you can easily get back in.

First open the wp_users table for the WordPress you wish to access. Look for your account and note down the user ID number:

user-ID

Note: If you don’t have an existing account, you will need to create a new one. (You can check this article on how to do it.)

Next, access the wp_usermeta table and look for your ID number.

In the meta_key field wp_capabilities,
add this meta_valuea:1:{s:13:"administrator";s:1:"1";}

Save and exit and you should now be an administrator again.

More infohttps://themeisle.com/blog/new-wordpress-admin-user/

  1. No comments yet.

  1. No trackbacks yet.