1、修改数据库配置文件/etc/my.cnf
character-set-server = utf8mb4
collation-server = utf8mb4_general_ci
2、修改库
alter database 库名 CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
3、修改表
alter table 表名 convert to character set utf8mb4 COLLATE utf8mb4_general_ci;