Configure Character set and Collation for Mysql 5.6.

Configure Character set and Collation for Mysql 5.6.

# vi /etc/my.cnf

[client]
default-character-set=utf8

[mysql]
default-character-set=utf8

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
symbolic-links=0
character-set-server=utf8
collation-server=utf8_unicode_ci
skip-character-set-client-handshake
init-connect=’SET NAMES utf8′
init_connect=’SET collation_connection = utf8_unicode_ci’
general_log=1
general_log_file=/var/log/mysql/mysqld.log
log_error=/var/log/mysql/mysql_err.log

Be the first to comment

Leave a Reply