centOS7下的MySQL编码设置

1，进入编辑my.cnf

vi /etc/my.cnf

2，在[mysql]下添加（没有手动添加一项，要在mysqld上面）

default-character-set=utf8

3，在[mysqld]下边添加以下内容

character-set-server=utf8

init_connect='SET NAMES utf8'

4，重启MySQL

sudo service  mysqld restart

进入mysql 查看字符编码

show variables like '%character%';

mysql> show variables like '%character%';
+--------------------------+----------------------------+
| Variable_name            | Value                      |
+--------------------------+----------------------------+
| character_set_client     | utf8                       |
| character_set_connection | utf8                       |
| character_set_database   | utf8                       |
| character_set_filesystem | binary                     |
| character_set_results    | utf8                       |
| character_set_server     | utf8                       |
| character_set_system     | utf8                       |
| character_sets_dir       | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
8 rows in set (0.00 sec)
 

参考：https://blog.csdn.net/h996666/article/details/78034073