Search code examples
mysqlphpmyadminauto-increment

phpmyadmin is no longer letting me set auto_increment value

I used to be able to set the auto_increment value in phpmyadmin->table->operations, but I no longer see it in this box:

http://puu.sh/4dhf4.png

It used to be right under there, yes my table has an auto_increment field. I'm using phpmyadmin 4.4.0, and I already tried switching from InnoDB to MyISAM. I'm logged into phpmyadmin with root.

Solution

  • I'm not sure why they removed this feature, but the way to do this "old school" is to click on the SQL tab and then run the following MySQL command:

    ALTER TABLE `sessions` auto_increment = 12345

    This would set the auto increment counter to 12345 (or to one more than the highest value already in the 'sessions' table).