{"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":"<p>mariadb\u3067\u30c6\u30fc\u30d6\u30eb\u3092\u6697\u53f7\u5316\u3059\u308b\u6642\u306e\u304a\u3055\u3089\u3044\u3002<\/p>\n<p>&nbsp;<\/p>\n<p>\/etc\/my.cnf.d\/server.cnf<\/p>\n<p>[mysqld]\u30bb\u30ad\u30e5\u30b7\u30e7\u30f3\u306b\u4e0b\u8a18\u3092\u8ffd\u52a0<\/p>\n<blockquote><p><code>plugin-load-add = file_key_management.so<\/p>\n<p>file-key-management-filename = \/etc\/my.cnf.d\/keys.txt<\/p>\n<p>#\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<br \/>\ninnodb-encrypt-tables = ON<br \/>\n#InnoDB\/XtraDB \u30ed\u30b0\u30d5\u30a1\u30a4\u30eb\u306e\u6697\u53f7\u5316...1:\u6709\u52b9\u30010:\u7121\u52b9<br \/>\ninnodb-encrypt-log = 1<br \/>\n#\u4e00\u6642\u30c6\u30fc\u30d6\u30eb\u306e\u6697\u53f7\u5316...1:\u6709\u52b9\u30010:\u7121\u52b9<br \/>\nencrypt-tmp-disk-tables = 0<br \/>\n#\u4e00\u6642\u30d5\u30a1\u30a4\u30eb\u306e\u6697\u53f7\u5316...1:\u6709\u52b9\u30010:\u7121\u52b9<br \/>\nencrypt-tmp-files = 0<br \/>\n#\u30d0\u30a4\u30ca\u30ea\u30ed\u30b0\/\u30ea\u30ec\u30fc\u30ed\u30b0\u306e\u6697\u53f7\u5316...1:\u6709\u52b9\u30010:\u7121\u52b9<br \/>\nencrypt-binlog = 0<\/code><\/p><\/blockquote>\n<p>&nbsp;<\/p>\n<p>\/etc\/my.cnf.d\/keys.txt\u3092\u4f5c\u308b<\/p>\n<p>\u4e2d\u8eab\u306f\u4e0b\u8a18\u306e\u3088\u3046\u306a\u611f\u3058<\/p>\n<blockquote><p><code>1;aaaa;bbbbbb<\/code><\/p><\/blockquote>\n<p>&nbsp;<\/p>\n<p>\u4e0b\u8a18\u30b3\u30de\u30f3\u30c9\u3067\u4f5c\u308c\u308b<\/p>\n<p>openssl enc -aes-256-cbc -k Password@generate -P -md sha256<\/p>\n<blockquote><p><code>salt=E41EBEDBD908FEBE<br \/>\nkey=bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb\u3000\u2190\u3000bbbbbb\u306e\u6240\u306b\u5165\u308c\u308b<br \/>\niv =aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa\u3000\u2190\u3000aaaa\u306e\u6240\u306b\u5165\u308c\u308b<\/code><\/p><\/blockquote>\n<p>&nbsp;<\/p>\n<p>alter\u3067\u30c6\u30fc\u30d6\u30eb\u3092\u6697\u53f7\u5316\u3059\u308b\u3002<\/p>\n<blockquote><p><code>\u00a0ALTER TABLE \u30c6\u30fc\u30d6\u30eb\u540d ENCRYPTED=YES ENCRYPTION_KEY_ID=1;<\/code><\/p><\/blockquote>\n<p>&nbsp;<\/p>\n<p>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":"<p>mariadb\u3067\u30c6\u30fc\u30d6\u30eb\u3092\u6697\u53f7\u5316\u3059\u308b\u6642\u306e\u304a\u3055\u3089\u3044\u3002 &nbsp; \/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<a href=\"https:\/\/www.white-box.biz\/?p=1261\"><b>[\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":[],"_links":{"self":[{"href":"https:\/\/www.white-box.biz\/index.php?rest_route=\/wp\/v2\/posts\/1261"}],"collection":[{"href":"https:\/\/www.white-box.biz\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.white-box.biz\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.white-box.biz\/index.php?rest_route=\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.white-box.biz\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1261"}],"version-history":[{"count":6,"href":"https:\/\/www.white-box.biz\/index.php?rest_route=\/wp\/v2\/posts\/1261\/revisions"}],"predecessor-version":[{"id":2351,"href":"https:\/\/www.white-box.biz\/index.php?rest_route=\/wp\/v2\/posts\/1261\/revisions\/2351"}],"wp:attachment":[{"href":"https:\/\/www.white-box.biz\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1261"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.white-box.biz\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1261"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.white-box.biz\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1261"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}