1.将已经建好的表也转换成utf8mb4
命令:ALTER TABLE `TABLE_NAME` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci; (将TABLE_NAME替换成你的表名)
2.修改所需字段为utf8mb4
ALTER TABLE app_message MODIFY title VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '标题';
3.修改mysql配置:vim /etc/my.cnf
init-connect='SET NAMES utf8mb4'
character-set-server=utf8mb4
4.重启mysql
service mysqld restart