在Linux上 安裝完MySQL數(shù)據(jù)庫后要對數(shù)據(jù)庫進行字符集和校對集的修改（校對集是基于字符集） 可以通過SHOW VARIABLES LIKE '%char%';和SHOW VARIABLES LIKE '%colla%';來查看字符集和校對集
然后通過修改配置文件 來達到改變默認配置的目的 位于/etc/mysql/my.cnf下有一個配置文件 里面有兩個目錄路徑 分別是 /etc/mysql/conf.d /etc/mysql/mysql.conf.d/ 這么兩個目錄 那么我們改變編碼可以是在當前這個my.cnf改也可以去/etc/mysql/conf.d/下的mysql.cnf改變
注意 在修改的時候要暫停MySQL的服務
-
service mysql status查看狀態(tài) -
service mysql start開啟服務 -
service mysql stop暫停服務 -
service mysql restart重啟服務
配置文件內(nèi)容
# 客戶端
[client]
default-character-set = utf8
# 服務端
[mysqld]
character-set-server = utf8
collation-server = utf8_general_ci
校對集 依賴 字符集
如果沒有修改之前編碼集是
mysql> show variables like '%char%';
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | latin1 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
8 rows in set (0.20 sec)
校對集為
mysql> show variables like '%colla%';
+----------------------+-------------------+
| Variable_name | Value |
+----------------------+-------------------+
| collation_connection | utf8_general_ci |
| collation_database | latin1_swedish_ci |
| collation_server | latin1_swedish_ci |
+----------------------+-------------------+
3 rows in set (0.00 sec)
改完之后的 編碼集為
mysql> SHOW VARIABLES LIKE '%char%';
+--------------------------+----------------------------+
| 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.00 sec)
校對集為
mysql> SHOW VARIABLES LIKE '%colla%';
+----------------------+-----------------+
| Variable_name | Value |
+----------------------+-----------------+
| collation_connection | utf8_general_ci |
| collation_database | utf8_general_ci |
| collation_server | utf8_general_ci |
+----------------------+-----------------+
3 rows in set (0.01 sec)
