mysql中文亂碼解決辦法

Windows

在C:\Program Files\MySQL\MySQL Server 5.5\bin目錄下

MySQLInstanceConfig.exe執行 重新配置character_set_server=utf8

show variables like "%char%";

SET character_set_connection=utf8, character_set_results=utf8, character_set_client=binary

---------------------------------------------------------------------------------------------------------------Linux安裝mysql 解決中文亂碼 ----------------------------------------------------

#vim /etc/mysql/my.cnf 。如下修改：

[client]

default-character-set=utf8

[mysqld]

default-storage-engine=INNODB

character-set-server=utf8

collation-server=utf8_general_ci

-----------------------------------------------------------------------------------------------------