[MYSQL] OSX MYSQL 한글 설정

1. /etc/my.cnf 가 없어요!

Open Terminal (in Utilities folder under Applications folder) 

cd /usr/local/mysql/support-files/
sudo cp my-huge.cnf /etc/my.cnf

and enter your admin password when prompted. You could do this from a non-admin account by using the su command, but that's probably a bit scary for some people ;) 

You will now have a copy of my.cnf in /etc (just in case you don't know, that means the etc folder directly under the root folder, not under MySQL's install folder) 

You can edit it with a text-editor such as TextWrangler by using File->Open Hidden, or if you are happy to use the command line, use: 

cd /etc

출처: http://forums.mysql.com/read.php?11,366143,376017#msg-376017

2. 이제 설정을 덮어씌워요!

[mysqld]
character-set-server=utf8
collation-server=utf8_general_ci


init_connect=SET collation_connection=utf8_general_ci
init_connect=SET NAMES utf8
[client]
default-character-set=utf8
[mysql]
default-character-set=utf8