{"id":172,"date":"2016-04-03T10:43:49","date_gmt":"2016-04-03T02:43:49","guid":{"rendered":"http:\/\/pony.hk\/?p=172"},"modified":"2021-03-12T21:04:16","modified_gmt":"2021-03-12T13:04:16","slug":"%e6%b7%bb%e5%8a%a0iptables%e8%a7%84%e5%88%99%ef%bc%8c%e5%87%80%e5%8c%96mysql%e8%bf%90%e8%a1%8c%e7%8e%af%e5%a2%83-2","status":"publish","type":"post","link":"https:\/\/lnmp.ivan.xin\/?p=172","title":{"rendered":"\u6dfb\u52a0iptables\u89c4\u5219\uff0c\u51c0\u5316mysql\u8fd0\u884c\u73af\u5883"},"content":{"rendered":"<p>\u7531\u4e8e\u9700\u8981\u4e00\u4e9b\u5916\u7f51\u7684\u8fde\u63a5\uff0cmysql\u957f\u671f\u66b4\u9732\u5728\u4e92\u8054\u7f51\u4e0a\uff0c\u5bb9\u6613\u5f15\u8d77\u522b\u4eba\u7684\u653b\u51fb\uff0c\u5f88\u591aIP\u5c1d\u8bd5\u8fde\u63a5\uff0c\u5982\u4e0b\uff1a<\/p>\n<blockquote><p>2016-01-06 09:02:01 32010 [Warning] IP address '42.96.184.105' could not be resolved: Name or service not known<br \/>\n2016-01-06 15:26:48 32010 [Warning] IP address '112.124.108.222' could not be resolved: Name or service not known<br \/>\n2016-01-06 15:47:07 32010 [Warning] IP address '120.25.214.84' could not be resolved: Name or service not known<br \/>\n2016-01-06 15:54:15 32010 [Warning] IP address '120.27.110.101' could not be resolved: Name or service not known<br \/>\n2016-01-06 19:33:33 32010 [Warning] IP address '115.28.145.99' could not be resolved: Name or service not known<\/p><\/blockquote>\n<p>&nbsp;<\/p>\n<p>\u5c3d\u7ba1\u4f7f\u7528\u4e86mysql\u672c\u8eab\u7684IP\u9650\u5236\uff0c\u4f46\u662f\u8fd8\u4e0d\u591f\u5b89\u5168\uff0c\u542f\u7528iptables\uff0c\u9650\u5236\u5176\u4ed6IP\u95ef\u5165\uff0c\u5982\u4e0b\uff1a<\/p>\n<blockquote><p># iptables -L -n<br \/>\n# iptables -F<br \/>\n# iptables -X<br \/>\n# iptables -L -n<br \/>\n# \/etc\/rc.d\/init.d\/iptables save<br \/>\n# service iptables restart<br \/>\n# iptables -A INPUT -m state --state RELATED,ESTABLISHED -j ACCEPT<br \/>\n# iptables -A INPUT -p tcp --dport 22 -j ACCEPT<br \/>\n# iptables -A INPUT -p tcp --dport 80 -j ACCEPT<br \/>\n# iptables -A INPUT -s *******\uff08IP\u5730\u5740\uff09 -p tcp --dport 3306 -j ACCEPT<br \/>\n# iptables -A INPUT -p icmp -j ACCEPT<br \/>\n# iptables -A INPUT -i lo -p all -j ACCEPT<br \/>\n# iptables -P INPUT DROP<br \/>\n# iptables -L -n<br \/>\n# \/etc\/rc.d\/init.d\/iptables save<br \/>\n# service iptables restart<\/p><\/blockquote>\n<p>\u7ec8\u4e8e\uff0c\u6574\u4e2a\u4e16\u754c\u90fd\u6e05\u9759\u4e86~<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u7531\u4e8e\u9700\u8981\u4e00\u4e9b\u5916\u7f51\u7684\u8fde\u63a5\uff0cmysql\u957f\u671f\u66b4\u9732\u5728\u4e92\u8054\u7f51\u4e0a\uff0c\u5bb9\u6613\u5f15\u8d77\u522b\u4eba\u7684\u653b\u51fb\uff0c\u5f88\u591aIP\u5c1d\u8bd5\u8fde\u63a5\uff0c\u5982\u4e0b\uff1a 2016-...<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7],"tags":[],"class_list":["post-172","post","type-post","status-publish","format-standard","hentry","category-linux"],"_links":{"self":[{"href":"https:\/\/lnmp.ivan.xin\/index.php?rest_route=\/wp\/v2\/posts\/172","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/lnmp.ivan.xin\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/lnmp.ivan.xin\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/lnmp.ivan.xin\/index.php?rest_route=\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/lnmp.ivan.xin\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=172"}],"version-history":[{"count":1,"href":"https:\/\/lnmp.ivan.xin\/index.php?rest_route=\/wp\/v2\/posts\/172\/revisions"}],"predecessor-version":[{"id":707,"href":"https:\/\/lnmp.ivan.xin\/index.php?rest_route=\/wp\/v2\/posts\/172\/revisions\/707"}],"wp:attachment":[{"href":"https:\/\/lnmp.ivan.xin\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=172"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/lnmp.ivan.xin\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=172"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/lnmp.ivan.xin\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=172"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}