mariadb设置字符集为utf8mb4

admin

http://blog.csdn.net/aoerqileng/article/details/52709774

编辑server.cnf

[mariadb-10.0]
character-set-client-handshake = FALSE
character_set_server = utf8mb4
#character_set_results = utf8mb4
character_set_filesystem = utf8mb4
#character_set_database = utf8mb4
#character_set_connection = utf8mb4
character_set_client = utf8mb4
character-set-client-handshake = 0
collation_server = utf8mb4_unicode_ci

default-time-zone = '+8:00'

admin

编辑/etc/my.cnf

在mysqld里面增加
character-set-client-handshake = FALSE
character_set_server = utf8mb4
#character_set_results = utf8mb4
character_set_filesystem = utf8mb4
#character_set_database = utf8mb4
#character_set_connection = utf8mb4
character_set_client = utf8mb4
character-set-client-handshake = 0
collation_server = utf8mb4_unicode_ci

default-time-zone = '+8:00'

然后重启mariadb数据库
systemctl restart mariadb.service
就好了


我还设置了其他的
[client]
default-character-set = utf8mb4

[mysql]
default-character-set = utf8mb4