ERPNext installation Mariadb config issue

I have installed and configured collation in my.conf. still getting collation error.
Attached is the error screen shot

Check if this helps MariaDB conf for Frappe · frappe/bench Wiki · GitHub

Thanks @revant_one, i have all the entries in my.cnf, still no luck

What version of MariaDB server?

See the collection-server

sudo nano /etc/mysql/my.cnf

character-set-client-handshake = FALSE
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci
 #this block should be in bottom
 default-character-set = utf8mb4

 systemctl restart mariadb

Thanks for your comments, i resolved this issue by copying my.cnf to mariadb.conf.d directory