vi /etc/my.cnf

在 [mysqld] 字段下面添加类似于这样

[mysqld]
//添加下面这三行到[mysqld]字段
collation-server = utf8_unicode_ci  
init-connect='SET NAMES utf8'  
character-set-server = utf8  
//重启mariadb
# systemctl restart mariadb
//登陆查看下是否改变为utf-8
# mysql -u root -p
# show variables like 'char%';
# show variables like 'collation%';