MySQL 기본 캐릭터 셋 설정

# vi /etc/my.cnf

[mysqld]

character-set-server = utf8mb4

 

[client]

default-character-set = utf8mb4

[mysqldump]
default-character-set = utf8mb4

[mysql]
default-character-set = utf8mb4

 

# systemctl restart mysqld

 

mysql> status;

Server characterset: utf8mb4
Db     characterset: utf8mb4
Client characterset: utf8mb4
Conn.  characterset: utf8mb4