21. 변경된 character-set이 정상적으로 적용되었는지 MySQL을 재실행해서 status 명령어를 이용해 확인합니다. 정상적으로 utf8로 변경되어 있습니다.
root@controller:~# 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: utf8
Db characterset: utf8
Client characterset: utf8
Conn. characterset: utf8
UNIX socket: /var/run/mysqld/mysqld.sock
Uptime: 1 min 19 sec
Threads: 1 Questions: 91 Slow queries: 0 Opens: 15 Flush tables: 1 Open
tables: 78 Queries per second avg: 1.151
MariaDB [(none)]> exit;