{"id":1910,"date":"2021-10-28T14:16:32","date_gmt":"2021-10-28T05:16:32","guid":{"rendered":"https:\/\/www.itchefblog.com\/?p=1910"},"modified":"2021-10-28T16:02:24","modified_gmt":"2021-10-28T07:02:24","slug":"ssh-tunneling%ec%9c%bc%eb%a1%9c-local-port%eb%a1%9c-%ec%9b%90%ea%b2%a9-db%ec%97%90-%ec%a0%91%ec%86%8d%ed%95%98%ea%b8%b0","status":"publish","type":"post","link":"https:\/\/www.itchefblog.com\/?p=1910","title":{"rendered":"ssh tunneling\uc744 \uc774\uc6a9\ud574 local port\ub85c \uc6d0\uaca9 DB\uc5d0 \uc811\uc18d\ud558\uae30"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">\uc5ec\ub7ec\uac00\uc9c0 \uc774\uc720\ub85c DB\uc5d0 \ubc14\ub85c \uc811\uc18d\ud558\uc9c0 \ubabb\ud558\uace0 SSH tunneling\uc744 \uc774\uc6a9\ud574\uc57c \ud558\ub294 \uacbd\uc6b0\uac00 \ubc1c\uc0dd\ud558\uac8c \ub418\ub294\ub370, Datagrip\ub4f1\uc758 DB Handling Tool\uc5d0\uc11c\ub294 \uc790\uccb4\uc801\uc73c\ub85c ssh tunneling\uc744 \uc9c0\uc6d0\ud558\uc9c0\ub9cc \ub85c\uceec\uc5d0\uc11c \ud14c\uc2a4\ud2b8\ud560 \ub54c \uc0ac\uc6a9\ud558\ub294 \uac1c\ubc1c \uc5b8\uc5b4\uc5d0\uc11c \uacf5\uc2dd\uc801\uc73c\ub85c \uc9c0\uc6d0\ud558\uc9c0 \uc54a\ub294\ub2e4\uba74 \ubcc4\ub3c4\uc758 \ub77c\uc774\ube0c\ub7ec\ub9ac\ub97c \uc0ac\uc6a9\ud55c\ub2e4\ub358\uac00 \ud558\ub294 \uadc0\ucc2e\uc74c\uc774 \ubc1c\uc0dd\ud55c\ub2e4.<br><br>\ub77c\uc774\ube0c\ub7ec\ub9ac \uc0ac\uc6a9 \uc2dc connection\uc774\ub098 query execution\ub4f1\uc758 \uad6c\ubb38\ub4e4\ub3c4 \ub2e4 \ubc14\uafd4\uc8fc\uc5b4\uc57c\ud558\ub2c8 \uc5ec\uac04 \uadc0\ucc2e\uc740\uac8c \uc544\ub2c8\ub2e4. (\ubb3c\ub860 connection\uacfc execution\ub4f1\uc744 wrapping \ud574\ub450\uc5c8\ub2e4\uba74 \ud55c\ub450\uad70\ub370\ub9cc \uc218\uc815\ud558\uba74 \ub418\uaca0\uc9c0\ub9cc \ub9d0\uc774\ub2e4.)<br><br>\uc774\ub7f0 \uadc0\ucc28\ub2c8\uc998\uc744 \uac04\ud3b8\ud558\uac8c \ud574\uacb0\ud560 \uc218 \uc788\ub294 \ubc29\ubc95\uc744 \uc54c\uac8c \ub418\uc5b4\uc11c \ub0a8\uaca8\ubcf8\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uc77c\ub2e8 Linux\ub098 OSX\uae30\ubc18\uc758 \ud130\ubbf8\ub110\uc774 \uc788\ub294 OS\ub97c \ub300\uc0c1\uc73c\ub85c \ud558\ub294 \ubc29\ubc95\uc774\uae30\uc5d0 Windows\ub294 \ubaa8\ub974\uaca0\ub2e4.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nssh -fNg -L 3306:db_host:3306 <span \n                data-original-string='X3IQ8xJnYQT5s4k6Tqf8lw==fd9mwSuhga+CGxj6nNXqakmQyRqvK9GMd4e7pcnMtxXaPY='\n                class='apbct-email-encoder'\n                title='This contact has been encoded by Anti-Spam by CleanTalk. Click to decode. To finish the decoding make sure that JavaScript is enabled in your browser.'>us<span class=\"apbct-blur\">****<\/span>@<span class=\"apbct-blur\">*******<\/span>st.com<\/span>\n<\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\">\uc704\uc758 proxyhost.com\uc744 \ubcf8\uc778\uc774 \ud130\ub110\ub9c1\uc5d0 \uc0ac\uc6a9\ud560 \ud638\uc2a4\ud2b8\ub85c \ubcc0\uacbd\ud558\uba74 \ub418\uaca0\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">-L \ubc14\ub85c \ub2e4\uc74c\uc5d0 \ub098\uc624\ub294 \ud3ec\ud2b8\ub294 \ub85c\uceec\uba38\uc2e0\uc758 \ud3ec\ud2b8\uc774\uace0 \ub4a4\uc758 \ud3ec\ud2b8\ub294 \ucd5c\uc885 \uc811\uc18d\ud558\uac8c\ub418\ub294 DB\uc758 \ud3ec\ud2b8\uc774\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">ssh \uc635\uc158 \uc911 f\ub294 \ubc31\uadf8\ub77c\uc6b4\ub4dc\ub85c \uc2e4\ud589,  N\uc740 remote command\ub97c \uc2e4\ud589\ud558\uc9c0 \uc54a\uc74c, g\ub294 remote host\uc5d0\uc11c local\ub85c \ud3ec\uc6cc\ub4dc\ub41c port\uc5d0 \uc811\uadfc\uc744 \ud5c8\uc6a9\ud55c\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uc774\uc5b4\uc11c \ub098\uc624\ub294 <span \n                data-original-string='08kAhyTMvqDiFar2ROS1SQ==fd9gbWmLWA42vFnw6dMj9lx4UpPVF8f1\/zn2HvBKLM57NQ='\n                class='apbct-email-encoder'\n                title='This contact has been encoded by Anti-Spam by CleanTalk. Click to decode. To finish the decoding make sure that JavaScript is enabled in your browser.'>us<span class=\"apbct-blur\">****<\/span>@<span class=\"apbct-blur\">*******<\/span>st.com<\/span> \uc740 \ud130\ub110 \uc5ed\ud560\uc744 \ud558\uac8c \ub420 \ud638\uc2a4\ud2b8 \uc815\ubcf4\uc774\ub2e4.<br>\uc704\uc758 \uba85\ub839\uc5b4\ub97c \uc2e4\ud589\ud558\uba74 proxyhost.com \uc758 \ube44\ubc88\uc744 \uc785\ub825\ud558\ub77c\ub294 \ud504\ub86c\ud504\ud2b8\uac00 \uc2e4\ud589\ub418\ub294\ub370, \ube44\ubc88\uc744 \uc785\ub825\ud558\uc5ec \uc815\uc0c1\uc801\uc73c\ub85c \uc778\uc99d\uc774 \ub418\uba74 \uc544\ubb34\uac83\ub3c4 \ub728\uc9c0 \uc54a\ub294\ub2e4&#8230;\u314b\u314b<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uc774\uc81c localhost:3306 or 127.0.0.1:3306\uc73c\ub85c \uc811\uc18d\uc744 \ud574\ubcf4\uba74 \uc815\uc0c1\uc801\uc73c\ub85c \uc811\uc18d\uc774 \ub420\uac83\uc774\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uc774 \ud3ec\uc2a4\ud305\uc740 MySQL\uc758 \ud3ec\ud2b8\ub97c \uae30\uc900\uc73c\ub85c \uc791\uc131\ub418\uae34 \ud588\uc73c\ub098 \ud3ec\ud2b8\ub9cc \ubcc0\uacbd\ud574\uc8fc\uba74 \uc5b4\ub5a4 \uc11c\ube44\uc2a4\ub77c\ub3c4 \ud3ec\uc6cc\ub529\uc774 \uac00\ub2a5\ud558\ub2e4.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\uc5ec\ub7ec\uac00\uc9c0 \uc774\uc720\ub85c DB\uc5d0 \ubc14\ub85c \uc811\uc18d\ud558\uc9c0 \ubabb\ud558\uace0 SSH tunneling\uc744 \uc774\uc6a9\ud574\uc57c \ud558\ub294 \uacbd\uc6b0\uac00 \ubc1c\uc0dd\ud558\uac8c \ub418\ub294\ub370, Datagrip\ub4f1\uc758 DB Handling Tool\uc5d0\uc11c\ub294 \uc790\uccb4\uc801\uc73c\ub85c ssh tunneling\uc744 \uc9c0\uc6d0\ud558\uc9c0\ub9cc \ub85c\uceec\uc5d0\uc11c \ud14c\uc2a4\ud2b8\ud560 \ub54c \uc0ac\uc6a9\ud558\ub294 \uac1c\ubc1c \uc5b8\uc5b4\uc5d0\uc11c \uacf5\uc2dd\uc801\uc73c\ub85c \uc9c0\uc6d0\ud558\uc9c0 \uc54a\ub294\ub2e4\uba74 \ubcc4\ub3c4\uc758 \ub77c\uc774\ube0c\ub7ec\ub9ac\ub97c \uc0ac\uc6a9\ud55c\ub2e4\ub358\uac00 \ud558\ub294 \uadc0\ucc2e\uc74c\uc774 \ubc1c\uc0dd\ud55c\ub2e4. \ub77c\uc774\ube0c\ub7ec\ub9ac \uc0ac\uc6a9 \uc2dc connection\uc774\ub098 query execution\ub4f1\uc758 \uad6c\ubb38\ub4e4\ub3c4 \ub2e4 \ubc14\uafd4\uc8fc\uc5b4\uc57c\ud558\ub2c8 \uc5ec\uac04 \uadc0\ucc2e\uc740\uac8c \uc544\ub2c8\ub2e4. (\ubb3c\ub860 connection\uacfc execution\ub4f1\uc744 wrapping \ud574\ub450\uc5c8\ub2e4\uba74 \ud55c\ub450\uad70\ub370\ub9cc \uc218\uc815\ud558\uba74 &hellip; <\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[16,17],"tags":[69,666,667,668,669,670,671,672,673],"class_list":["post-1910","post","type-post","status-publish","format-standard","hentry","category-linux","category-osx","tag-db","tag-666","tag-port","tag-forwarding","tag-port-forwarding","tag-ssh-tunneling","tag-671","tag-local-port-forwarding","tag-local-port-ssh-tinneling"],"_links":{"self":[{"href":"https:\/\/www.itchefblog.com\/index.php?rest_route=\/wp\/v2\/posts\/1910","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.itchefblog.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.itchefblog.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.itchefblog.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.itchefblog.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1910"}],"version-history":[{"count":2,"href":"https:\/\/www.itchefblog.com\/index.php?rest_route=\/wp\/v2\/posts\/1910\/revisions"}],"predecessor-version":[{"id":1912,"href":"https:\/\/www.itchefblog.com\/index.php?rest_route=\/wp\/v2\/posts\/1910\/revisions\/1912"}],"wp:attachment":[{"href":"https:\/\/www.itchefblog.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1910"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.itchefblog.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1910"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.itchefblog.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1910"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}