[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
secure_file_priv=‘‘
max_allowed_packet = 10M
character-set-server = utf8mb4
collation-server = utf8mb4_general_ci
#collation-server = utf8mb4_unicode_ci
character-set-client-handshake = FALSE
character-set-server = utf8mb4
init_connect=’SET NAMES utf8mb4’
[client]
default-character-set = utf8mb4
[mysql]
default-character-set = utf8mb4
原文:https://blog.51cto.com/mjunetwslinux/2443249