In phpmyadmin, just click the SQL tab, enter the command, and run it.įor a nonempty table, you may want to adjust the auto_increment attribute to the highest existing id in use in case higher entries were deleted.įirst, optimize the table OPTIMIZE TABLE mydb.mytable If you want to hose the data, then be my guest. Since this one of the most frequently asked questions for phpmyadmin, you can learn more about this in this blog : Supplemental Infoįor an empty table, another way to reset the auto_increment attribute is to run TRUNCATE TABLE mydb.tablename ĭon't run this if you have data in it. Click on the Go button for the Table Options box.Enter the new auto_increment starting value.In the Table Options box find the auto_increment field.

In phpMyAdmin, click on the table you want to reset or change the AUTO_INCREMENT value.3: In the left column, select the database. Perhaps you could just select the phpMyAdmin Operations tab: 2: Navigate to the SQL Services section (WHM > Home > SQL Services) and click phpMyAdmin.

Phpmyadmin delete database entry