How to set all auto increments to 1 in a Schema
If the tables already have rows, you can't do it.

If you want to throw away all the data, then you could do TRUNCATE TABLE for each table.

Or you could get all the table definitions via mysqldump --no-data and make sure there are DROP TABLE for each.  Then have a script that runs the output.