본문으로 바로가기

MySQL설정

category 데이터베이스/MySql 2017. 6. 13. 10:01
반응형

MySQL 설정

 

# The MySQL server

[mysqld]

port= 3306

socket= "D:/mysql/mysql.sock"

basedir="D:/mysql" 

tmpdir="D:/mysql/tmp" 

datadir="D:/mysql/data"

skip-locking

key_buffer = 16M

max_allowed_packet = 1M

table_cache = 64

sort_buffer_size = 512K

net_buffer_length = 8K

read_buffer_size = 256K

read_rnd_buffer_size = 512K

myisam_sort_buffer_size = 8M

 

##default-character-set=utf8

character-set-server=utf8

default-character-set=utf8

default-collation=utf8_general_ci

language= /mysql/share/korean/

character-set-client-handshake = FALSE

 

## euckr language set

#character-set-server=euckr

#default-character-set=euckr

#default-collation=euckr_korean_ci

#language= /mysql/share/korean/

#character-set-client-handshake = FALSE

반응형