在mysql里查看当前编码
![](https://img-blog.csdnimg.cn/2020070610562550.png)
show variables like 'character%';
在/etc/my.cnf里加入
character-set-server=utf8
init_connect='SET NAMES utf8'
show variables like 'character%';
character-set-server=utf8
init_connect='SET NAMES utf8'