vi /etc/mysql/conf.d/charset.cnf [client] default-character-set = utf8mb4 [mysql] default-character-set = utf8mb4 [mysqld] skip-character-set-client-handshake init_connect="SET collation_connection = utf8mb4_unicode_ci" init_connect="SET NAMES utf8mb4 COLLATE utf8mb4_unicode_ci" character-set-server = utf8mb4 collation-server = utf8mb4_unicode_ci [mysqldump] default-character-set = utf8mb4