민서네집

Cent OS 6.4, MySQL 기본 인코딩 변경하기 본문

Database/MySQL

Cent OS 6.4, MySQL 기본 인코딩 변경하기

브라이언7 2013. 12. 4. 13:32

Cent OS 6.4, MySQL 5.6 version 기본 인코딩 변경하기


MySQL 기본 인코딩 변경하기


http://ra2kstar.tistory.com/97


mysql> show variables like 'c%';




[MySQL 5.5.9] unknown variable default-character-set


http://forum.directadmin.com/showthread.php?t=39800

http://dev.mysql.com/doc/refman/5.5/en/server-options.html#option_mysqld_default-character-set


/etc/my.cnf 파일의 내용


[mysql]
default-character-set = utf8

[mysqld]
lower_case_table_names=1
character-set-client-handshake=FALSE
init_connect="SET collation_connection = utf8_general_ci"
init_connect="SET NAMES utf8"
character-set-server = utf8
collation-server = utf8_general_ci

datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=root

# Disabling symbolic-links is recommended to prevent assorted security risks;
# to do so, uncomment this line:
symbolic-links=0

[client]
default-character-set = utf8

[mysqldump]
default-character-set = utf8

[mysqld_safe]


Comments