It is easy to rename a column in MySQL.
To change the column name of a varchar(255) field from carmaker to manufacturer in the cars table
ALTER TABLE cars CHANGE carmaker manufacturer varchar(255);
ALTER TABLE tablename CHANGE oldname newname datatype;
More information can be found in the MySQL manual.