[MySQL] 로컬에 설치된 MySql 한글처리

[MySQL] 로컬에 설치된 MySql 한글처리

1. 파일열기
C:\Program Files\MariaDB 10.6\bin\my.ini 

2. 아래와 같이 수정

[mysqld]
datadir=C:/Program Files/MariaDB 10.6/data
port=8835
innodb_buffer_pool_size=4077M
innodb_strict_mode = 0
innodb_log_file_size = 512M
character-set-server=utf8
general_log=ON

log_bin_trust_function_creators = TRUE

character-set-client-handshake = FALSE
init_connect="SET collation_connection = utf8_general_ci"
init_connect="SET NAMES utf8"
character-set-server = utf8

[client]
port=8835
plugin-dir=C:/Program Files/MariaDB 10.6/lib/plugin
default-character-set = utf8


[mysql]
default-character-set = utf8


[mysqldump]
default-character-set = utf8

3. 시스템 재시작