centos 7 - mysql 5.6 설치

# yum -y install http://dev.mysql.com/get/mysql-community-release-el7-5.noarch.rpm

# yum -y install mysql-community-server

# systemctl start mysqld

# systemctl enable mysqld

# mysql

# vi /etc/my.cnf

[client]

default-character-set = utf8

[mysql]

default-character-set=utf8

[mysqld]

datadir=/var/lib/mysql

socket=/var/lib/mysql/mysql.sock

character-set-server=utf8

collation-server=utf8_general_ci

init_connect=SET collation_connection = utf8_general_ci

init_connect=SET NAMES utf8

character-set-client-handshake = FALSE

skip-character-set-client-handshake

[mysqldump]

default-character-set=utf8

여기까지 설정 변경

# systemctl restart mysqld

# mysql

mysql> status