centos修改mysql字符集 解决中文乱码问题

1.修改 my.cnf mysql的配置文件

[client]default-character-set=utf8[mysqld]datadir=/var/lib/mysqlsocket=/var/lib/mysql/mysql.sockuser=mysql# Disabling symbolic-links is recommended to prevent assorted security riskssymbolic-links=0default-storage-engine=InnoDBcharacter-set-server=utf8collation-server=utf8_general_ci[mysqld_safe]log-error=/var/log/mysqld.logpid-file=/var/run/mysqld/mysqld.pid

注意带utf8的三行。

2.关闭服务

service mysqld stop

3.重启服务

service mysqld start