/opt/homebrew/etc/my.cnf.d/charset.cnf

[mysqld]
# 基础设置
character-set-server = utf8mb4
collation-server = utf8mb4_general_ci

# 关键：覆盖 utf8mb4 的默认排序规则映射
character_set_collations = utf8mb4=utf8mb4_general_ci

# 确保忽略客户端设置
skip-character-set-client-handshake

[client]
default-character-set = utf8mb4

[mysql]
default-character-set = utf8mb4