Custom user id starting at 10000 (10.000)

  • Resolved Menno1987

    (@menno1987)


    9 years, 8 months ago

    I’m trying to change the default user ID count to start at 10.000 instead of 1. I’ve already been looking online for a few hours now, but i can’t seem to find a solid answer to my question.
    I have also tried changing the user ID from the first two accounts manually in phpmyadmin, but the next account that’s created got a ID of 101 …

    I need the first user account ID to be 10.000, and count onwards from that number.

    Any help on the matter would be much appreciated.

    P.s. I.m a media developer student, so i know my way around code a bit ??

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

  • I doubt that you will be able to change the ID of existing accounts, and if you do by just getting into the database you will create all sorts of grief like orphaning posts/pages and anything else they created or edited.

    As for changing the ID base for NEW users, suggest that you EXPORT your database tables, edit the .sql file, find the block which gives the structure of the <prefix>_users table, at the end of the block is a line with a “AUTO_INCREMENT” setting, adjust it to your new starting value, like:
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=10000 ;
    Then reload this table. (or all the tables).

    Thread Starter Menno1987

    (@menno1987)

    Thanks for the reply, but it’s already solved. I’ve eventually found this tutorial below:

    https://www.wpwhitesecurity.com/wordpress-security/change-wordpress-administrator-id/

    I’ve changed the only existing ADMIN account to 9999, and created a customer (woocommerce) test account, and automaticly got the user ID of 10.000

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Custom user id starting at 10000 (10.000)’ is closed to new replies.