[clinet]default character set = utf8
[mysqld]
character_set_server=utf8
character_set_client=utf8
collation-server=utf8_general_ci
[mysql]default character set = utf8
查看字符集命令show variables like '%char%';修改MySQL的配置文件my.cnf[clinet]default character set = utf8[mysqld]character_set_server=utf8character_set_client=utf8collation-server=utf8_general_ci[mysql]default character set = utf8修改后重启MySQL服务。备注:只对修改后,