debian mysql中文乱码_mysql 中文乱码问题（mysql 5.1 ， debian 6）

一、环境：

1、mysql

# mysql -V

mysql Ver 14.14 Distrib 5.1.73, for debian-linux-gnu (x86_64) using readline 6.1

2、操作系统：

# lsb_release -a

No LSB modules are available.

Distributor ID:Debian

Description:Debian GNU/Linux 6.0.5 (squeeze)

Release:6.0.5

Codename:squeeze

二、将mysql编码方式改为 utf8

1、apt-get 安装mysql后编码方式为：

mysql> show variables like "%char%";

+--------------------------+----------------------------+

| Variable_name | Value |

+--------------------------+----------------------------+

| character_set_client | latin1 |

| character_set_connection | latin1 |

| character_set_database | utf8 |

| character_set_filesystem | binary |

| character_set_results | latin1 |

| character_set_server | latin1 |

| character_set_system | utf8 |

| character_sets_dir | /usr/share/mysql/charsets/ |

+--------------------------+----------------------------+

8 rows in set (0.00 sec)2、修改配置文件 my.cnf

# vim /etc/mysql/my.cnf

在   [client]   中添加

default-character-set=utf8在   [mysqld]  中添加

default-character-set=utf83、重启mysql

# /etc/init.d/mysql restart4、查看修改之后的编码方式：

mysql> 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 | /usr/share/mysql/charsets/ |

+--------------------------+----------------------------+

8 rows in set (0.00 sec) 修改成功。