본문 바로가기

DB스토리/MYSQL

MYSQL 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


datadir=/opt/ahnlab/insight/mysql/data

socket=/opt/ahnlab/insight/mysql/mysql.sock

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

symbolic-links=0

# 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

lower_case_table_names=1


[mysqld_safe]

log-error=/opt/ahnlab/insight/mysql/mysql.log

pid-file=/opt/ahnlab/insight/mysql/mysql.pid


#

# include all files from the config directory

#

!includedir /etc/my.cnf.d


'DB스토리 > MYSQL' 카테고리의 다른 글

mysql 계층 쿼리  (0) 2015.02.04
리눅스 MySQL 5.6.x 설치  (0) 2014.09.30
MySQL Workbenc Error code 1175  (0) 2014.09.26
MYSQL JOIN 쿼리  (0) 2014.09.26
Can't connect to local MySQL server through socket '/tmp/mysql.sock'  (0) 2014.09.04