系统：阿里云
输入：show variables like ‘character_set_%‘;
输入：alter database dbname default character set utf8;
输入：vi /etc/my.cnf
在黄色区域添加如下代码：
default-character-set=utf8 [client] default-character-set=utf8
输入：service mysqld restart
输入：show variables like ‘character_set_%‘;
原文：http://www.cnblogs.com/geekdc/p/5980533.html