{"id":741,"date":"2019-03-05T05:28:36","date_gmt":"2019-03-05T05:28:36","guid":{"rendered":"https:\/\/monyog.jp\/?p=741"},"modified":"2019-03-07T02:03:19","modified_gmt":"2019-03-07T02:03:19","slug":"%e8%a8%ad%e5%ae%9a","status":"publish","type":"post","link":"https:\/\/smart-style.main.jp\/monyogjp\/static\/document\/741\/index.html","title":{"rendered":"\u8a2d\u5b9a"},"content":{"rendered":"<p>SQL Diagnostic Manager\u304c\u30b5\u30fc\u30d0\u30fc\u306b\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3055\u308c\u308b\u3068\u3001SQL Diagnostic Manager\u3092\u4f7f\u7528\u3059\u308b\u305f\u3081\u306b\u304a\u4f7f\u3044\u306e\u30a4\u30f3\u30d5\u30e9\u30b9\u30c8\u30e9\u30af\u30c1\u30e3\u306e\u30b7\u30b9\u30c6\u30e0\u3084\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u8a2d\u5b9a\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002SQL Diagnostic Manager\u3092\u30b5\u30fc\u30d0\u30fc\u76e3\u8996\u306b\u4f7f\u7528\u3059\u308b\u305f\u3081\u306b\u306f\u3001MySQL\u306b\u30e6\u30fc\u30b6\u30fc\u30a2\u30af\u30bb\u30b9\u6a29\u9650\u3092\u4e0e\u3048\u3001\u305d\u306e\u5f8c\u3001Web UI\u3092\u4f7f\u7528\u3057\u3066\u30b5\u30fc\u30d0\u30fc\u3092\u767b\u9332\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n<h2>MySQL\u306e\u8a2d\u5b9a<\/h2>\n<p>SQL Diagnostic Manager\u3067\u30b5\u30fc\u30d0\u30fc\u3092\u767b\u9332\u3059\u308b\u3068\u3001MySQL\u306e\u6a19\u6e96\u30af\u30e9\u30a4\u30a2\u30f3\u30c8\u63a5\u7d9a\u3092\u4f7f\u7528\u3057\u3066\u60c5\u5831\u53ce\u96c6\u3084\u30b5\u30fc\u30d0\u30fc\u30d8\u30eb\u30b9\u306e\u76e3\u8996\u3092\u884c\u3044\u307e\u3059\u3002SQL Diagnostic Manager\u304c\u3053\u306e\u30c7\u30fc\u30bf\u306b\u30a2\u30af\u30bb\u30b9\u3059\u308b\u305f\u3081\u306b\u306f\u3001\u30e6\u30fc\u30b6\u30fc\u30a2\u30ab\u30a6\u30f3\u30c8\u306b\u76e3\u8996\u3057\u305f\u3044\u5404MySQL\u30b5\u30fc\u30d0\u30fc\u306e\u9069\u5207\u306a\u6a29\u9650\u3092\u8a2d\u5b9a\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002SQL Diagnostic Manager\u3092\u5b8c\u5168\u306b\u6709\u52b9\u306b\u3059\u308b\u305f\u3081\u306b\u306f\u3001\u3053\u306e\u30e6\u30fc\u30b6\u30fc\u306bSELECT\u3001RELOAD\u3001PROCESS\u3001SUPER\u306e\u6a29\u9650\u3092\u4e0e\u3048\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002SQL Diagnostic Manager\u3092\u30db\u30b9\u30c8\u3057\u3066\u3044\u308b\u30b5\u30fc\u30d0\u30fc\u306b\u8a2d\u5b9a\u3055\u308c\u305f\u30db\u30b9\u30c8\u3068\u308f\u304b\u308a\u3084\u3059\u3044\u30e6\u30fc\u30b6\u30fc\u540d\u3092\u4f7f\u7528\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n<p>\u4f8b\u3048\u3070\u3001SQL Diagnostic Manager\u3092192.168.1.150\u306e\u30b5\u30fc\u30d0\u30fc\u306b\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u3001\u30e6\u30fc\u30b6\u30fc\u540d\u3068\u3057\u3066\u30e6\u30fc\u30b6\u30fcmonyog\u3092\u4f7f\u7528\u3057\u305f\u3044\u3068\u3057\u307e\u3059\u3002\u3053\u306e\u60f3\u5b9a\u3067SQL Diagnostic Manager\u3092\u5b8c\u5168\u306b\u6709\u52b9\u306b\u3059\u308b\u305f\u3081\u306b\u306f\u3001\u4ee5\u4e0b\u306e\u30b3\u30de\u30f3\u30c9\u3092\u767a\u884c\u3057\u307e\u3059:<\/p>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\r\nGRANT SELECT, RELOAD, PROCESS, SUPER ON *.* \r\nTO 'monyog'@'192.168.1.150';\r\n<\/pre>\n<p>\u3053\u308c\u3089\u306e\u6a29\u9650\u3092\u4e0e\u3048\u308b\u3053\u3068\u306b\u3088\u3063\u3066\u3001MySQL\u30b5\u30fc\u30d0\u30fc\u306fSQL Diagnostic Manager\u306b\u5b8c\u5168\u306b\u30a2\u30af\u30bb\u30b9\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002\u5b9f\u969b\u306b\u3053\u306e\u30b5\u30fc\u30d0\u30fc\u306e\u30c7\u30fc\u30bf\u306e\u53ce\u96c6\u3092\u958b\u59cb\u3059\u308b\u305f\u3081\u306b\u306f\u3001\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u3092\u4f7f\u7528\u3057\u3066\u30b5\u30fc\u30d0\u30fc\u3092\u767b\u9332\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002\u30b5\u30fc\u30d0\u30fc\u306e\u767b\u9332\u65b9\u6cd5\u306e\u8a73\u7d30\u306f\u3001\u30b5\u30fc\u30d0\u30fc\u306e\u767b\u9332\u3092\u3054\u89a7\u304f\u3060\u3055\u3044\u3002<\/p>\n<h2>\u6a29\u9650\u306e\u306a\u3044\u30e6\u30fc\u30b6\u30fc\u3068\u3057\u3066SQL Diagnostic Manager\u3092\u8d77\u52d5\u3059\u308b<\/h2>\n<p>\u30c7\u30d5\u30a9\u30eb\u30c8\u3067\u3001SQL Diagnostic Manager\u306fLinux\u306e\u2019root\u2019\u30a2\u30ab\u30a6\u30f3\u30c8\u3067\u52d5\u4f5c\u3057\u307e\u3059\u3002<\/p>\n<p>SQL Diagnostic Manager\u3092\u5b9f\u884c\u3059\u308b\u305f\u3081\u3060\u3051\u306b\u30e6\u30fc\u30b6\u30fc\u30a2\u30ab\u30a6\u30f3\u30c8\u3092\u4f5c\u6210\u3057\u4f7f\u7528\u3059\u308b\u65b9\u6cd5\u306f\u3001\u4ee5\u4e0b\u306e\u3068\u304a\u308a\u3067\u3059:<\/p>\n<ul>\n<li>\u307e\u305a\u3001\u65b0\u3057\u3044\u30e6\u30fc\u30b6\u30fc\u3068\u30b0\u30eb\u30fc\u30d7\u3092\u8ffd\u52a0\u3057\u307e\u3059\u3002&lt;GID&gt;\u3092\u30b0\u30eb\u30fc\u30d7ID\u3067\u7f6e\u304d\u63db\u3048\u3001&lt;PASSWORD&gt;\u3092\u7f6e\u304d\u63db\u3048\u307e\u3059\u3002\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\r\n# groupadd monyog\r\n# useradd -g &lt;GID&gt; -p &lt;passwd&gt; monyog\r\n<\/pre>\n<\/li>\n<li>\u5143\u306e\u30d5\u30a1\u30a4\u30eb\u3092\u65b0\u3057\u3044\u5834\u6240\u306b\u30b3\u30d4\u30fc\u3057\u3001\u30d5\u30a1\u30a4\u30eb\u306e\u6240\u6709\u6a29\u3092\u5909\u66f4\u3057\u307e\u3059\u3002\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\r\n# cp -r \/usr\/local\/MONyog\/. \/home\/monyog\/\r\n# chown -R monyog:monyog \/home\/monyog\r\n<\/pre>\n<\/li>\n<li>\u6b21\u306b\u3001\u521d\u671f\u5316\u30b9\u30af\u30ea\u30d7\u30c8\u3092\u5909\u66f4\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002\u307e\u305a\u3001\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u3092\u5fc5\u305a\u4f5c\u6210\u3057\u3066\u304f\u3060\u3055\u3044\uff01\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\r\n# cp \/etc\/init.d\/MONyogd \/etc\/init.d\/MONyogd.orig\r\n# vi \/etc\/init.d\/MONyogd\r\n<\/pre>\n<\/li>\n<li>\u65b0\u3057\u3044\u30d1\u30b9\u306e\u4ee5\u4e0b\u306e\u884c\u3092\u5909\u66f4\u3057\u307e\u3059\u3002\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\r\nPREFIX=&quot;\/home\/monyog&quot;\r\nMONYOGBIN=&quot;$PREFIX\/bin\/MONyog&quot;\r\n<\/pre>\n<\/li>\n<li>\u540c\u3058\u30d5\u30a1\u30a4\u30eb\u3067\u3001\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u3001\u958b\u59cb\u30b3\u30de\u30f3\u30c9\u3092\u66f4\u65b0\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\r\n# Start MONyog.\r\n...\r\n<\/pre>\n<p>\u307e\u305f\u306f<\/p>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\r\naction &quot;`su - monyog -c \\&quot;$MONYOGBIN -s\\&quot;`&quot; \/bin\/true\r\nfi\r\n<\/pre>\n<\/li>\n<li>\u8a2d\u5b9a\u30d5\u30a1\u30a4\u30eb\u3092\u5909\u66f4\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\"># vi \/home\/monyog\/MONyog.ini<\/pre>\n<\/li>\n<li>\u30c7\u30fc\u30bf\u30d1\u30b9\u3092\u65b0\u3057\u3044\u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u306b\u5909\u66f4\u3057\u307e\u3059\u3002\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">Data_path=\/home\/monyog\/data<\/pre>\n<\/li>\n<li>\u3053\u306e\u5f8c\u3001\u6a29\u9650\u306e\u306a\u3044\u30e6\u30fc\u30b6\u30fc\u3068\u3057\u3066SQL Diagnostic Manager\u3092\u8d77\u52d5\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\"># service MONyog start<\/pre>\n<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>SQL Diagnostic Manager\u304c\u30b5\u30fc\u30d0\u30fc\u306b\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb&#8230; <\/p>\n<div class=\"readmore\"><a href=\"https:\/\/smart-style.main.jp\/monyogjp\/static\/document\/741\/index.html\">Read more<\/a><\/div>\n","protected":false},"author":2,"featured_media":892,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[6,3],"tags":[],"_links":{"self":[{"href":"https:\/\/smart-style.main.jp\/monyogjp\/static\/wp-json\/wp\/v2\/posts\/741"}],"collection":[{"href":"https:\/\/smart-style.main.jp\/monyogjp\/static\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/smart-style.main.jp\/monyogjp\/static\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/smart-style.main.jp\/monyogjp\/static\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/smart-style.main.jp\/monyogjp\/static\/wp-json\/wp\/v2\/comments?post=741"}],"version-history":[{"count":0,"href":"https:\/\/smart-style.main.jp\/monyogjp\/static\/wp-json\/wp\/v2\/posts\/741\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/smart-style.main.jp\/monyogjp\/static\/wp-json\/wp\/v2\/media\/892"}],"wp:attachment":[{"href":"https:\/\/smart-style.main.jp\/monyogjp\/static\/wp-json\/wp\/v2\/media?parent=741"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/smart-style.main.jp\/monyogjp\/static\/wp-json\/wp\/v2\/categories?post=741"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/smart-style.main.jp\/monyogjp\/static\/wp-json\/wp\/v2\/tags?post=741"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}