MariaDB UTF8 관련 Error 설정

my.ini 경로 :  C:\Program Files\MariaDB 11.4\data\my.ini

 

수정전 발생했던  Error

error: 1118-42000

errno: 150 "Foreign key constraint is incorrectly formed"

Error: 1005-HY000: Can't create table

 

【my.ini】를 아래와 같이 수정 후 서비스에서 MariaDB 재기동

[mysqld]
datadir=C:/Program Files/MariaDB 11.4/data
port=3306
innodb_buffer_pool_size=497M
init_connect="SET collation_connection = utf8_general_ci"
init_connect="SET NAMES utf8"
character-set-server = utf8
collation-server = utf8_general_ci

[client]
port=3306
plugin-dir=C:\Program Files\MariaDB 11.4/lib/plugin
default-character-set=utf8
default-character-set = utf8

[mysqldump]
default-character-set = utf8

[mysql]
default-character-set = utf8