Delete Users and reset user IDs

  • Resolved parade

    (@parade)


    13 years, 8 months 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.

Viewing 1 replies (of 1 total)
  • Bas Schuiling

    (@basszje)

    13 years, 8 months 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?

Viewing 1 replies (of 1 total)

The topic ‘Delete Users and reset user IDs’ is closed to new replies.