- 查看编码
show variables like '%char%';
- 将所有编码设置为 UTF-8
vi /etc/my.cnf
[mysql]
default-character-set=utf8
[client]
default-character-set=utf8
[mysqld]
character_set_server=utf8
character_set_client=utf8
collation_server=utf8_general_ci
- 重启 mysql
service mysql restart
- 再次查看字符编码集
show variables like '%char%';
- 编码修改只对之后生成的数据库有效