linuxでmysqlデータベースを構成し、文字化けしを避ける

[root@flyHome gaoxiang]# find/-iname '*.cnf' -print

/etc/pki/tls/openssl.cnf
/etc/my.cnf
/usr/share/open/easy-rsa/2.0/openssl-0.9.6.cnf
/usr/share/open/easy-rsa/2.0/openssl.cnf
/usr/share/open/easy-rsa/1.0/openssl.cnf
/usr/share/mysql/my-small.cnf
/usr/share/mysql/my-large.cnf
/usr/share/mysql/my-innodb-heavy-4G.cnf
/usr/share/mysql/my-huge.cnf
/usr/share/mysql/my-medium.cnf
/usr/share/doc/mysql-server-5.5.18/my-small.cnf
/usr/share/doc/mysql-server-5.5.18/my-large.cnf
/usr/share/doc/mysql-server-5.5.18/my-innodb-heavy-4G.cnf
/usr/share/doc/mysql-server-5.5.18/my-huge.cnf
/usr/share/doc/mysql-server-5.5.18/my-medium.cnf

 
コピーしてcnf、my-medium.cnf、my-huge.cnf、my-innodb-heavy-4G.cnfのうちの1つは/etc/my.cnf下
[root@flyHome gaoxiang]# cp/usr/share/mysql/my-medium.cnf/etc/my.cnf cp:「/etc/my.cnf」を上書きしますか?y
 
[root@flyHomegaoxiang]#vim/ファイルが存在するディレクトリ(一般的にetcディレクトリにコピーされます)/my.cnf
[クライアント]で追加
default-charater-set=utf8
[mysqld]でcollation_を追加server = utf8_general_ci character_set_server = utf8
保存終了後mysqldを再起動するには:
[root@flyHome gaoxiang]#service mysqld restart
 
以上の操作を完了すればOKです.
 
効果を見てみましょう.
mysql> show variables like 'character_set_%'; +--------------------------+----------------------------+ | 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/| +--------------------------+----------------------------+