查看所有应用字符集
show variables like 'character%';
设置数据库本身编码
vim /etc/mysql/mysql.conf.d/mysqld.cnf
在lc-messages-dir = /usr/share/mysql 语句后添加 character-set-server=utf8
vim /etc/mysql/conf.d/mysql.cnf
[mysql]下添加:default-character-set=utf8
重启
/etc/init.d/mysql restart
修改数据库编码
alter database xxx character set utf8;