mysql設定utf8

step 1 初安裝主機就設定my.cnf
cp /usr/local/share/mysql/my-huge.cnf /etc/my.cnf

step 2 設定my.cnf，將mysql編碼全部預設為utf8 <紅色字為新增的設定值>
[client]
#password    = your_password
port     = 3306
socket   = /tmp/mysql.sock
default-character-set = utf8

[mysqld]
port     = 3306
socket   = /tmp/mysql.sock
......
......
default-character-set = utf8