{"id":1261,"date":"2019-04-29T15:29:52","date_gmt":"2019-04-29T06:29:52","guid":{"rendered":"http:\/\/www.white-box.biz\/?p=1261"},"modified":"2022-04-16T20:12:22","modified_gmt":"2022-04-16T11:12:22","slug":"mariadb%e3%81%ae%e3%83%86%e3%83%bc%e3%83%96%e3%83%ab%e6%9a%97%e5%8f%b7%e5%8c%96","status":"publish","type":"post","link":"https:\/\/www.white-box.biz\/?p=1261","title":{"rendered":"mariadb\u306e\u30c6\u30fc\u30d6\u30eb\u6697\u53f7\u5316"},"content":{"rendered":"

mariadb\u3067\u30c6\u30fc\u30d6\u30eb\u3092\u6697\u53f7\u5316\u3059\u308b\u6642\u306e\u304a\u3055\u3089\u3044\u3002<\/p>\n

 <\/p>\n

\/etc\/my.cnf.d\/server.cnf<\/p>\n

[mysqld]\u30bb\u30ad\u30e5\u30b7\u30e7\u30f3\u306b\u4e0b\u8a18\u3092\u8ffd\u52a0<\/p>\n

plugin-load-add = file_key_management.so<\/p>\n

file-key-management-filename = \/etc\/my.cnf.d\/keys.txt<\/p>\n

#\u30c6\u30fc\u30d6\u30eb\u306e\u6697\u53f7\u5316...ON:\u6709\u52b9\u3001OFF:\u7121\u52b9\u3001FORCE:\u6697\u53f7\u5316\u304c\u8a2d\u5b9a\u3055\u308c\u3066\u3044\u306a\u3044\u30c6\u30fc\u30d6\u30eb\u306e\u4f5c\u6210\u3092\u8a31\u53ef\u3057\u306a\u3044
\ninnodb-encrypt-tables = ON
\n#InnoDB\/XtraDB \u30ed\u30b0\u30d5\u30a1\u30a4\u30eb\u306e\u6697\u53f7\u5316...1:\u6709\u52b9\u30010:\u7121\u52b9
\ninnodb-encrypt-log = 1
\n#\u4e00\u6642\u30c6\u30fc\u30d6\u30eb\u306e\u6697\u53f7\u5316...1:\u6709\u52b9\u30010:\u7121\u52b9
\nencrypt-tmp-disk-tables = 0
\n#\u4e00\u6642\u30d5\u30a1\u30a4\u30eb\u306e\u6697\u53f7\u5316...1:\u6709\u52b9\u30010:\u7121\u52b9
\nencrypt-tmp-files = 0
\n#\u30d0\u30a4\u30ca\u30ea\u30ed\u30b0\/\u30ea\u30ec\u30fc\u30ed\u30b0\u306e\u6697\u53f7\u5316...1:\u6709\u52b9\u30010:\u7121\u52b9
\nencrypt-binlog = 0<\/code><\/p><\/blockquote>\n

 <\/p>\n

\/etc\/my.cnf.d\/keys.txt\u3092\u4f5c\u308b<\/p>\n

\u4e2d\u8eab\u306f\u4e0b\u8a18\u306e\u3088\u3046\u306a\u611f\u3058<\/p>\n

1;aaaa;bbbbbb<\/code><\/p><\/blockquote>\n

 <\/p>\n

\u4e0b\u8a18\u30b3\u30de\u30f3\u30c9\u3067\u4f5c\u308c\u308b<\/p>\n

openssl enc -aes-256-cbc -k Password@generate -P -md sha256<\/p>\n

salt=E41EBEDBD908FEBE
\nkey=bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb\u3000\u2190\u3000bbbbbb\u306e\u6240\u306b\u5165\u308c\u308b
\niv =aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa\u3000\u2190\u3000aaaa\u306e\u6240\u306b\u5165\u308c\u308b<\/code><\/p><\/blockquote>\n

 <\/p>\n

alter\u3067\u30c6\u30fc\u30d6\u30eb\u3092\u6697\u53f7\u5316\u3059\u308b\u3002<\/p>\n

\u00a0ALTER TABLE \u30c6\u30fc\u30d6\u30eb\u540d ENCRYPTED=YES ENCRYPTION_KEY_ID=1;<\/code><\/p><\/blockquote>\n

 <\/p>\n

keys.txt\u306e\u884c\u982d1\u306b\u5bfe\u5fdc\u3057\u3066\u3044\u308b\u3002keys.txt\u306b\u306f\u8907\u6570\u30ad\u30fc\u3092\u5b9a\u7fa9\u3067\u304d\u308b\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"

mariadb\u3067\u30c6\u30fc\u30d6\u30eb\u3092\u6697\u53f7\u5316\u3059\u308b\u6642\u306e\u304a\u3055\u3089\u3044\u3002   \/etc\/my.cnf.d\/server.cnf [mysqld]\u30bb\u30ad\u30e5\u30b7\u30e7\u30f3\u306b\u4e0b\u8a18\u3092\u8ffd\u52a0 plugin-load-add = file_key_mana[\u30fb\u30fb\u30fb\u7d9a\u304d\u3092\u8aad\u3080]<\/b><\/a><\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t