24. 그래서 MySQL에 접속해 status 명령어로 확인해 보았습니다. 서버와 데이터베이스 character- set은 latin1로, Client와 Conn.의 characterset은 utf8로 설정되어 있습니다.
root@controller:~# cd /etc/mysql/mariadb.conf.d root@controller:/etc/mysql/mariadb.conf.d# mysql -u root -popenstack Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 32 Server version: 10.0.24-MariaDB-7 Ubuntu 16.04
Copyright © 2000, 2016, Oracle, MariaDB Corporation Ab and others.
Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.
MariaDB [(none)]> status;
mysql Ver 15.1 Distrib 10.0.24-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2
Connection id: 32 Current database: Current user: root@localhost SSL: Not in use Current pager: stdout Using outfile: “ Using delimiter: ; Server: MariaDB Server version: 10.0.24-MariaDB-7 Ubuntu 16.04 Protocol version: 10 Connection: Localhost via UNIX socket Server characterset: latin1 Db characterset: latin1 Client characterset: utf8 Conn. characterset: utf8 UNIX socket: /var/run/mysqld/mysqld.sock Uptime: 31 sec
Threads: 1 Questions: 91 Slow queries: 0 Opens: 15 Flush tables: 1 Open tables: 78 Queries per second avg: 2.935 ————–