[mysql] my.cnf 한글 세팅

[mysql] my.cnf 한글 세팅

[mysql]

default-character-set=utf8

 

[mysqld]

 

datadir=/var/lib/mysql

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

#user=ndlpadmin

init_connect='SET collation_connection=utf8_general_ci'

init_connect='SET NAMES utf8'

# Disabling symbolic-links is recommended to prevent assorted security risks

symbolic-links=0

character_set_server=utf8

#character_set_database=utf8

collation_server=utf8_general_ci

#collation_database=utf8_general_ci

lower_case_table_names=1

 

# Settings user and group are ignored when systemd is used.

# If you need to run mysqld under a different user or group,

# customize your systemd unit file for mariadb according to the

# instructions in http://fedoraproject.org/wiki/Systemd

 

[mysqld_safe]

#log-error=/var/log/mariadb/mariadb.log

#pid-file=/var/run/mariadb/mariadb.pid

#

# include all files from the config directory

#

[mysqldump]

default-character-set=utf8

 

[mysql]

default-character-set=utf8

 

!includedir /etc/my.cnf.d