I spend a lot of time under-the-hood of sever Open-Source, web platform (I.E. WordPress and others). I often see people asking about how to change the auto-increment number in MySQL.
Those who know what they are looking for, can find this information by reading the MySQL documentation or searching the internet. However, if people are searching the internet for this issue, then why not find the answer on my website?
The command is quite easy.
It can be run from the command line by using the following command:
mysql> ALTER TABLE table_name AUTO_INCREMENT = start_number
If you are using phpMyAdmin, you will use the same command, but will not see the mysql prompt:
ALTER TABLE table_name AUTO_INCREMENT = start_number