1、安装mysql之后默认的字符编码为latin1
登录mysql可以通过show variables like ‘%char%’查看,显示如下
2、进入/usr/share/mysql目录之后,拷贝my-medium.cnf 到/etc下,如果没有该文件则是my-default.cnf
在最后添加
[client]
#password = your_password
port = 3306
#++++++++++++++++++++++++++++++++
default-character-set=utf8
#++++++++++++++++++++++++++++++++
socket = /var/lib/mysql/mysql.sock
[mysqld]
port = 3306
socket = /var/lib/mysql/mysql.sock
#++++++++++++++++++++++++++++++++
character-set-server=utf8
character-set-client=utf8
collation-server=utf8_general_ci
#++++++++++++++++++++++++++++++++
skip-external-locking
[mysql]
no-auto-rehash
#Remove the next comment character if you are not familiar with SQL
#safe-updates
#++++++++++++++++++++++++++++++++
default-character-set=utf8
#++++++++++++++++++++++++++++++++
保存退出
3、重启mysql服务
service mysql restart
4、再次登录mysql,通过show variables like '%char%'查看,显示如下
ok,解决完毕