1.打开mysql命令行
show variables like '%char%';
将字符集显示不是utf-8的更改为utf-8
例如:set character_set_database=utf8;
重启mysql,重新映射数据表即可
2.打开mysql的配置文件添加如下内容
[client]
default-character-set =utf8
[mysql]
default-character-set =utf8
[mysqld]
collation-server = utf8_unicode_ci
init_connect ='SET NAMES utf8'
character_set_server=utf8