ubuntu 下设置mysql 编码为utf8

sudo gedit /etc/mysql/my.cnf

[client]
default-character-set=utf8

 

[mysqld_safe]
default-character-set=utf8

[mysqld]
character-set-server=utf8 （亮点在这）
init_connect='SET NAMES utf8'

[mysql]
default-character-set=utf8

service mysql restart

或者

/etc/init.d/mysql start (stop)

show variables like 'character%';