linux(fc9)下mysql字符集的修改

shell窗口中用以下命令找到mysql的配置文件
find / -iname '*.cnf' -print
显示结果
/opt/artica/mysql/share/mysql/my-medium.cnf
/opt/artica/mysql/share/mysql/my-huge.cnf
/opt/artica/mysql/share/mysql/my-small.cnf
/opt/artica/mysql/share/mysql/my-large.cnf
/opt/artica/mysql/share/mysql/my-innodb-heavy-4G.cnf
/opt/artica/mysql/etc/my.cnf
/opt/artica/ssl/openssl.cnf
/etc/texmf/web2c/mktex.cnf
/etc/pki/tls/openssl.cnf
将my-medium.cnf,my-huge.cnf,my-small.cnf,my-large.cnf其中之一的文件拷贝至etc下，
例如 cp /usr/share/mysql/my-medium.cnf /etc/my.cnf
命名为my.cnf，或者直接在etc目录下新建my.cnf文件,输入
[client]
default-character-set    = utf8
[mysqld]
default-character-set    = utf8
保存退出，重启mysql
[root@localhost ~]# /etc/init.d/mysql start
Starting MySQL                                             [确定]
[root@localhost ~]# mysql -u 输入你的用户名 -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or /g.
Your MySQL connection id is 1
Server version: 5.1.26-rc MySQL Community Server (GPL)

Type 'help;' or '/h' for help. Type '/c' to clear the buffer.

mysql>

[mysqld]设置server及db到字符集，[client]设置client及conn到字符集
查看字符集
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/ |
+--------------------------+----------------------------+
8 rows in set (0.00 sec)

mysql命令方式修改字符集

对已有数据库的修改
   mysql>use yourdb

   mysql>alter database yourdb character set utf-8;

创建数据库时指定数据库的字符集

   mysql>create database yourdb character set utf-8;

mysql> set character_set_client=utf8;
Query OK, 0 rows affected (0.00 sec)

mysql> set character_set_connection=utf8;
Query OK, 0 rows affected (0.00 sec)

mysql> set character_set_database=utf8;
Query OK, 0 rows affected (0.00 sec)

mysql> set character_set_results=utf8;
Query OK, 0 rows affected (0.00 sec)

mysql> set character_set_server=utf8;
Query OK, 0 rows affected (0.00 sec)

mysql> set character_set_system=utf8;
Query OK, 0 rows affected (0.01 sec)

mysql> set collation_connection=utf8;
Query OK, 0 rows affected (0.01 sec)

mysql> set collation_database=utf8;
Query OK, 0 rows affected (0.01 sec)

mysql> set collation_server=utf8;
Query OK, 0 rows affected (0.01 sec)