MySQL multi-instance-Classical fault case

A long time ago to build a multi-instance of MySQL, remember that was very smooth, hehe! Today the company because of business needs, I set up a multi-instance. After MySQL is installed, when initializing two instances, the following error occurs:

150915 1:10:36 [ERROR] COLLATION ' utf8_general_ci ' is not valid for CHARACTER SET ' latin1 '
150915 1:10:36 [ERROR] Aborting

At first glance, it is a character encoding problem, indeed the MY.CNF configuration file is set above the character encoding as follows:

[Client]

Default-character-set = UTF8

[Mysqld]
Character_set_server = UTF8

Save exit, try initializing again, and the following error appears:

150915 1:53:38 [Note] Server hostname (bind-address): ' 0.0.0.0 '; port:3306
150915 1:53:38 [Note]-' 0.0.0.0 ' resolves to ' 0.0.0.0 ';
150915 1:53:38 [Note] Server socket created on IP: ' 0.0.0.0 '.
150915 1:53:38 [ERROR] Fatal Error:can ' t open and Lock Privilege tables:table ' mysql.host ' doesn ' t exist

Through a pass to find the data, and then analyze the above two lines, as follows:

150915 1:53:38 [Note] Server hostname (bind-address): ' 0.0.0.0 '; port:3306
150915 1:53:38 [Note]-' 0.0.0.0 ' resolves to ' 0.0.0.0 ';

It suddenly occurred to me that this machine was previously used to test the project and modified the hosts file. The Hosts file is then opened to remove the added hosts map, leaving the default, save to exit.

I'm sure someone will ask me how this error is not resolved, as follows:

150915 1:53:38 [ERROR] Fatal Error:can ' t open and Lock Privilege tables:table ' mysql.host ' doesn ' t exist

This problem, re-initialize the system database, you can.

Oh, initialization success, start success!!!!

MySQL multi-instance-Classical fault case