how to auto_increment in mysql using terminal code example

Example: auto_increment mysql

ALTER TABLE User AUTO_INCREMENT = 1;