{"id":5119,"date":"2020-11-04T08:36:18","date_gmt":"2020-11-03T23:36:18","guid":{"rendered":"https:\/\/www.manageengine.jp\/support\/kb\/EventLog_Analyzer\/?p=5119"},"modified":"2020-12-28T16:45:33","modified_gmt":"2020-12-28T07:45:33","slug":"mysql%e7%9b%a3%e8%a6%96%e3%81%ab%e5%bf%85%e8%a6%81%e3%81%aa%e6%89%8b%e9%a0%86","status":"publish","type":"post","link":"https:\/\/www.manageengine.jp\/support\/kb\/EventLog_Analyzer\/?p=5119","title":{"rendered":"MySQL\u76e3\u8996\u306b\u5fc5\u8981\u306a\u624b\u9806"},"content":{"rendered":"<p><strong>\u5bfe\u8c61\u30d3\u30eb\u30c9: 12100\u4ee5\u4e0a<\/strong><\/p>\n<p>MySQL\u30b5\u30fc\u30d0\u30fc\u3092\u767b\u9332\u3059\u308b\u3053\u3068\u3067\u3001MySQL\u306e\u4e00\u822c\u30af\u30a8\u30ea\u30ed\u30b0\u3068\u30a8\u30e9\u30fc\u30ed\u30b0\u3092\u76e3\u8996\u3067\u304d\u307e\u3059\u3002<br \/>\n\u672c\u30ca\u30ec\u30c3\u30b8\u3067\u306f\u3001MySQL\u30b5\u30fc\u30d0\u30fc\u306e\u767b\u9332\u65b9\u6cd5\u3068\u7ba1\u7406\u65b9\u6cd5\u3092\u7d39\u4ecb\u3057\u307e\u3059\u3002<\/p>\n<p>&nbsp;<\/p>\n<div style=\"padding: 10px;border: 1px solid #dfdfdf;background-color: #f5f5f5;text-align: left\">\n<p>\u3010\u76ee\u6b21\u3011<\/p>\n<ul>\n<li><a href=\"#mysql\">MySQL\u30b5\u30fc\u30d0\u30fc\u306e\u767b\u9332\u65b9\u6cd5<\/a><\/li>\n<li><a href=\"#log_audit\">\u30ed\u30b0\u76e3\u8996\u9593\u9694\u306e\u5909\u66f4\u624b\u9806<\/a><\/li>\n<li><a href=\"#log_history\">\u30ed\u30b0\u76e3\u8996\u5c65\u6b74\u306e\u78ba\u8a8d\u65b9\u6cd5<\/a><\/li>\n<\/ul>\n<\/div>\n<p>&nbsp;<\/p>\n<h4><a name=\"mysql\"><\/a>\u00a0MySQL\u30b5\u30fc\u30d0\u30fc\u306e\u767b\u9332\u65b9\u6cd5<\/h4>\n<p>1. [ \u8a2d\u5b9a ] &gt; [ \u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u30bd\u30fc\u30b9\u306e\u7ba1\u7406 ] \u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002<\/p>\n<p>2. [ +MySQL\u30b5\u30fc\u30d0\u30fc\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u3092\u8ffd\u52a0\u3059\u308b ] \u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002<\/p>\n<p>3. MySQL\u306e\u60c5\u5831\u3092\u5165\u529b\u3057\u307e\u3059\u3002<\/p>\n<p><a href=\"https:\/\/www.manageengine.jp\/support\/kb\/EventLog_Analyzer\/wp-content\/uploads\/sites\/6\/mysql3.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large wp-image-5124\" src=\"https:\/\/www.manageengine.jp\/support\/kb\/EventLog_Analyzer\/wp-content\/uploads\/sites\/6\/mysql3-1024x534.png\" alt=\"\" width=\"1024\" height=\"534\" srcset=\"https:\/\/www.manageengine.jp\/support\/kb\/EventLog_Analyzer\/wp-content\/uploads\/sites\/6\/mysql3-1024x534.png 1024w, https:\/\/www.manageengine.jp\/support\/kb\/EventLog_Analyzer\/wp-content\/uploads\/sites\/6\/mysql3-300x156.png 300w, https:\/\/www.manageengine.jp\/support\/kb\/EventLog_Analyzer\/wp-content\/uploads\/sites\/6\/mysql3-768x400.png 768w, https:\/\/www.manageengine.jp\/support\/kb\/EventLog_Analyzer\/wp-content\/uploads\/sites\/6\/mysql3.png 1872w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/p>\n[\u30db\u30b9\u30c8]: \u300c\uff0b\u300d\u30de\u30fc\u30af\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066\u3001MySQL\u30b5\u30fc\u30d0\u30fc\u3092\u9078\u629e\u3057\u307e\u3059\u3002<br \/>\n[\u30dd\u30fc\u30c8]:\u00a0 MySQL\u306b\u63a5\u7d9a\u3059\u308b\u969b\u306b\u4f7f\u7528\u3059\u308b\u30dd\u30fc\u30c8\u756a\u53f7\u3092\u5165\u529b\u3057\u307e\u3059\u3002<br \/>\n[\u30d7\u30ed\u30c8\u30b3\u30eb]: MySQL\u306e\u30ed\u30b0\u3092\u53ce\u96c6\u3059\u308b\u969b\u306b\u4f7f\u7528\u3059\u308b\u30d7\u30ed\u30c8\u30b3\u30eb\u3092\u9078\u629e\u3057\u307e\u3059\u3002SMB\u3001FTP\u3001SFTP\u304b\u3089\u9078\u629e\u53ef\u80fd\u3067\u3059\u3002<br \/>\n[\u30e6\u30fc\u30b6\u30fc\u540d\/\u30d1\u30b9\u30ef\u30fc\u30c9]: \u76e3\u8996\u5bfe\u8c61\u30ed\u30b0\u306b\u5bfe\u3057\u3066\u30a2\u30af\u30bb\u30b9\u6a29\u3092\u6709\u3059\u308b\u30e6\u30fc\u30b6\u30fc\u540d\u3068\u30d1\u30b9\u30ef\u30fc\u30c9\u3092\u5165\u529b\u3057\u307e\u3059\u3002<br \/>\n[\u4e00\u822c\u30ed\u30b0\u30d1\u30b9]: \u4e00\u822c\u30af\u30a8\u30ea\u30ed\u30b0\u306e\u30d1\u30b9\u3092\u5165\u529b\u3057\u307e\u3059\u3002<br \/>\n[\u30a8\u30e9\u30fc\u30ed\u30b0]: \u30a8\u30e9\u30fc\u30ed\u30b0\u306e\u30d1\u30b9\u3092\u5165\u529b\u3057\u307e\u3059\u3002<br \/>\n\u203b\u30c1\u30a7\u30c3\u30af\u30dc\u30c3\u30af\u30b9\u306e\u30c1\u30a7\u30c3\u30af\u3092\u5916\u3059\u3053\u3068\u3067\u3001 \u3069\u3061\u3089\u304b\u4e00\u65b9\u306e\u30ed\u30b0\u3060\u3051\u306e\u76e3\u8996\u3082\u53ef\u80fd\u3067\u3059\u3002<\/p>\n[\u8a73\u7d30\u8868\u793a]\u3092\u30af\u30ea\u30c3\u30af\u5f8c\u3001[\u30d5\u30a1\u30a4\u30eb\u306e\u30a8\u30f3\u30b3\u30fc\u30c6\u30a3\u30f3\u30b0]\u3068[\u30bf\u30a4\u30e0\u30be\u30fc\u30f3]\u304c\u9078\u629e\u53ef\u80fd\u3067\u3059\u3002\u5fc5\u8981\u306b\u5fdc\u3058\u3066\u8a2d\u5b9a\u3057\u307e\u3059\u3002<\/p>\n<p>4. [\u78ba\u8a8d\u3057\u3066\u66f4\u65b0]\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002<br \/>\n\u4ee5\u4e0b\u753b\u50cf\u306e\u3088\u3046\u306b\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u304c\u8ffd\u52a0\u3055\u308c\u307e\u3059\u3002<\/p>\n<p><a href=\"https:\/\/www.manageengine.jp\/support\/kb\/EventLog_Analyzer\/wp-content\/uploads\/sites\/6\/mysql9-1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large wp-image-5127\" src=\"https:\/\/www.manageengine.jp\/support\/kb\/EventLog_Analyzer\/wp-content\/uploads\/sites\/6\/mysql9-1-1024x207.png\" alt=\"\" width=\"1024\" height=\"207\" srcset=\"https:\/\/www.manageengine.jp\/support\/kb\/EventLog_Analyzer\/wp-content\/uploads\/sites\/6\/mysql9-1-1024x207.png 1024w, https:\/\/www.manageengine.jp\/support\/kb\/EventLog_Analyzer\/wp-content\/uploads\/sites\/6\/mysql9-1-300x61.png 300w, https:\/\/www.manageengine.jp\/support\/kb\/EventLog_Analyzer\/wp-content\/uploads\/sites\/6\/mysql9-1-768x155.png 768w, https:\/\/www.manageengine.jp\/support\/kb\/EventLog_Analyzer\/wp-content\/uploads\/sites\/6\/mysql9-1.png 1862w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n[\u30ec\u30dd\u30fc\u30c8\u3092\u8868\u793a\u3059\u308b]\u3092\u30af\u30ea\u30c3\u30af\u3059\u308b\u3053\u3068\u3067\u3001MySQL\u306b\u95a2\u3059\u308b\u5b9a\u7fa9\u6e08\u307f\u30ec\u30dd\u30fc\u30c8\u3092\u78ba\u8a8d\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n<p><a href=\"https:\/\/www.manageengine.jp\/support\/kb\/EventLog_Analyzer\/wp-content\/uploads\/sites\/6\/mysql10.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large wp-image-5131\" src=\"https:\/\/www.manageengine.jp\/support\/kb\/EventLog_Analyzer\/wp-content\/uploads\/sites\/6\/mysql10-1024x207.png\" alt=\"\" width=\"1024\" height=\"207\" srcset=\"https:\/\/www.manageengine.jp\/support\/kb\/EventLog_Analyzer\/wp-content\/uploads\/sites\/6\/mysql10-1024x207.png 1024w, https:\/\/www.manageengine.jp\/support\/kb\/EventLog_Analyzer\/wp-content\/uploads\/sites\/6\/mysql10-300x61.png 300w, https:\/\/www.manageengine.jp\/support\/kb\/EventLog_Analyzer\/wp-content\/uploads\/sites\/6\/mysql10-768x155.png 768w, https:\/\/www.manageengine.jp\/support\/kb\/EventLog_Analyzer\/wp-content\/uploads\/sites\/6\/mysql10.png 1862w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/p>\n<p><a href=\"https:\/\/www.manageengine.jp\/support\/kb\/EventLog_Analyzer\/wp-content\/uploads\/sites\/6\/mysql8.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large wp-image-5132\" src=\"https:\/\/www.manageengine.jp\/support\/kb\/EventLog_Analyzer\/wp-content\/uploads\/sites\/6\/mysql8-1024x584.png\" alt=\"\" width=\"1024\" height=\"584\" srcset=\"https:\/\/www.manageengine.jp\/support\/kb\/EventLog_Analyzer\/wp-content\/uploads\/sites\/6\/mysql8-1024x584.png 1024w, https:\/\/www.manageengine.jp\/support\/kb\/EventLog_Analyzer\/wp-content\/uploads\/sites\/6\/mysql8-300x171.png 300w, https:\/\/www.manageengine.jp\/support\/kb\/EventLog_Analyzer\/wp-content\/uploads\/sites\/6\/mysql8-768x438.png 768w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<h4><a name=\"log_audit\"><\/a>\u30ed\u30b0\u76e3\u8996\u9593\u9694\u306e\u5909\u66f4\u624b\u9806<\/h4>\n<p>&nbsp;<\/p>\n<p>1. \u30ed\u30b0\u76e3\u8996\u9593\u9694\u3092\u5909\u66f4\u3057\u305f\u3044\u30b5\u30fc\u30d0\u30fc\u306e\u884c\u3092\u30de\u30a6\u30b9\u30aa\u30fc\u30d0\u30fc\u3059\u308b\u3053\u3068\u3067\u8868\u793a\u3055\u308c\u308b\"\u6642\u8a08\"\u30a2\u30a4\u30b3\u30f3\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002<br \/>\n2. \u30ed\u30b0\u76e3\u8996\u9593\u9694\u3092\u8a2d\u5b9a\u5f8c\u3001[\u4fdd\u5b58]\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002\u6700\u77ed\u76e3\u8996\u9593\u9694\u306f10\u5206\u3067\u3059\u3002<\/p>\n<p><a href=\"https:\/\/www.manageengine.jp\/support\/kb\/EventLog_Analyzer\/wp-content\/uploads\/sites\/6\/mysql5.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large wp-image-5128\" src=\"https:\/\/www.manageengine.jp\/support\/kb\/EventLog_Analyzer\/wp-content\/uploads\/sites\/6\/mysql5-1024x519.png\" alt=\"\" width=\"1024\" height=\"519\" srcset=\"https:\/\/www.manageengine.jp\/support\/kb\/EventLog_Analyzer\/wp-content\/uploads\/sites\/6\/mysql5-1024x519.png 1024w, https:\/\/www.manageengine.jp\/support\/kb\/EventLog_Analyzer\/wp-content\/uploads\/sites\/6\/mysql5-300x152.png 300w, https:\/\/www.manageengine.jp\/support\/kb\/EventLog_Analyzer\/wp-content\/uploads\/sites\/6\/mysql5-768x389.png 768w, https:\/\/www.manageengine.jp\/support\/kb\/EventLog_Analyzer\/wp-content\/uploads\/sites\/6\/mysql5.png 1088w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<h4><a name=\"log_history\"><\/a>\u30ed\u30b0\u76e3\u8996\u5c65\u6b74\u306e\u78ba\u8a8d\u65b9\u6cd5<\/h4>\n<p>&nbsp;<\/p>\n<p>1. \u30ed\u30b0\u76e3\u8996\u5c65\u6b74\u3092\u78ba\u8a8d\u3057\u305f\u3044\u30b5\u30fc\u30d0\u30fc\u306e\u884c\u3092\u30de\u30a6\u30b9\u30aa\u30fc\u30d0\u30fc\u3059\u308b\u3053\u3068\u3067\u8868\u793a\u3055\u308c\u308b\"\u5c65\u6b74\u3092\u8868\u793a\"\u30a2\u30a4\u30b3\u30f3\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\u3002<\/p>\n<p><a href=\"https:\/\/www.manageengine.jp\/support\/kb\/EventLog_Analyzer\/wp-content\/uploads\/sites\/6\/mysql6.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large wp-image-5129\" src=\"https:\/\/www.manageengine.jp\/support\/kb\/EventLog_Analyzer\/wp-content\/uploads\/sites\/6\/mysql6-1024x652.png\" alt=\"\" width=\"1024\" height=\"652\" srcset=\"https:\/\/www.manageengine.jp\/support\/kb\/EventLog_Analyzer\/wp-content\/uploads\/sites\/6\/mysql6-1024x652.png 1024w, https:\/\/www.manageengine.jp\/support\/kb\/EventLog_Analyzer\/wp-content\/uploads\/sites\/6\/mysql6-300x191.png 300w, https:\/\/www.manageengine.jp\/support\/kb\/EventLog_Analyzer\/wp-content\/uploads\/sites\/6\/mysql6-768x489.png 768w, https:\/\/www.manageengine.jp\/support\/kb\/EventLog_Analyzer\/wp-content\/uploads\/sites\/6\/mysql6.png 1150w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/p>\n<p>2. [\u3082\u3063\u3068\u8868\u793a]\u3092\u30af\u30ea\u30c3\u30af\u3059\u308b\u3053\u3068\u3067\u3001\u3088\u308a\u8a73\u7d30\u306a\u5c65\u6b74\u3092\u78ba\u8a8d\u3067\u304d\u307e\u3059\u3002<\/p>\n<p><a href=\"https:\/\/www.manageengine.jp\/support\/kb\/EventLog_Analyzer\/wp-content\/uploads\/sites\/6\/mysql7.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large wp-image-5130\" src=\"https:\/\/www.manageengine.jp\/support\/kb\/EventLog_Analyzer\/wp-content\/uploads\/sites\/6\/mysql7-1024x569.png\" alt=\"\" width=\"1024\" height=\"569\" srcset=\"https:\/\/www.manageengine.jp\/support\/kb\/EventLog_Analyzer\/wp-content\/uploads\/sites\/6\/mysql7-1024x569.png 1024w, https:\/\/www.manageengine.jp\/support\/kb\/EventLog_Analyzer\/wp-content\/uploads\/sites\/6\/mysql7-300x167.png 300w, https:\/\/www.manageengine.jp\/support\/kb\/EventLog_Analyzer\/wp-content\/uploads\/sites\/6\/mysql7-768x427.png 768w, https:\/\/www.manageengine.jp\/support\/kb\/EventLog_Analyzer\/wp-content\/uploads\/sites\/6\/mysql7.png 1481w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>\u624b\u9806\u306f\u4ee5\u4e0a\u3067\u3059\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u5bfe\u8c61\u30d3\u30eb\u30c9: 12100\u4ee5\u4e0a MySQL\u30b5\u30fc\u30d0\u30fc\u3092\u767b\u9332\u3059\u308b\u3053\u3068\u3067\u3001MySQL\u306e\u4e00\u822c\u30af\u30a8\u30ea\u30ed\u30b0\u3068\u30a8\u30e9\u30fc\u30ed\u30b0\u3092\u76e3\u8996\u3067\u304d\u307e\u3059\u3002 \u672c\u30ca\u30ec\u30c3\u30b8\u3067\u306f\u3001MySQL\u30b5\u2026 <a href=\"https:\/\/www.manageengine.jp\/support\/kb\/EventLog_Analyzer\/?p=5119\" class=\"more\">\uff3b\u7d9a\u304d\u3092\u8aad\u3080\uff3d<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_lmt_disableupdate":"","_lmt_disable":"","footnotes":""},"categories":[12,13],"tags":[193],"class_list":["post-5119","post","type-post","status-publish","format-standard","hentry","category-design-ela","category-config-ela","tag-mysql"],"modified_by":null,"_links":{"self":[{"href":"https:\/\/www.manageengine.jp\/support\/kb\/EventLog_Analyzer\/index.php?rest_route=\/wp\/v2\/posts\/5119","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.manageengine.jp\/support\/kb\/EventLog_Analyzer\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.manageengine.jp\/support\/kb\/EventLog_Analyzer\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.manageengine.jp\/support\/kb\/EventLog_Analyzer\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.manageengine.jp\/support\/kb\/EventLog_Analyzer\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=5119"}],"version-history":[{"count":16,"href":"https:\/\/www.manageengine.jp\/support\/kb\/EventLog_Analyzer\/index.php?rest_route=\/wp\/v2\/posts\/5119\/revisions"}],"predecessor-version":[{"id":5168,"href":"https:\/\/www.manageengine.jp\/support\/kb\/EventLog_Analyzer\/index.php?rest_route=\/wp\/v2\/posts\/5119\/revisions\/5168"}],"wp:attachment":[{"href":"https:\/\/www.manageengine.jp\/support\/kb\/EventLog_Analyzer\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=5119"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.manageengine.jp\/support\/kb\/EventLog_Analyzer\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=5119"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.manageengine.jp\/support\/kb\/EventLog_Analyzer\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=5119"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}