[root@kvm3 ~]# cat /etc/my.cnf # # This group is read both both by the client and the server # use it for options that affect everything # [client-server] # # include all files from the config directory # !includedir /etc/my.cnf.d
[root@kvm3 ~]# ll /etc/my.cnf.d/ total 20 -rw-r--r--. 1 root root 41 Jun 24 2019 auth_gssapi.cnf -rw-r--r--. 1 root root 295 May 14 2019 client.cnf -rw-r--r--. 1 root root 763 Nov 17 2018 enable_encryption.preset -rw-r--r--. 1 root root 1458 Jun 24 2019 mariadb-server.cnf -rw-r--r--. 1 root root 232 Nov 17 2018 mysql-clients.cnf
[root@kvm3 ~]# vim /etc/my.cnf.d/mariadb-server.cnf [root@kvm3 ~]# grep '^\[mysqld\]' -A6 /etc/my.cnf.d/mariadb-server.cnf [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock log-error=/var/log/mariadb/mariadb.log pid-file=/run/mariadb/mariadb.pid collation-server=utf8_general_ci character-set-server=utf8
[root@kvm3 ~]# vim /etc/my.cnf.d/mysql-clients.cnf [root@kvm3 ~]# grep '^\[mysql\]' -A1 /etc/my.cnf.d/mysql-clients.cnf [mysql] default-character-set=utf8
[root@kvm3 ~]# systemctl restart mariadb.service