Admin locked out

  • boopdoop1234

    (@boopdoop1234)


    2 years, 10 months ago

    I am having issues with my admin account. When I attempt to login to wp-admin it states: “User has not been activated”.

    Backstory: My SSL/security settings were giving me a warning to not have an “admin” named account, so I renamed the account. This immediately logged me off, and now I think WP-Members (due to the name change) does not see it as an activated account. I am now unable to login to my WordPress.

    I was wondering if there is an easy way to activate the account through CPanel? I don’t see an SQL database for WP-members, but maybe there is an attribute in the usernames or usermeta table to do this?

    Thanks for the help.

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Chad Butler

    (@cbutlerjr)

    2 years, 10 months ago

    Backstory: My SSL/security settings were giving me a warning to not have an “admin” named account, so I renamed the account.

    “renamed”? Or created a new one? The reason for the question is that (1) the plugin automatically activates the admin account that enables moderated registration (specifically so that you don’t lock yourself out), and (2) that’s a user meta field that is tied to the user ID (not the login). If you changed the ID (the numeric primary key in the DB), then all the user meta attached to that ID no longer belong to that user.

    I don’t see an SQL database for WP-members, but maybe there is an attribute in the usernames or usermeta table to do this?

    It’s a user meta field. If you add a user meta for the specific user ID with the meta_key = “active” and meta_value=1 that will recognize the user as activated.

    There’s also a code snippet you can drop in to always view a user with the “administrator” role as activated:

    Always view admin as activated (rocketgeek.com)

    Thread Starter boopdoop1234

    (@boopdoop1234)

    2 years, 10 months ago

    Thanks for the help! That worked (adding the metakey active). If you are curious about specifically how this might occur (for your own troubleshooting in the future):

    • The SSL plugin has a warning for users named “admin”.
    • Since WordPress does not allow you to rename the main admin account, it provides an option in the SSL plugin to rename it for you.
    • Once this is done, it seems to de-activate the account in WP-Members.

    I was able to reactivate it, as you have set out above, by adding the metakey for active.

    • This reply was modified 2 years, 10 months ago by boopdoop1234.
    Plugin Author Chad Butler

    (@cbutlerjr)

    2 years, 10 months ago

    It sounds like the SSL plugin creates a new user. If it simply renamed the account, I would expect it to have the same ID and therefore carry over any user meta fields.

    Glad you were able to get it resolved, though.

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

The topic ‘Admin locked out’ is closed to new replies.