와사비크래커 IT Tip/DB
2017. 11. 21.
mariadb utf8 변경
vi /etc/my.cnf [mysqld]character-set-client-handshake=FALSEinit_connect="SET collation_connection = utf8_general_ci"init_connect="SET NAMES utf8"character-set-server = utf8collation-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=utf8default-collation=utf8_general_ci