WordPress.org

Ready to get started?Download WordPress

Forums

Resetting user access of main admin account (3 posts)

  1. Pedanticus
    Member
    Posted 4 years ago #

    I was using Web Shop and adjusting the email address in their user panel. When I saved the changes it changed the admin setting from Administration to Subscriber, effectively locking me out of the backend of my website.

    I am desperate to change the access level and have been into the PhpMYAdmin backend and can find the user table but not sure which part sets the access level as it is not clearly labeled.

    Can someone please help me as this is a major issue given that I've done a lot of promotions for products this weekend.

    Thanks

    Hayley

  2. MichaelH
    Member
    Posted 4 years ago #

    Use phpMyAdmin and look for your wp_usermeta table, then look for the wp_capabilities record for your admin user (you may need to look at wp_users to get the correct user id) then set the value to:

    a:1:{s:13:"administrator";b:1;}

    If your usermeta table is called wp123_usermeta, then the capabilites record for each user will be have meta_key of wp123_capabilites. The wp123_ is your $table_prefix in your wp-config.php file.

  3. MichaelH
    Member
    Posted 4 years ago #

    Note that database backups are a wonderful thing!

Topic Closed

This topic has been closed to new replies.

About this Topic