在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)