centos 5.5 mysql5.5 乱码

1. 找到mysql的配置文件，拷贝到etc目录下，第一步很重要

使用find命令查找cnf文件。记得不要去找my.cnf因为它不一定存在，而应该找*.cnf。
[root@linuxserver classes] find / -iname *.cnf -print
/root/Desktop/mysql-5.0.56/mysql-test/std_data/ndb_config_mycnf1.cnf
/root/Desktop/mysql-5.0.56/mysql-test/std_data/bug15328.cnf
/root/Desktop/mysql-5.0.56/mysql-test/std_data/ndb_config_mycnf2.cnf
/etc/my.cnf
/etc/pki/tls/openssl.cnf
/usr/share/mysql/my-medium.cnf
/usr/share/mysql/my-large.cnf
/usr/share/mysql/my-small.cnf
/usr/share/mysql/my-huge.cnf
/usr/share/mysql/my-innodb-heavy-4G.cnf
/usr/share/doc/MySQL-server-community-5.0.92/my-medium.cnf
/usr/share/doc/MySQL-server-community-5.0.92/my-large.cnf
/usr/share/doc/MySQL-server-community-5.0.92/my-small.cnf
/usr/share/doc/MySQL-server-community-5.0.92/my-huge.cnf
/usr/share/doc/MySQL-server-community-5.0.92/my-innodb-heavy-4G.cnf

找到之后，复制一个出来
 cp /usr/share/doc/MySQL-server-community-5.0.92/my-large.cnf   /etc/my.cnf

 

2. 打开my.cnf修改编码

 vi /etc/my.cnf

在[mysqld]下添加                                          是mysqld，而不是mysql下！
character_set_server=utf8

重启mysql

 service mysqld restert

 

4.登录mysql看看修改成功否

show variables like 'character%';
+--------------------------+----------------------------+
| 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/ |