修改mysql数据库为utf8

2019独角兽企业重金招聘Python工程师标准>>>

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

现在是gbk

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

[client]

port = 3306

socket = /var/lib/mysql/mysql.sock

default-character-set=utf8

[mysqld]

port = 3306

socket = /var/lib/mysql/mysql.sock

character-set-server=utf8

[mysql]

no-auto-rehash

default-character-set=utf8

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

sudo /etc/init.d/mysql restart

 

更改之后是utf8

转载于:https://my.oschina.net/liuyuantao/blog/735827