mysql> show variables like '%char%';
mysql通过配置my.cnf(winidow系统为my.ini配置文件),实现服务字符集utf-8
首先找到[client]节点(没有就添加节点)
[client]
default-character-set=utf8
找到[mysqld]节点
character-set-server=utf8

最后重启mysql数据库服务
systemctl restart mysqld.service
https://www.leftso.com/article/184.html