wamp数据库mysql解决中文乱码问题方法

时间:2021-08-05 06:37:48

修改MySQL的配置文件(my.ini)如下两处:

1.[client]

default-character-set=utf8

2.[mysqld]

port=3306
explicit_defaults_for_timestamp = TRUE
language=f:/wamp/bin/mysql/mysql5.6.17/share/english
default-storage-engine=INNODB
character-set-server=utf8
collation-server=utf8_general_ci

注意:language=f:/wamp/bin/mysql/mysql5.6.17/share/english为自己配置的wamp路径