본문 바로가기

와사비크래커 IT Tip/DB

mariadb utf8 변경

728x90
반응형
vi /etc/my.cnf

[mysqld]
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

[mysqldump]
default-character-set = utf8

[mysql]
default-character-set = utf8



vi /{mysql_home}/data/{db_name}/db_name.opt

default-character-set=utf8

default-collation=utf8_general_ci


반응형

'와사비크래커 IT Tip > DB' 카테고리의 다른 글