1、打开配置文件

sudo gedit /etc/mysql/my.cnf

[client]下添加：

character-set-server = utf8 

[mysqld]下添加：

character-set-server = utf8 

sudo service mysql restart