ubuntu mysql显示中文_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;