linux下修改mysql的字符集

首先修改my.cnf文件：

sudo gedit /etc/mysql/my.cnf

[client]字段下，添加或获修改默认字符集为：

default-character-set=utf8

[mysqld]字段下，添加或修改下列字段：

character-set-server=utf8

collation-server=utf8_general_ci

default-character-set=utf8

init_connect='SET NAMES utf8'

修改后需重启系统：

登陆mysql

mysql -u root -p

输入 命令：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/share/mysql/charsets/ |
+--------------------------+----------------------------+

此时修改成功！