How to change collation of database, table, column in mysql

You need to either convert each table individually:

ALTER TABLE TABLE_NAME CONVERT TO CHARACTER SET utf8

(this will convert the columns just as well), or export the database with latin1 and import it back with utf8.