더북(TheBook)

13. 다시 /etc/mysql/mariadb.conf.d 디렉터리의 환경설정 파일들을 살펴보겠습니다.

root@controller:~# cd /etc/mysql/mariadb.conf.d
root@controller:/etc/mysql/mariadb.conf.d# ll
total 24
drwxr-xr-x 2 root root 4096 May 30 21:30 ./
drwxr-xr-x 4 root root 4096 May 30 21:38 ../
-rw-r–r– 1 root root  495 Feb  9 00:36 50-client.cnf
-rw-r–r– 1 root root  336 Feb  9 00:36 50-mysql-clients.cnf
-rw-r–r– 1 root root  321 Feb  9 00:36 50-mysqld_safe.cnf
-rw-r–r– 1 root root 3493 May 30 21:30 50-server.cnf


14. 가장 먼저 보이는 50-client.cnf 파일을 살펴보겠습니다. 역시나 default-character-set이 utf8mb4로 설정되어 있습니다.

root@controller:/etc/mysql/mariadb.conf.d# cat 50-client.cnf
#

This group is read by the client library

Use it for options that affect all clients, but not the server

#

[client]

Default is Latin1, if you need UTF-8 set this (also in server section)

default-character-set = utf8mb4

This group is never read by mysql client library, though this

/etc/mysql/mariadb.cnf.d/client.cnf file is not read by Oracle MySQL

client anyway.

If you use the same .cnf file for MySQL and MariaDB,

use it for MariaDB-only client options

[client-mariadb]

신간 소식 구독하기
뉴스레터에 가입하시고 이메일로 신간 소식을 받아 보세요.