ALTER TABLE `tbluser` MODIFY `userid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17; COMMIT; code example
Example: how to change the auto increment in existing table mysql
ALTER TABLE tbl_access ADD COLUMN `access_id` int(10) NOT NULL PRIMARY KEY AUTO_INCREMENT FIRST