使用该命令查看mysql字符集:
SHOW VARIABLES LIKE 'character%'
发现character_set_server 为latin1,中文出现乱码。
找到C:\ProgramData\MySQL\MySQL Server 5.6目录
# The default character set that will be used when a new schema or table is
# created and no character set is defined
# character-set-server=
character-set-server=utf8
指定character-set-server=utf8。
重新启动MySQL服务。
查看 SHOW VARIABLES LIKE 'character%'