1.设置编码utf8mb4_unicode_ci
2.vi /etc/my.cnf 修改my.cnf:
[client]
default-character-set = utf8mb4
[mysql]
default-character-set = utf8mb4
[mysqld]
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci
3.service mysqld restart 重启
1.设置编码utf8mb4_unicode_ci
2.vi /etc/my.cnf 修改my.cnf:
[client]
default-character-set = utf8mb4
[mysql]
default-character-set = utf8mb4
[mysqld]
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci
3.service mysqld restart 重启