Ghost Administrators, How to remove them safely

  • Alison

    (@anonymical7)


    7 years, 3 months ago

    Hello, on our site I noticed the users show 5 admins, but when listing them it only gives two admins. It may be these are old admins that are not removed completely from the Database, but to be safe in security I would like to remove them asap. How can we remove admins safely from the database?

    Thanks, A x**

Viewing 4 replies - 1 through 4 (of 4 total)
  • Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    7 years, 3 months ago

    IF there’s a miscount, check wp_usermeta against wp_users, looking for users that exist in usermeta that are not in users. I’ve seen this in sites that have been hacked or were involved in a database crash.

    If there’s a record in usermeta that does not point to a valid user in users, you can delete that record.

    Thread Starter Alison

    (@anonymical7)

    7 years, 3 months ago

    Thanks Steve, where do I find this info? In myphpadmin?

    🙂

    Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    7 years, 3 months ago

    phpmyadmin is a good place to start. Follow the user_id field from usermeta back to users. Don’t mess with this if you don’t understand foreign keys!

    Thread Starter Alison

    (@anonymical7)

    7 years, 3 months ago

    I found it, thanks!

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Ghost Administrators, How to remove them safely’ is closed to new replies.

Tags