Title: User’s ID counter
Last modified: August 18, 2016

---

# User’s ID counter

 *  stefano-st
 * [21 years, 6 months ago](https://wordpress.org/support/topic/users-id-counter/)
 * I’ve a problem about user’s id and, in general, WordPress database’s ids… I try
   to explain it..
    I’ve manually deleted from the database an user and then added
   another one… The last user’s id (before being deleted) whas 3 … After deleted
   it there was only two user: the number 1 and the number 2. When I added the new
   user (from admin panel) its id was 4 (even if the higher id number in the user’s
   table was 2)… I suppose there is a id counter that keep trace of every new user
   and is incremented every time we register a new record… But where is it? Thanks

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

 *  Thread Starter Anonymous
 * [21 years, 6 months ago](https://wordpress.org/support/topic/users-id-counter/#post-106067)
 * I already use phpmyadmin to modify manually my database,
    but I wonder where 
   the counters of database’s ids are stored, so that i can decrease it… If WordPress
   is set to auto increment ids, it must keep trace of them somewhere… S.O. can 
   help me? Thanks!!!
 *  [Cypher](https://wordpress.org/support/users/cypher/)
 * (@cypher)
 * [21 years, 6 months ago](https://wordpress.org/support/topic/users-id-counter/#post-106072)
 * I think you misunderstood charle97’s response. WordPress do not remember the 
   user-id’s.
    MySQL which is the database software providing the backend support
   has a feature of certain numeric fields that is called “auto_increment”. This
   means that the code does need not have to worry about looking up the previous
   value of the user_id and then incrementing it before saving entries the user 
   table. Just creating a new user entry in the table auto increments the ID. This
   is ALSO the same mechanism used for the Post ID, you will find that if you create
   a post and then delete it and create a new one, the new post will be one more
   than the deleted post. ID’s do not get re-used. In virtually all cases, these
   ID’s are internal to WordPress in how they are used and should have no consequences
   on the outward appearance and function of your Blog. Having said all that, having
   deleted user #3 and created user #4, there is NO benefit in changing the new 
   user’s ID back to #3. If anything that might cause issues. So unless you have
   a real need to be changing the IDs that are automatically maintained, I would
   just let it be. Regards
 *  Thread Starter Anonymous
 * [21 years, 6 months ago](https://wordpress.org/support/topic/users-id-counter/#post-106078)
 * Ah, sorry for misunderstanding. Now i understand what you mean.
    Thanks for answering.
   Regards

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

The topic ‘User’s ID counter’ is closed to new replies.

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 3 replies
 * 2 participants
 * Last reply from: Anonymous
 * Last activity: [21 years, 6 months ago](https://wordpress.org/support/topic/users-id-counter/#post-106078)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics