Resetting user access of main admin account

  • 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

Viewing 2 replies - 1 through 2 (of 2 total)

  • 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.

    Note that database backups are a wonderful thing!

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Resetting user access of main admin account’ is closed to new replies.