mysql中文乱码彻底解决

1.在mysql的配置文件my.ini中添加：

[mysqld]port  = 3306socket  = /tmp/mysql.sockcharacter-set-server=utf8character-set-filesystem = utf8[client]password = your passwordport  = 3306socket  = /tmp/mysql.sockdefault-character-set=utf8  

特别注意：mysql的默认配置文件是my-default.ini，一定要复制一份改成my.ini，在my.ini里配置，否则配置不会和生效。

2.配置之后,使用命令 show variables like ‘character%’;查看效果

mysql>  show variables like 'character%';+--------------------------+----------------------------------------------------+| Variable_name            | Value                                              |+--------------------------+----------------------------------------------------+| character_set_client     | utf8                                               || character_set_connection | utf8                                               || character_set_database   | utf8                                               || character_set_filesystem | utf8                                               || character_set_results    | utf8                                               || character_set_server     | utf8                                               || character_set_system     | utf8