cd /etc/mysql ls vi my.cnf ``` 2. 修改my.cnf ``` [client] default-character-set=utf8 [mysql] default-character-set=utf8 [mysqld] skip-character-set-client-handshake collation-server = utf8_general_ci init-connect='SET NAMES utf8' character-set-server = utf8 ``` ※設定檔內加入「skip-character-set-client-handshake」是為了抑制MySQL內部自行進行變換。
[client] default-character-set=utf8 [mysql] default-character-set=utf8 [mysqld] skip-character-set-client-handshake collation-server = utf8_general_ci init-connect='SET NAMES utf8' character-set-server = utf8 ``` ※設定檔內加入「skip-character-set-client-handshake」是為了抑制MySQL內部自行進行變換。