25. 이번에는 keystone 명령어로 데이터베이스를 전환하고 Keystone 데이터베이스의 status를 확인해 보았습니다. 서버의 characterset은 latin1로 설정되어 있으나 DB characterset은 기존 utf8mb4로 설정되어 있습니다.
MariaDB [(none)]> use keystone;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
MariaDB [keystone]> 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: keystone 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: utf8mb4 Client characterset: utf8 Conn. characterset: utf8 UNIX socket: /var/run/mysqld/mysqld.sock Uptime: 52 sec
Threads: 1 Questions: 98 Slow queries: 0 Opens: 16 Flush tables: 1 Open
tables: 79 Queries per second avg: 1.884
MariaDB [keystone]> exit;