MySQL UTF8 Setting Update

2 分钟 阅读

I wrote a post about setting default character and encoding of MySQL to utf8 on OS X, here. But there is a better way to do this instead of modifying the default my.cnf file directly on Ubuntu.

the last line of my.cnf file /etc/mysql/ is

!includedir /etc/mysql/conf.d/

which indicate it will includes any setting files under folder conf.d. So create a file named utf8_charset.cnf or whatever name you like, put these lines into the file

[mysqld]
character-set-server=utf8
collation-server=utf8_general_ci

[client]
default-character-set=utf8

Restart mysql, and these setting will be in effect.

The benefit of putting these settings into a seperate file is that these settings will survive when you upgrade your mysql.

留下评论