How to convert your latin1 mysql table to utf8

Convert the existing columns content if there are unicode characters saved in non utf8 column:

Have MYSQL loop through . all of your tables and columns finding all the necessary columns which have types needing to be converted:

You will get queries like these which can be ran:

Then we update the each tables overarching settings. We run this to get the queries for the tables:

That will give us something like this to run (I added the SET foreign_key_checks around the ALTER TABLE queries:

Now we can set the encoding and collation default for the database as a whole: