[mysql] my.cnf 기본 케릭터셋 UTF-8 설정, 기타 설정

Centos7 

vi /etc/my.cnf

 

[mysqld]
collation-server = utf8_unicode_ci
init-connect='SET NAMES utf8'
character-set-server = utf8
max_connections = 1500
wait_timeout = 60
max_allowed_packet = 512M



[client]
port=3306
default-character-set = utf8

[mysqldump]
default-character-set = utf8

[mysql]
default-character-set = utf8

 

확인

show variables like 'c%';