mac下修改mysql的默認字符集為utf8 1,檢查默認安裝的mysql的字符集
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/local/mysql-5.5.23-osx10.6-x86_64/share/charsets/ | +--------------------------+--------------------------------------------------------+ 8 rows in set (0.00 sec)
character_set_database和character_set_server依然是latin1的字符集，也就是說mysql後續創建的表都是latin1字符集的，不是utf8，會造成一些麻煩。所以有必要修改my.cnf，在修改my.cnf之前一定要關閉mysql進程，不然會遇到mysql的sock不能連接的問題。 2，關閉mysqld後台進程 系統偏好設置裡面控制mysqld，避免了去找mysqld安裝位置的麻煩。
點擊 Stop MySQL Server
3，修改mysql配置文件/etc/my.cnf
sudo cp /usr/local/mysql/support-files/my-medium.cnf /etc/my.cnf sudo vi /etc/my.cnf [client]部分加入： default-character-set=utf8 [mysqld]部分加入： character-set-server=utf8
退出並保存： 按住ctrl鍵再連按兩次z鍵 修改完畢之後再啟動mysql 4，檢查結果：
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/local/mysql-5.5.23-osx10.6-x86_64/share/charsets/ | +--------------------------+--------------------------------------------------------+ 8 rows in set (0.00 sec) 修改完畢＃
