MySQL設定編碼

標籤：style   io   ar   os   sp   檔案   資料   on   art   

MySQL設定編碼 版本mysql-5.6.21-winx64

mysql預設的編碼：

mysql> SHOW VARIABLES LIKE ‘character%‘;+--------------------------+---------------------------------------------+| Variable_name            | Value                                       |+--------------------------+---------------------------------------------+| character_set_client     | gbk                                         || character_set_connection | gbk                                         || character_set_database   | latin1                                      || character_set_filesystem | binary                                      || character_set_results    | gbk                                         || character_set_server     | latin1                                      || character_set_system     | utf8                                        || character_sets_dir       | D:\soft\mysql-5.6.21-winx64\share\charsets\ |+--------------------------+---------------------------------------------+8 rows in set (0.00 sec)mysql>

mysql設定編碼

SET character_set_client = utf8;

SET character_set_connection = utf8;

SET character_set_database = utf8;

SET character_set_results = utf8;

SET character_set_server = utf8;

mysql> SET character_set_client = utf8;Query OK, 0 rows affected (0.00 sec)mysql> SET character_set_connection = utf8;Query OK, 0 rows affected (0.00 sec)mysql> SET character_set_database = utf8;Query OK, 0 rows affected (0.00 sec)mysql> SET character_set_results = utf8;Query OK, 0 rows affected (0.00 sec)mysql> SET character_set_server = utf8;Query OK, 0 rows affected (0.00 sec)mysql>

 此種方式只在目前狀態下有效，當重啟資料庫服務後失效。所以如果想要不出現亂碼只有修改my.ini檔案。

修改my.ini檔案設定編碼

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

在對應的標籤下添加如下配置：

重啟mysql伺服器：

C:\Users\Lenovo>net stop mysqlMySQL 服務正在停止.MySQL 服務已成功停止。C:\Users\Lenovo>net start mysqlMySQL 服務正在啟動 .MySQL 服務已經啟動成功。C:\Users\Lenovo>

===========END===========

MySQL設定編碼