How to Reset Auto Increment in MySQL

I have a database table with a auto increment column for primary key. Over time the rows being add and delete many times, and the auto increment value became scattered. If you want to reset the auto increment counter, follow the instruction below.