How to reset member ID numbering?

I've been doing testing on a test site and want to make it live now.

But all the members ID are at a higher number now.

How do I reset and restart the member ID numbering from no. 2? (after admin)

After you delete all the test memebers then:

1. Login Cpanel or your control panel of choice

2. Click phpmyadmin

3. Click the dolphin database name on left

4. Click the "profiles" table

5. Click "operations" at the top

6. Change "auto_increment" to 2

7. Click "Go"

make sure no user is there except admin otherwise you will get lots of headache....:)  

Thanks mscott!!!!

That was super detailed!!

Thanks Prashank for the extra tip too!!

No problem, glad to help.