修改Linux下修改MySQL编码

默认登录mysql之后show variables like ‘%character%’， 出现
mysql> show variables like 'character%';
+--------------------------+-----------------------------------------------------------+
| Variable_name            | Value                                                     |
+--------------------------+-----------------------------------------------------------+
| character_set_client     | latin1                                                    |
| character_set_connection | latin1                                                    |
| character_set_database   | latin1                                                    |
| character_set_filesystem | binary                                                    |
| character_set_results    | latin1                                                    |
| character_set_server     | latin1                                                    |
| character_set_system     | utf8                                                      |
| character_sets_dir       | /usr/local/mysql-5.0.51a-linux-i686/share/mysql/charsets/ |

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

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

[root@xatarena /]# find / -name "*.cnf"

[root@xatarena /]# cp /usr/local/mysql-5.0.51a-linux-i686/support-files/my-large.cnf /etc/my.cnf
[root@xatarena /]# vi /etc/my.cnf

找到[client] 添加:

default - character - set = utf8  // 默认字符集为utf8

找到[mysqld] 添加:

 //默认字符集为utf8
default-character-set=utf8
//设定连接mysql数据库时使用utf8编码，以让mysql数据库为utf8运行
init_connect='SET NAMES utf8'

修改好后,重新启动mysql
[root@xatarena /]# sudo ./etc/init.d/mysql stop
Shutting down MySQL.                                       [确定]
[root@xatarena /]# sudo ./etc/init.d/mysql start
Starting MySQL                                             [确定]

在查询一下：

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/local/mysql-5.0.51a-linux-i686/share/mysql/charsets/