查看编码
mysql> show variables like 'character%';
编辑mysql的配置文件
vi /etc/my.cnf
[client]
#password = your_password
port = 3306
socket = /var/lib/mysql/mysql.sock
default-character-set=utf8 #设置默认编码为UTF8
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
default-character-set=utf8 (mysql5.1及之前的版本用这个)
character-set-server=utf8 (mysql5.5用这个)
init_connect='SET NAMES utf8'
保存
重启mysql即可