mysql utf-8 설정

mysql version
mysql Ver 14.14 Distrib 5.7.17, for Linux (x86_64) using EditLine wrapper

/etc/mysql/mysql.conf.d/mysqld.cnf 에 아래의 내용을 추가합니다.

[mysqld]
character-set-client-handshake = FALSE
init_connect=”SET collation_connection = utf8_general_ci”
init_connect=”SET NAMES utf8″
character-set-server = utf8

[client]
default-character-set = utf8

[mysql]
default-character-set = utf8

[mysqldump]
default-character-set = utf8