在my.cnf中***

Default Homebrew MySQL server config

[mysqld]

Only allow connections from localhost

bind-address = 127.0.0.1

########################################

MySQL 支持emoji

character-set-client-handshake = FALSE
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci
init_connect='SET NAMES utf8mb4'

[client]
default-character-set = utf8mb4

[mysql]
default-character-set = utf8mb4

########################################