MariaDB how to set encoding?

Question

MariaDB

When editing the file /etc/my.cnf.d/server.cnf I add
the item
character_set_connection = utf 8 I
restart the MySQL VDS server crashes ....
What's the catch?
Where to enter this line?
Tried many options already

Answer 1

character_set_connection - Shouldn't be set at all. Of course, how will the sql server be started if such a variable does not exist in the mysql (mariadb) config!
in the [client] section write:
in the [mysqld] section write:

character-set-server=utf8
collation-server=utf8_general_ci
init-connect="SET NAMES utf8"
skip-character-set-client-handshake

in the [mysqldump] section (if used) write:
in the [mysql] section write:
ps and also erase all the lines where 1251 is mentioned (if there are any)