修改mysql数据库为utf8

1.登录MySQL查看用show variables like "character_set%";

现在是gbk

2.修改mysql的my.cnf文件中的字符集键值

[client]port = 3306socket = /var/lib/mysql/mysql.sockdefault-character-set=utf8  [mysqld]port = 3306socket = /var/lib/mysql/mysql.sockcharacter-set-server=utf8    [mysql]no-auto-rehashdefault-character-set=utf8

3.修改完成后，service mysql restart重启mysql服务就生效。




更改之后是utf8