Ubuntu下MysqlServer默認編碼的設置

配置

以下列出了Linux下比較流行發(fā)行版Ubuntu的兩個LTS版本基本配置，其他發(fā)行版可以參考其中的參數(shù)，配置文件路徑可能有差異。

Ubuntu 14.04 環(huán)境下的配置

Ubuntu 14.04 下只需要修改一個文件: /etc/my.cnf

[mysql]
default-character-set=utf8

[client]
default-character-set=utf8

[mysqld]
collation-server = utf8_generic_ci
init-connect='SET NAMES utf8'
character-set-server = utf8

Ubuntu 16.04 環(huán)境下的配置

Ubuntu 16.04 中MysqlServer配置被分成了兩個文件來維護，依次將相應的配置區(qū)(section)放到對應的配置文件里就可以了。

/etc/mysql/conf.d/mysql.cnf

[mysql]
default-character-set=utf8
[client]
default-character-set=utf8

/etc/mysql/mysql.conf.d/mysqld.cnf

[mysqld]
init-connect='SET NAMES utf8'
character-set-server = utf8

驗證修改結果

配置完成后重啟數(shù)Mysql服務器，檢查數(shù)據(jù)庫編碼

mysql> show variables like '%char%';

配置正確的話會將所有編碼設置成utf8

+--------------------------+----------------------------+
| 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/ |
+--------------------------+----------------------------+
8 rows in set (0.01 sec)