WordPress.org

Ready to get started?Download WordPress

Forums

[resolved] Changing user ID auto-increment number in MySQL? (3 posts)

  1. Cristobal
    Member
    Posted 8 years ago #

    Greetings!

    I have (and all of us have) a table called wp_users. There is a cell in this table called "ID". It has an auto-increment option. Can you help me and tell how can I change the last number of this auto-increment option.

    For example, I have 14 real users. When I tested my site I created 5 test-users (just fakes). So the last user (fake-user) had an ID equal to 19. Then I deleted them. And now if somebody wants to register, he will get an ID equal to 20. But I want him to get an ID equal to 15.

    Where I can find the number which is used by auto-increment option in MySQL? Or how can I reset this number?

    Thanks!

    Vladimir

  2. ifelse
    Member
    Posted 8 years ago #

    You can find out more information on auto_increment including how to reset them by having a look at my posts in this thread.

  3. Cristobal
    Member
    Posted 8 years ago #

    Ifelse, thanks a lot! Problem was solved by this command:

    ALTER TABLE wp_users AUTO_INCREMENT = 15

Topic Closed

This topic has been closed to new replies.

About this Topic