本文主要介紹了如何修改MAC版mysql默認(rèn)字符集為utf8,如果你的MAC版mysql字符亂碼龄糊，可以參考一下這篇文章
1.檢查默認(rèn)安裝的mysql的字符集
mysql> show variables like '%char%';
這時(shí)候普遍返回的字符集如下：
+--------------------------+--------------------------------------------------------+
| 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的字符集，也就是說(shuō)mysql后續(xù)創(chuàng)建的表都是latin1字符集的募疮，不是utf8炫惩，會(huì)造成一些麻煩。所以有必要修改my.cnf阿浓，在修改my.cnf之前一定要關(guān)閉mysql進(jìn)程他嚷，不然會(huì)遇到mysql的sock不能連接的問(wèn)題。
2.關(guān)閉mysqld后臺(tái)進(jìn)程
- 系統(tǒng)偏好設(shè)置中在其他選項(xiàng)中找到mysql的選項(xiàng)點(diǎn)擊
- 點(diǎn)擊 Stop MySQL Server 關(guān)閉mysql服務(wù)
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
修改完畢之后再啟動(dòng)mysql
4.檢查結(jié)果
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)
修改完成芭毙！
轉(zhuǎn)載自其他博客：原文鏈接
