COLLATION 'utf8_unicode_ci' is not valid for CHARACTER SET 'utf8mb4'

原因：数据库编码不一致

查看字符集：

 

 

解决办法：修改配置文件(追加以下内容)

vi /etc/my.cnf


[client]
default-character-set=utf8mb4

[mysqld]
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci
init_connect='SET NAMES utf8mb4'
skip-character-set-client-handshake = true

[mysql]
default-character-set = utf8mb4

修改后重新查看字符集

show variables like 'character\_set\_%'; 

 

 

 

重启服务重新测试