WordPress.org

Ready to get started?Download WordPress

Forums

[resolved] Delete Users and reset user IDs (2 posts)

  1. parade
    Member
    Posted 1 year ago #

    Hello all,

    How do I delete all users (subscriber) on my wordpress site and change my account (administrator) userID on the database to "1" as it is currently 32. Can I just select all account on phpMyadmin and delete them and then change my ID by editing it to "1"?

    Those subscriber do not have any post or comment so I do not need to worry about keeping their post etc.

    I would also want to reset the userID increment to start from "2" instead of 43

    Any help will be much appreciated.

  2. Bas Schuiling
    Member
    Posted 1 year ago #

    You can't reset increments when a field is set to AUTO_INCREMENT. I suggest ( make a backup first! ) you drop the user table and then recreate it. That would make the increment reset and delete all users. You'll have to manually add the admin account again. Please watch out as this will shut you out of your site. You'll also have to redo permissions for admin in the options table (if I remember correctly )

    As a last thought: why would you want to do this?

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags

No tags yet.