ITPub博客

HOW TO SOLVE ERROR 1062 (23000) ?CAUSEa)ERROR 1062 (23000): Duplicate entry '0' for key 'PRIMARY'b)ERROR 1062 (23000): ALTER TABLE causes auto_increment resequencing, resulting in duplicate entry '1' for key 'PRIMARY'SOLUTIONa)ALTER TABLE `animals` CHANGE `id` `id` MEDIUMINT UNSIGNED auto_i...

How to Reset the MySQL Root Passwordhttp://dev.mysql.com/doc/refman/5.6/en/resetting-permissions.htmlcat /etc/my.conf...[mysqld]##add parameter##skip-grant-tables