Change user ID

  • KatrineDS

    (@katrineds)


    4 years ago

    Hi,

    A client of mine needs to change the user ID’s because of a conflict in user ID numbers and his financial system. Anyways – is there a way to change these for new users forward?

    Like there is a ‘Sequential Order Number’ plugin, where you can set the format and next number? It doesn’t have to be a plugin – perhaps some custom functions stating that the NEXT user ID should be, lets say, 2000 and then 2001 etc….

    I’ve searched for hours and can’t find a solution – so help would be appreciated.

Viewing 2 replies - 1 through 2 (of 2 total)
  • Moderator bcworkz

    (@bcworkz)

    You can set the next assigned ID value through the phpMyAdmin app, usually accessed through your hosting account. Navigate to the users table. In the operations tab, under table options, set the AUTO_INCREMENT value to (almost) any integer larger than the one shown. There is some maximum value, I’m unsure what it is, but it’s very large, 2^64 less the anticipated new user count maybe.

    Thread Starter KatrineDS

    (@katrineds)

    Awesome! Thanks… Would never have looked there….

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Change user ID’ is closed to new replies.