[FIXED] MySQL auto_increment not reseting (stuck on increment by 10)

Issue

So running MySQL Version 5.5.42-cll

My tables wherever auto_increment are refusing to reset, they're all incremented by 10 and not by 1. Tried changing it in phpmyadmin and no luck.

Tried following statement but it didn't work:

ALTER TABLE tablename AUTO_INCREMENT = 1;

Has anyone had this issue before? I can't truncate the tables as they have a lot of data, I also know that the +10 probably isn't a big deal, but I expect these tables to get large and would rather keep the numbers low and clean.

Any help would be great please

Solution

In phpMyAdmin, log in as a privileged user, go to home page, Variables, type "increment". Then for "auto increment increment", click on Edit, set it to the value you wish (1) and Save.

Answered By - Marc Delisle