MariaDB chinese messy code problem

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';