1. Check the character_set of MariaDB.
mysql[none]> show variables like '%character_set_%';
2.Set permanent charset.
$ vi /etc/my.cnf.d/client.cnf
[client]
default-character-se=utf8
$ vi /etc/my.cnf.d/server.cnf
[mysqld]
character-set-server=utf8
3.Restart MySQL service.
$ systemctl restart mysql
4.Set databases’ charset.
mysql> SET charater_set_database = 'utf8';