打开Mysql BIN 下面my.ini文件下
原文:
## UTF 8 Settings
#init-connect=\'SET NAMES utf8\'
#collation_server=utf8_unicode_ci
#character_set_server=utf8
#skip-character-set-client-handshake
#character_sets-dir="D:/xmapp/mysql/share/charsets"
修改如下:
## UTF 8 Settings
init-connect=\'SET NAMES utf8\'
#collation_server=utf8_unicode_ci
character_set_server=utf8
#skip-character-set-client-handshake
#character_sets-dir="D:/xmapp/mysql/share/charsets"