MySQL reset auto increment

 How to reset auto increment value in MySQL?

Answer

Auto-increment allows a unique number to be generated automatically when a new record is inserted into a table

Use this Statement to reset auto increment value to 1

ALTER TABLE users AUTO_INCREMENT=1;

solved