linux-xampp-mysql的配置解决中文乱码

修改MySQL缺省字符集为utf8，改my.cnf文件

[client]
default_character_set=utf8
[mysqld]
# default-character-set=utf8
character-set-server = utf8
collation-server = utf8_general_ci
[mysql]
default_character_set=utf8

通过上面的设置后，重启mysql(命令：$ /opt/lampp/lampp reloadmysql),再登录msyql,show variables like "%char%"看看，是否正确。(命令：msyql> show variables like "%char%")
查看结果类似如下：
+--------------------------+---------------------------------+
| Variable_name            | Value                           |
+--------------------------+---------------------------------+
| character_set_client     | utf8                            |
| character_set_connection | utf8                            |
| character_set_database   | utf8                            |
| character_set_filesystem | binary                          |
| character_set_results    | utf8                            |
| character_set_server     | utf8                            |
| character_set_system     | utf8                            |
| character_sets_dir       | D:"mysql-5.0.37"share"charsets" |
+--------------------------+---------------------------------+

＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝

另外：修改MySQL缺省字符集为GBK，改my.cnf文件
代码
[mysqld]
# default-character-set=gbk
character-set-server = gbk
collation-server = gbk_chinese_ci
[client]
default_character_set=gbk
[mysql]
default_character_set=gbk