{"id":240,"date":"2020-04-10T20:38:27","date_gmt":"2020-04-10T13:38:27","guid":{"rendered":"https:\/\/help.bsru.ac.th\/?p=240"},"modified":"2020-09-02T14:30:25","modified_gmt":"2020-09-02T07:30:25","slug":"open-remote-host-mysql","status":"publish","type":"post","link":"https:\/\/help.bsru.ac.th\/?p=240","title":{"rendered":"Open Remote host MySQL"},"content":{"rendered":"<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-241\" src=\"https:\/\/help.bsru.ac.th\/wp-content\/uploads\/2020\/03\/unnamed-1.jpg\" alt=\"\" width=\"512\" height=\"283\" srcset=\"https:\/\/help.bsru.ac.th\/wp-content\/uploads\/2020\/03\/unnamed-1.jpg 512w, https:\/\/help.bsru.ac.th\/wp-content\/uploads\/2020\/03\/unnamed-1-300x166.jpg 300w\" sizes=\"auto, (max-width: 512px) 100vw, 512px\" \/><\/p>\n<p>1. nano \/etc\/mysql\/mysql.conf.d\/mysqld.cnf<\/p>\n<p>2. \u0e04\u0e49\u0e19\u0e2b\u0e32\u0e04\u0e33\u0e27\u0e48\u0e32 bind-address = 127.0.0.1 &#8230;.. \u0e43\u0e19\u0e01\u0e23\u0e13\u0e35\u0e2b\u0e32\u0e44\u0e21\u0e48\u0e1e\u0e1a\u0e43\u0e2b\u0e49\u0e40\u0e02\u0e49\u0e32 Path \/etc\/mysql \u0e41\u0e25\u0e49\u0e27\u0e43\u0e0a\u0e49\u0e04\u0e33\u0e2a\u0e31\u0e48\u0e07\u00a0 #grep -iR &#8220;bind-address&#8221; .\/* \u0e23\u0e30\u0e1a\u0e1a\u0e08\u0e30\u0e41\u0e2a\u0e14\u0e07 Path\u00a0 \u0e17\u0e35\u0e48\u0e1e\u0e1a\u0e04\u0e33\u0e27\u0e48\u0e32 bind-address \u0e41\u0e25\u0e49\u0e27\u0e40\u0e02\u0e49\u0e32\u0e44\u0e1b\u0e41\u0e01\u0e49\u0e44\u0e02\u0e44\u0e1f\u0e25\u0e4c\u0e19\u0e31\u0e49\u0e19<\/p>\n<blockquote><p>root@freeradius:\/etc\/mysql# grep -iR &#8220;bind-address&#8221; .\/*<br \/>\n.\/mysql.conf.d\/mysqld.cnf:bind-address = 127.0.0.1<\/p><\/blockquote>\n<p>3. \u0e43\u0e2a\u0e48 comment \u0e2b\u0e19\u0e49\u0e32 <span style=\"color: #ff0000\">#<\/span>bind-address = 127.0.0.1<\/p>\n<p>4. Ctrl+o \u0e40\u0e0b\u0e1f , Ctrl+x \u0e2d\u0e2d\u0e01<\/p>\n<p>5. \u0e2a\u0e31\u0e48\u0e07 Restart Service\u00a0\u00a0 \/etc\/init.d\/mysqld restart<\/p>\n","protected":false},"excerpt":{"rendered":"<p>1. nano \/etc\/mysql\/mysql.conf.d\/mysqld.cnf 2. \u0e04\u0e49\u0e19\u0e2b\u0e32\u0e04\u0e33\u0e27\u0e48\u0e32 bind-address = 127.0.0.1 &#8230;.. \u0e43\u0e19\u0e01\u0e23\u0e13\u0e35\u0e2b\u0e32\u0e44\u0e21\u0e48\u0e1e\u0e1a\u0e43\u0e2b\u0e49\u0e40\u0e02\u0e49\u0e32 Path \/etc\/mysql \u0e41\u0e25\u0e49\u0e27\u0e43\u0e0a\u0e49\u0e04\u0e33\u0e2a\u0e31\u0e48\u0e07\u00a0 #grep -iR &#8220;bind-address&#8221; .\/* \u0e23\u0e30\u0e1a\u0e1a\u0e08\u0e30\u0e41\u0e2a\u0e14\u0e07 Path\u00a0 \u0e17\u0e35\u0e48\u0e1e\u0e1a\u0e04\u0e33\u0e27\u0e48\u0e32 bind-address \u0e41\u0e25\u0e49\u0e27\u0e40\u0e02\u0e49\u0e32\u0e44\u0e1b\u0e41\u0e01\u0e49\u0e44\u0e02\u0e44\u0e1f\u0e25\u0e4c\u0e19\u0e31\u0e49\u0e19 root@freeradius:\/etc\/mysql# grep -iR &#8220;bind-address&#8221; .\/* .\/mysql.conf.d\/mysqld.cnf:bind-address = 127.0.0.1 3. \u0e43\u0e2a\u0e48 comment \u0e2b\u0e19\u0e49\u0e32 #bind-address = 127.0.0.1 4. Ctrl+o \u0e40\u0e0b\u0e1f , Ctrl+x \u0e2d\u0e2d\u0e01 5. \u0e2a\u0e31\u0e48\u0e07 Restart Service\u00a0\u00a0 \/etc\/init.d\/mysqld restart<\/p>\n","protected":false},"author":11,"featured_media":241,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7],"tags":[86,83,42,85,75,84],"class_list":["post-240","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-server","tag-coding","tag-database","tag-mysql","tag-phograming","tag-php","tag-remote"],"_links":{"self":[{"href":"https:\/\/help.bsru.ac.th\/index.php?rest_route=\/wp\/v2\/posts\/240","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/help.bsru.ac.th\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/help.bsru.ac.th\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/help.bsru.ac.th\/index.php?rest_route=\/wp\/v2\/users\/11"}],"replies":[{"embeddable":true,"href":"https:\/\/help.bsru.ac.th\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=240"}],"version-history":[{"count":1,"href":"https:\/\/help.bsru.ac.th\/index.php?rest_route=\/wp\/v2\/posts\/240\/revisions"}],"predecessor-version":[{"id":242,"href":"https:\/\/help.bsru.ac.th\/index.php?rest_route=\/wp\/v2\/posts\/240\/revisions\/242"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/help.bsru.ac.th\/index.php?rest_route=\/wp\/v2\/media\/241"}],"wp:attachment":[{"href":"https:\/\/help.bsru.ac.th\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=240"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/help.bsru.ac.th\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=240"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/help.bsru.ac.th\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=240"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}