my.ini下添加

[mysqld]
character-set-server=utf8mb4

设置前后的对比

用命令查看一下

SHOW VARIABLES WHERE Variable_name LIKE 'character\_set\_%' OR Variable_name LIKE 'collation%';