Have set my database and it was the perfect database I have ever designed(perhaps) but how about trying to edit the columns?
Here is the code:
alter table account modify `id` int(11) NOT NULL AUTO_INCREMENT;
Note: the id column is bigint(9) before the transformation.