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] 添加:
找到[mysqld] 添加:
//默认字符集为utf8
default-character-set=utf8
//设定连接mysql数据库时使用utf8编码,以让mysql数据库为utf8运行
init_connect='SET NAMES utf8'
[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/