ubuntu Mysql显示中文

vi /etc/mysql/my.cnf 

发现引用两个配置文件

!includedir /etc/mysql/conf.d  
!includedir /etc/mysql/mysql.conf.d  

两个文件添加编码格式

sudo vi /etc/mysql/mysql.conf.d/mysqld.cnf  

在[mysqld] 的skip-external-locking下，添加character-set-server=utf8

......  
[mysqld]  
......  
skip-external-locking  
character-set-server=utf8  
......  

sudo vi /etc/mysql/conf.d/mysql.cnf

添加如下

[mysql]  
default-character-set=utf8  

最后

service mysql restart  即可

支持中文编码

Ubuntu 16.04.1下修改MySQL默认编码

设置mysql编码格式，亲测还可以用

| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | utf8 |
| character_set_results | utf8 |
| character_set_server | utf8 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
如果仍有编码不是utf8的，请检查配置文件，也可使用mysql命令设置：
set character_set_client = utf8;
set character_set_server = utf8;
set character_set_connection = utf8;
set character_set_database = utf8;
set character_set_results = utf8;
set collation_connection = utf8_general_ci;
set collation_database = utf8_general_ci;
set collation_server = utf8_general_ci;