Ubuntu下修改mysql5.7字符集

本地Ubuntu系统的mysql字符集始终是latin1，添加以下代码到/etc/mysql/my.cnf

[client]
default-character-set=utf8
[mysql]
default-character-set=utf8
[mysqld]
default-character-set=utf8
user=mysql
max_allowed_packet = 20M
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

修改之后

$ sudo /etc/init.d/mysql restart

启动失败

将

[mysqld]
default-character-set=utf8

修改为

[mysqld]
character-set-server=utf8

启动成功

转载于:https://my.oschina.net/OriginLeon/blog/825741