vi /etc/mysql/mysql.conf.d/mysqld.cnf
[client] default-character-set=utf8 [mysql] default-character-set=utf8 [mysqld] init_connect=‘SET collation_connection = utf8_unicode_ci‘ init_connect=‘SET NAMES utf8‘ character-set-server=utf8 collation-server=utf8_unicode_ci skip-character-set-client-handshake
原文：http://www.cnblogs.com/justbreaking/p/7104454.html