MySQL保存emoji表情之Linux设置数据库编码为utf8

编辑my.cnf
(我服务器的)路径：/usr/local/mysql/my.cnf

[client]
default-character-set = utf8mb4
[mysql]
default-character-set = utf8mb4
[mysqld]
character-set-client-handshake = FALSE
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci
init_connect='SET NAMES utf8mb4'

重启Mysql服务

service mysql restart