[轉貼]MySQL修改預設字元編碼 – IT閱讀

1.找到mysql安裝目錄的bin目錄,用文字編輯器開啟my.ini檔案,並在對應的地方新增以下幾個修改:

[mysql]

[mysql]
default-character-set = utf8

[mysqld]

[mysqld]
port=3306
character-set-client-handshake = FALSE
character-set-server = utf8
collation-server = utf8_unicode_ci
init_connect=’SET NAMES utf8’

[client]

[client]
default-character-set = utf8

來源： MySQL修改預設字元編碼 – IT閱讀