\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 \ub418\uaca0\uc9c0\ub9cc \ub9d0\uc774\ub2e4.)
\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
\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
\nssh -fNg -L 3306:db_host:3306 userid@proxyhost.com\n<\/pre>\n\n\n\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
-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
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
\uc774\uc5b4\uc11c \ub098\uc624\ub294 userid@proxyhost.com \uc740 \ud130\ub110 \uc5ed\ud560\uc744 \ud558\uac8c \ub420 \ud638\uc2a4\ud2b8 \uc815\ubcf4\uc774\ub2e4.
\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…\u314b\u314b<\/p>\n\n\n\n\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
\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":"
\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 … <\/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":[667,668,669,670,671,672,673,69,666],"_links":{"self":[{"href":"https:\/\/www.itchefblog.com\/index.php?rest_route=\/wp\/v2\/posts\/1910"}],"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}]}}