MariaDB 한글 깨짐 해결 방법

systemctl restart mariadb
systemctl restart mariadb.service​

systemctl restart mairadb
systemctl restart maridb.service

MariaDB 한글 깨짐 해결 방법

 

MariaDB 들어간 후 status로 보면 latin1로 되어있는 것을 UTF-8로 변경해야 한다.

Server, Db characterset 이 latin1로 설정되어 있기 때문에 변경이 필요하다.

 

vim /etc/my.cnf

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
# Settings user and group are ignored when systemd is used.
# If you need to run mysqld under a different user or group,
# customize your systemd unit file for mariadb according to the
# instructions in http://fedoraproject.org/wiki/Systemd
#

[mysqld_safe]
log-error=/var/log/mariadb/mariadb.log
pid-file=/var/run/mariadb/mariadb.pid

#
# include all files from the config directory
#
!includedir /etc/my.cnf.d

 

[mysqld] 항목 맨아래에 다음부분 추가  <== 이 섹션 없으면 추가

init_connect="SET collation_connection = utf8_general_ci"
init_connect="SET NAMES utf8"
character-set-server = utf8
collation-server = utf8_general_ci

[mysqldump]
default-character-set=utf8

 

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
# Settings user and group are ignored when systemd is used.
# If you need to run mysqld under a different user or group,
# customize your systemd unit file for mariadb according to the
# instructions in http://fedoraproject.org/wiki/Systemd
#
init_connect="SET collation_connection = utf8_general_ci"
init_connect="SET NAMES utf8"
character-set-server = utf8
collation-server = utf8_general_ci

[mysqld_safe]
log-error=/var/log/mariadb/mariadb.log
pid-file=/var/run/mariadb/mariadb.pid

[mysqldump]
default-character-set=utf8
#
# include all files from the config directory
#
!includedir /etc/my.cnf.d

 

 

status로 보면 Server, Db charaterset이 utf8로 변경된 것을 확인 할 수 있다.

MariaDB [(none)]> alter database myshop character set utf8 collate utf8_general_ci;
Query OK, 1 row affected (0.000 sec)

 

MariaDB [myshop]> status
--------------
mysql  Ver 15.1 Distrib 10.5.22-MariaDB, for Linux (x86_64) using  EditLine wrapper

Connection id:		3
Current database:	myshop
Current user:		root@localhost
SSL:			Not in use
Current pager:		stdout
Using outfile:		''
Using delimiter:	;
Server:			MariaDB
Server version:		10.5.22-MariaDB MariaDB Server
Protocol version:	10
Connection:		Localhost via UNIX socket
Server characterset:	utf8
Db     characterset:	utf8
Client characterset:	utf8
Conn.  characterset:	utf8
UNIX socket:		/var/lib/mysql/mysql.sock
Uptime:			11 sec