修改文件为/etc/mysql/my.cnf

[client]

default-character-set = utf8 （ps：client的设置没变）

[mysqld]

lower_case_table_names = 1 (不区分大小写)

character_set_server = utf8 (ps:注意这里的改动)

ubuntu14.04修改mysql默认编码