Needed to do this and had to google around for it, so, here it is for ease (hopefully!) You can reset an auto_increment field in mySQL by using the following syntax:

alter table tablename auto_increment = #;

Where # is an integer value.