执行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 latin
character_set_system utf8
character_sets_dir D:\java\Mysql\share\charsets\
mysql安装目录中找mysql.ini文件,找到
character-set-server=latin1
将其改为utf8,然后重启mysql服务