A detailed explanation for setting up the character set problem based on Mysql 5.5 _mysql

Install a MySQL on the virtual machine, modify its my.cof file, found that this configuration file is very powerful, but encountered a problem:

When you set up the character set, you set up the Default-character-set=utf8 under [client], [MySQL], and [mysqld], but the following problems occur:

One after the investigation, found in [Mysqld] under the set DEFAULT-CHARACTER-SET=UTF8 caused. To view/var/lib/mysql/${hostname}.err files:

The problem is that MYSQLD does not recognize Default-character-set. On the Internet to check some information, found in the mysqld under the Character_set_server=utf8 to be set.

View Character set: Showvariables like ' character% ';