참다참다 못참아서 그냥 설정 뒤집어 깜.
환경:
- mbp 13" early 2011 (2.7@Intel core i7, ddr3 4G, hd graphics 384mb)
- osx 10.8.2 (mountain lion)
- mysql 5.5.27
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
를 각각에 추가
출처: http://mirwebma.tistory.com/5
3. 껐다 켜요!
4. 확인을 해봐요 !
와 된다 ..ㅋ.. 그 전에 만들어 놓은 테이블들은 어쩌죠...ㅋ...ㅋ.. 다 날려야징..ㅋ..ㅜㅜ
'IT > troubleshooting' 카테고리의 다른 글
| TinyEditor 에서 post 함수를 호출해도 Null (or None)이 리턴이 될 때 (0) | 2012.11.26 |
|---|---|
| 'Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause' (0) | 2012.11.22 |
| 서버가 죽었었습니다. (MyISAM 테이블 깨졌을 때 대처법) (0) | 2012.07.23 |
| MySQL `와 '의 차이 (0) | 2012.03.16 |
| iBatis org.springframework.jdbc.UncategorizedSQLException 에러 해결하기 (1) | 2012.03.11 |
