linux mysql字符集_linux下mysql字符集的修改

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/ |

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

修改成功！