|
|||||
ÇØ¿Ü È£½ºÆø¸ »ç¿ëÇÏ´Ù°¡, ¾îÁ¦ Vultr ¶ó´Â VPS ¼ºñ½º¸¦ óÀ½ ÀÌ¿ëÇغýÀ´Ï´Ù. »ç¿ëÁßÀÎ ÄÄÇ»ÅÍ ÇÁ·Î±×·¥Áß¿¡, DB Á¢¼ÓÀ» ÇØ¾ß Çϴµ¥, ¸®´ª½º¸¦ ÁÁ¾ÆÇÏÁö ¾Ê´Ùº¸´Ï ¾öû Çì¸Þ°í Àֳ׿ä. ±¸±Û¸µÀ» ÇغÁµµ ¾ÈµÅ¼, Vultr ¿¡ ¹®ÀǸ¦ Çß´õ´Ï, ¾Æ·¡¿Í °°ÀÌ ´äÀåÀÌ ¿Ô½À´Ï´Ù. Is remote access granted? If not, you will need to login locally to your instance, and issue the following to enable MySQL remote access. Before that you will need to obtain your local machine's IPv4. From your local machine, issue: curl -4 icanhazip.com to obtain your local machine's IPv4. (Ŭ¸¯Çغ¸´Ï, Á¦°¡ »ç¿ëÁßÀÎ ÄÄÇ»ÅÍÀÇ ¿ÜºÎ IP ÁÖ¼Ò°¡ ¶ß´õ±º¿ä. ÀÌ°Ç ÀÌÇØÇß½À´Ï´Ù. ) Then access your instance instance via ssh or the provided web console and enable remote access: mysql -u root -p ( ÄַܼΠÁ¢¼ÓÇؼ »ó´Ü ¸í·É¾î·Î ºñ¹ø±îÁö ÀÔ·ÂÇÏ°í Á¢¼ÓµÆ½À´Ï´Ù.) mysql> GRANT ALL ON database.* TO user@’Local_IP_from_curl_outpu À̺κÐÀÌ È¥µ¿µÇ´Â ºÎºÐÀä. grant all on dbÀ̸§. *to dbÀ¯Àú@'À§ÀÇ ¿ÜºÎ IP' identified by 'dbºñ¹Ð¹øÈ£' Áï, grant all on todaysppc. *to todayuser@'123.123.123.123' identified by 'todayspaswo¤¡d' ÀÌ·¸°Ô ÀÔ·ÂÇß´õ´Ï ÄܼÖâÀÇ Ä¿¼°¡, mysql> -> ÀÌ·¸°Ô º¯ÇÏ´õ±º¿ä. Also, please be sure to update your server's iptables to ensure that all TCP connections from port 3306 are accepted. Restart iptables, and then issue the following command from your local machine to access your MySQL server remotely: DB Á¢¼Ó Æ÷Æ®°¡ 3306ÀÎ °ÍÀº 3rd party ÇÁ·Î±×·¥¿¡¼ ÀÚµ¿ ¼¼ÆõǾî ÀÖ¾î¼ Åë°ú. ±×·±µ¥, Restart iptables..ÀÌ°Ç ¹º¸»Àΰ¡¿ä ? VPS ¼¹ö¸¦ restart Ç϶ó´Â °Ç°¡¿ä ? ÀÏ´Ü ÀçºÎÆõµ Çß°í. mysql -u user -p -h 45.76.206.255 database_name À̰͵µ.. mysql -u todayÀ¯Àú -p -h 45.76.206.255 todayDBÀ̸§ ÀÌ·¸°Ô ÀÔ·ÂÇصµ, 3rd party ÇÁ·Î±×·¥¿¡¼´Â Á¢¼ÓÀÌ ¾ÈµÇ´Âµ¥... Á¦°¡ ¹» À߸øÇßÀ»±î¿ä ¤Ì¤Ì |
|
| ||
| ||
| ||
| ||
| ||