在Mysql的安装目录里找到my.ini文件,
[client]
port=3306
[mysql]
default-character-set=utf8(该位置改为utf8)默认为瑞典某种语言格式,
mysqld]
# The TCP/IP Port the MySQL Server will listen on
port=3306
#Path to installation directory. All paths are usually resolved relative to this.
basedir="D:/Program Files (x86)/MySQL/MySQL Server 5.5/"
#Path to the database root
datadir="C:/ProgramData/MySQL/MySQL Server 5.5/Data/"
# 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=utf8
collation-server=utf8_general_ci (这块也需要改变,如果没有可以加上)
# The default storage engine that will be used when create new tables when
default-storage-engine=INNODB
最后重启一下Mysql服务就可以搞定了