{"id":209,"date":"2008-08-25T16:40:58","date_gmt":"2008-08-25T08:40:58","guid":{"rendered":"http:\/\/learn-house.idv.tw\/?p=209"},"modified":"2017-10-27T18:20:38","modified_gmt":"2017-10-27T10:20:38","slug":"%e9%96%8b%e6%94%bemysql%e5%b0%8d%e5%a4%96%e9%80%a3%e7%b7%9a","status":"publish","type":"post","link":"https:\/\/learn-house.idv.tw\/?p=209","title":{"rendered":"\u958b\u653emysql\u5c0d\u5916\u9023\u7dda"},"content":{"rendered":"<p>\u96d6\u7136\u8aaa\u9019\u6a23\u662f\u4e00\u4ef6\u883b\u5371\u96aa\u7684\u4e8b\uff0c\u4f46\u6709\u6642\u5019\u903c\u4e0d\u5f97\u5b9c\u53c8\u8981\u958b\u653e\u7d66\u5916\u9762\u7684IP\u4f86\u9023\u7dda<\/p>\n<p>\u6240\u4ee5\u9019\u6642\u8981\u6ce8\u610f\u7684\u5c31\u662f\u65e2\u7136\u6703\u60f3\u8981\u9023mysql\uff0c\u539f\u5247\u4e0a\u61c9\u8a72\u90fd\u662fServer<\/p>\n<p>\u65e2\u7136\u662fServer\uff0c\u539f\u5247\u4e0a\u61c9\u8a72\u90fd\u662f\u56fa\u5b9aIP<\/p>\n<p>\u56e0\u6b64\u53ea\u8981\u5728\u9632\u706b\u7246\u52a0\u4e0a\u4e00\u689d\u898f\u5247\u8aaa\u5141\u8a31\u67d0\u500bIP\u9023\u9032\u4f86\u5c31\u53ef\u4ee5\u4e86<\/p>\n<p>\u4f60\u53ef\u4ee5\u4f7f\u7528iptables\u52a0\u4e0a\u4e00\u689d\u898f\u5247\uff0c\u53ef\u80fd\u5982\u4e0b(\u6211\u9084\u6c92\u6e2c\u904e)\uff1a<\/p>\n<p>iptables -A INPUT -i eth0 -s 140.127.X.X\/24 -j ACCEPT<\/p>\n<p>\u9019\u9ebc\u4e00\u4f86\u5c31\u53ef\u4ee5\u5141\u8a31\u5916\u90e8\u67d0\u4e00\u500bIP\u9032\u884c\u9023\u7dda<\/p>\n<p>\u518d\u4f86\u5c31\u662f\u672c\u6587\u4e86\uff0c\u600e\u6a23\u624d\u80fd\u958b\u555fmysql\u7d66\u5916\u9762\u9023\u5462?<\/p>\n<p>\u7576\u4f60\u767c\u73fe\u51fa\u73fe\u9019\u500b\u8a0a\u606f\u6642<\/p>\n<p>Unable to connect to any of the specified MySQL hosts<\/p>\n<p>1. \u9996\u5148\u7b2c\u4e00\u500b\u5c31\u662f\u5148\u770b\u770b\u662f\u4e0d\u662f\u9632\u706b\u5f37\u6a94\u4e0b\u4f86\u4e86\uff0c\u9632\u706b\u7246\u8981\u958b\u555f TCP 3306 (\u9810\u8a2d MySQL Port)<\/p>\n<p>2. \u5728phpMyAdmin\u65b0\u589e\u4e00\u500b User\uff0c\u4e3b\u6a5f(Host) \u70ba\u5141\u8a31\u9023\u7dda\u7684\u7db2\u57df\u6216 IP\uff0c\u5982\u679c\u4e0d\u9650\u5236\u53ef\u4ee5\u7528\u300c%\u300d\u8868\u4efb\u4f55\u4e3b\u6a5f<\/p>\n<p>3. \u6aa2\u67e5 mysql \u8a2d\u5b9a\u6a94 (my.ini \u6216 my.cnf)\uff0c\u8a3b\u89e3\u4e0b\u9762\u6587\u5b57<\/p>\n<p>skip-networking<br \/>\nbind-address=127.0.0.1<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u96d6\u7136\u8aaa\u9019\u6a23\u662f\u4e00\u4ef6\u883b\u5371\u96aa\u7684\u4e8b\uff0c\u4f46\u6709\u6642\u5019\u903c\u4e0d\u5f97\u5b9c\u53c8\u8981\u958b\u653e\u7d66\u5916\u9762\u7684IP\u4f86\u9023\u7dda \u6240\u4ee5\u9019\u6642\u8981\u6ce8\u610f\u7684\u5c31\u662f\u65e2\u7136\u6703\u60f3\u8981\u9023mys<span class=\"post-excerpt-end\">&hellip;<\/span><\/p>\n<p class=\"more-link\"><a href=\"https:\/\/learn-house.idv.tw\/?p=209\" class=\"themebutton\">Read More<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7],"tags":[],"class_list":["post-209","post","type-post","status-publish","format-standard","hentry","category-linux"],"_links":{"self":[{"href":"https:\/\/learn-house.idv.tw\/index.php?rest_route=\/wp\/v2\/posts\/209","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/learn-house.idv.tw\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/learn-house.idv.tw\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/learn-house.idv.tw\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/learn-house.idv.tw\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=209"}],"version-history":[{"count":0,"href":"https:\/\/learn-house.idv.tw\/index.php?rest_route=\/wp\/v2\/posts\/209\/revisions"}],"wp:attachment":[{"href":"https:\/\/learn-house.idv.tw\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=209"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/learn-house.idv.tw\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=209"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/learn-house.idv.tw\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=209"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}