修改 /etc/mysql/my.cnf 文件
[client]
default-character-set=utf8
[mysql]
default-character-set=utf8
[mysqld]
collation-server = utf8_unicode_ci
init-connect=’SET NAMES utf8′
character-set-server = utf8
修改后 /etc/init.d/mysql stop
/etc/init.d/mysql statr
重启mysql
原文：http://my.oschina.net/u/2419190/blog/489840