2020.07.10 / 09:19
mac¿¡¼ mysql ¼³Ä¡ ÈÄ utf-8 ÀÎÄÚµù ¼³Á¤
Äڷγª
Ãßõ ¼ö 136
# /etc/my.conf ÆÄÀÏÀÌ ¾ø´Â°æ¿ì
¸Æ¿¡¼ mysqlÀ» ¼³Ä¡Çߴµ¥ /etc/my.cnf ¼³Á¤ ÆÄÀÏÀÌ ¾ø´Â °æ¿ì
/usr/local/mysql/support-files/my-default.cnf ±âº» ¼³Á¤ÆÄÀÏÀ» º¹»çÇؼ »ç¿ëÇØ¾ß ÇÑ´Ù.
sudo cp /usr/local/mysql/support-files/my-default.cnf /etc/my.cnf
sudo ./mysql.server restart
# MySQL ·Î±×Àνà ¿À·ù
±×·¯³ª ¿©±â¼ MySQL ·Î±×Àνà ¹®Á¦°¡ ¹ß»ýÇÏ´Â °æ¿ì°¡ »ý±ä´Ù.[ERROR] unknown variable 'sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES'
=> /etc/my.cnf ÆÄÀÏÀÇÀÇ sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES ÀÌÁÙÀ» ÁÖ¼® ó¸® ÇØÁØ´Ù.
ÀÌ ÈÄ ´Ù½Ã ·Î±×ÀÎ Çغ¸¸é ¿À·ù¾øÀÌ ·Î±×ÀÎ ÀߵȴÙ.
# MySQ utf-8 ÀÎÄÚµù ¼³Á¤
vi sudo /etc/my.cnf ¿¡ ¾Æ·¡³»¿ëÀ» Ãß°¡ÇÑ´Ù.
[mysqld]
init_connect="SET collation_connection=utf8_general_ci"
init_connect="SET NAMES utf8"
character-set-server=utf8
collation-server=utf8_general_ci
skip-character-set-client-handshake
[client]
default-character-set=utf8
[mysql]
default-character-set=utf8
Âü°í) http://nsnotification.blogspot.kr/2013/05/mac-osmountain-lion-mysql.html
Ãâó: https://south10.tistory.com/45 [¿´Ô ºí·Î±×]