linux下修改mysql_修改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/