{"id":60,"date":"2024-01-29T09:36:06","date_gmt":"2024-01-29T00:36:06","guid":{"rendered":"https:\/\/1000.co.kr\/the10\/?p=60"},"modified":"2024-01-29T09:36:07","modified_gmt":"2024-01-29T00:36:07","slug":"mysql-%ec%97%90%ec%84%9c-%ec%99%b8%eb%b6%80ip-%ec%a0%91%ea%b7%bc-%ed%97%88%ec%9a%a9%eb%b0%a9%eb%b2%95","status":"publish","type":"post","link":"https:\/\/1000.co.kr\/the10\/?p=60","title":{"rendered":"mysql \uc5d0\uc11c \uc678\ubd80IP \uc811\uadfc \ud5c8\uc6a9\ubc29\ubc95"},"content":{"rendered":"\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"1024\" src=\"https:\/\/1000.co.kr\/the10\/wp-content\/uploads\/2024\/01\/DALL\u00b7E-2024-01-29-09.31.43-A-high-tech-futuristic-data-center-filled-with-server-racks-and-glowing-blue-lights.-In-the-foreground-a-large-screen-displays-a-complex-database-ma.jpg\" alt=\"\" class=\"wp-image-61\" srcset=\"https:\/\/1000.co.kr\/the10\/wp-content\/uploads\/2024\/01\/DALL\u00b7E-2024-01-29-09.31.43-A-high-tech-futuristic-data-center-filled-with-server-racks-and-glowing-blue-lights.-In-the-foreground-a-large-screen-displays-a-complex-database-ma.jpg 1024w, https:\/\/1000.co.kr\/the10\/wp-content\/uploads\/2024\/01\/DALL\u00b7E-2024-01-29-09.31.43-A-high-tech-futuristic-data-center-filled-with-server-racks-and-glowing-blue-lights.-In-the-foreground-a-large-screen-displays-a-complex-database-ma-300x300.jpg 300w, https:\/\/1000.co.kr\/the10\/wp-content\/uploads\/2024\/01\/DALL\u00b7E-2024-01-29-09.31.43-A-high-tech-futuristic-data-center-filled-with-server-racks-and-glowing-blue-lights.-In-the-foreground-a-large-screen-displays-a-complex-database-ma-150x150.jpg 150w, https:\/\/1000.co.kr\/the10\/wp-content\/uploads\/2024\/01\/DALL\u00b7E-2024-01-29-09.31.43-A-high-tech-futuristic-data-center-filled-with-server-racks-and-glowing-blue-lights.-In-the-foreground-a-large-screen-displays-a-complex-database-ma-768x768.jpg 768w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>MySQL\uc5d0 \uc678\ubd80 IP \uc811\uadfc\uc744 \ud5c8\uc6a9\ud558\ub294 \ubc29\ubc95\uc740 \ub2e4\uc74c\uacfc \uac19\uc740 \ub2e8\uacc4\ub97c \ud3ec\ud568\ud569\ub2c8\ub2e4. \uae30\ubcf8\uc801\uc73c\ub85c MySQL\uc740 \ub85c\uceec \ud638\uc2a4\ud2b8\uc5d0\uc11c\ub9cc \uc811\uadfc\uc744 \ud5c8\uc6a9\ud558\ub3c4\ub85d \uc124\uc815\ub418\uc5b4 \uc788\uc2b5\ub2c8\ub2e4. \uc678\ubd80\uc5d0\uc11c \uc811\uadfc\uc744 \ud5c8\uc6a9\ud558\ub824\uba74 \uba87 \uac00\uc9c0 \uc124\uc815\uc744 \ubcc0\uacbd\ud574\uc57c \ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>MySQL \uad6c\uc131 \ud30c\uc77c \uc218\uc815<br>mysqld.cnf \ud30c\uc77c \uc5f4\uae30:<br>MySQL \uc11c\ubc84\uc758 \uad6c\uc131 \ud30c\uc77c\uc744 \ud3b8\uc9d1\uae30\ub85c \uc5fd\ub2c8\ub2e4. mysqld.cnf \ud30c\uc77c\uc740 \ubcf4\ud1b5 \/etc\/mysql\/mysql.conf.d\/mysqld.cnf\uc5d0 \uc704\uce58\ud569\ub2c8\ub2e4.<\/li>\n<\/ol>\n\n\n\n<p>sudo nano \/etc\/mysql\/mysql.conf.d\/mysqld.cnf<br>\ubc14\uc778\ub4dc \uc8fc\uc18c \ubcc0\uacbd:<br>\ud30c\uc77c\uc5d0\uc11c bind-address \uc18d\uc131\uc744 \ucc3e\uc2b5\ub2c8\ub2e4. \uae30\ubcf8\uac12\uc740 127.0.0.1\ub85c \uc124\uc815\ub418\uc5b4 \uc788\uc5b4 \ub85c\uceec \ud638\uc2a4\ud2b8\uc5d0\uc11c\ub9cc \uc811\uadfc\uc744 \ud5c8\uc6a9\ud569\ub2c8\ub2e4. \uc774\ub97c \ubcc0\uacbd\ud558\uc5ec \uc678\ubd80 \uc811\uadfc\uc744 \ud5c8\uc6a9\ud558\ub824\uba74 0.0.0.0\uc73c\ub85c \uc124\uc815\ud569\ub2c8\ub2e4. \uc774\ub807\uac8c \ud558\uba74 \ubaa8\ub4e0 IP \uc8fc\uc18c\uc5d0\uc11c\uc758 \uc811\uadfc\uc744 \ud5c8\uc6a9\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<p>bind-address = 0.0.0.0<br>\ud30c\uc77c \uc800\uc7a5 \ubc0f \uc885\ub8cc:<br>\ubcc0\uacbd\uc0ac\ud56d\uc744 \uc800\uc7a5\ud55c \ud6c4 \ud30c\uc77c\uc744 \ub2eb\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<ol class=\"wp-block-list\" start=\"2\">\n<li>MySQL \uc0ac\uc6a9\uc790 \uad8c\ud55c \uc124\uc815<br>MySQL\uc5d0\uc11c \uc678\ubd80 \uc811\uadfc\uc744 \ud5c8\uc6a9\ud558\ub824\uba74 \ud574\ub2f9 \uc0ac\uc6a9\uc790\uc5d0\uac8c \uc678\ubd80 IP \uc8fc\uc18c \ub610\ub294 %\ub97c \uc0ac\uc6a9\ud558\uc5ec \ubaa8\ub4e0 IP\uc5d0\uc11c\uc758 \uc811\uadfc\uc744 \ud5c8\uc6a9\ud574\uc57c \ud569\ub2c8\ub2e4.<\/li>\n<\/ol>\n\n\n\n<p>MySQL\uc5d0 \ub85c\uadf8\uc778:<\/p>\n\n\n\n<p>mysql -u root -p<br>\uc678\ubd80 \uc811\uadfc \ud5c8\uc6a9\uc744 \uc704\ud55c \uc0ac\uc6a9\uc790 \uad8c\ud55c \ubd80\uc5ec:<br>\uc544\ub798 \uba85\ub839\uc5b4\ub97c \uc0ac\uc6a9\ud558\uc5ec \ud2b9\uc815 \uc0ac\uc6a9\uc790\uc5d0\uac8c \ubaa8\ub4e0 IP \uc8fc\uc18c\uc5d0\uc11c \uc811\uadfc\ud560 \uc218 \uc788\ub294 \uad8c\ud55c\uc744 \ubd80\uc5ec\ud569\ub2c8\ub2e4. &#8216;username&#8217;@&#8217;%&#8217;\uc5d0\uc11c username\uc744 \uc2e4\uc81c \uc0ac\uc6a9\uc790 \uc774\ub984\uc73c\ub85c, your_password\ub97c \uc0ac\uc6a9\uc790\uc758 \ube44\ubc00\ubc88\ud638\ub85c \uad50\uccb4\ud558\uc138\uc694.<\/p>\n\n\n\n<p>GRANT ALL PRIVILEGES ON <em>.<\/em> TO &#8216;username&#8217;@&#8217;%&#8217; IDENTIFIED BY &#8216;your_password&#8217; WITH GRANT OPTION;<br>FLUSH PRIVILEGES;<br>MySQL \uc885\ub8cc:<\/p>\n\n\n\n<p>EXIT;<\/p>\n\n\n\n<ol class=\"wp-block-list\" start=\"3\">\n<li>\ubc29\ud654\ubcbd \uc124\uc815 (\ud544\uc694\ud55c \uacbd\uc6b0)<br>\uc678\ubd80 \uc811\uadfc\uc744 \ud5c8\uc6a9\ud558\ub824\uba74 \uc6b0\ubd84\ud22c \ubc29\ud654\ubcbd(UFW)\uc5d0\uc11c\ub3c4 MySQL \ud3ec\ud2b8(\uae30\ubcf8\uac12\uc740 3306)\ub97c \uc5f4\uc5b4\uc57c \ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/li>\n<\/ol>\n\n\n\n<p>sudo ufw allow 3306<br>sudo ufw reload<\/p>\n\n\n\n<ol class=\"wp-block-list\" start=\"4\">\n<li>MySQL \uc11c\ube44\uc2a4 \uc7ac\uc2dc\uc791<br>\uad6c\uc131 \ubcc0\uacbd\uc0ac\ud56d\uc744 \uc801\uc6a9\ud558\uae30 \uc704\ud574 MySQL \uc11c\ube44\uc2a4\ub97c \uc7ac\uc2dc\uc791\ud569\ub2c8\ub2e4.<\/li>\n<\/ol>\n\n\n\n<p>sudo systemctl restart mysql<br>\uc774\uc81c \uc124\uc815\ud55c \uc678\ubd80 IP \ub610\ub294 \ubaa8\ub4e0 IP\uc5d0\uc11c MySQL \uc11c\ubc84\uc5d0 \uc811\uadfc\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ubcf4\uc548\uc744 \uc704\ud574 \uac00\ub2a5\ud55c \ud55c \ud2b9\uc815 IP \uc8fc\uc18c\uc5d0 \ub300\ud574\uc11c\ub9cc \uc811\uadfc\uc744 \ud5c8\uc6a9\ud558\uace0, \uc0ac\uc6a9\ud558\uc9c0 \uc54a\ub294 \uacbd\uc6b0\uc5d0\ub294 \ubc29\ud654\ubcbd \uaddc\uce59\uc744 \ub2e4\uc2dc \uc124\uc815\ud558\uc5ec \ud3ec\ud2b8\ub97c \ub2eb\ub294 \uac83\uc774 \uc88b\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-style-rounded\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"1024\" src=\"https:\/\/1000.co.kr\/the10\/wp-content\/uploads\/2024\/01\/DALL\u00b7E-2024-01-29-09.33.53-An-expansive-view-of-an-Internet-Data-Center-IDC-filled-with-rows-upon-rows-of-high-capacity-server-racks.-The-racks-are-densely-packed-with-various.jpg\" alt=\"\" class=\"wp-image-62\" srcset=\"https:\/\/1000.co.kr\/the10\/wp-content\/uploads\/2024\/01\/DALL\u00b7E-2024-01-29-09.33.53-An-expansive-view-of-an-Internet-Data-Center-IDC-filled-with-rows-upon-rows-of-high-capacity-server-racks.-The-racks-are-densely-packed-with-various.jpg 1024w, https:\/\/1000.co.kr\/the10\/wp-content\/uploads\/2024\/01\/DALL\u00b7E-2024-01-29-09.33.53-An-expansive-view-of-an-Internet-Data-Center-IDC-filled-with-rows-upon-rows-of-high-capacity-server-racks.-The-racks-are-densely-packed-with-various-300x300.jpg 300w, https:\/\/1000.co.kr\/the10\/wp-content\/uploads\/2024\/01\/DALL\u00b7E-2024-01-29-09.33.53-An-expansive-view-of-an-Internet-Data-Center-IDC-filled-with-rows-upon-rows-of-high-capacity-server-racks.-The-racks-are-densely-packed-with-various-150x150.jpg 150w, https:\/\/1000.co.kr\/the10\/wp-content\/uploads\/2024\/01\/DALL\u00b7E-2024-01-29-09.33.53-An-expansive-view-of-an-Internet-Data-Center-IDC-filled-with-rows-upon-rows-of-high-capacity-server-racks.-The-racks-are-densely-packed-with-various-768x768.jpg 768w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>MySQL\uc5d0 \uc678\ubd80 IP \uc811\uadfc\uc744 \ud5c8\uc6a9\ud558\ub294 \ubc29\ubc95\uc740 \ub2e4\uc74c\uacfc \uac19\uc740 \ub2e8\uacc4\ub97c \ud3ec\ud568\ud569\ub2c8\ub2e4. \uae30\ubcf8\uc801\uc73c\ub85c MySQL\uc740 \ub85c\uceec \ud638\uc2a4\ud2b8\uc5d0\uc11c\ub9cc \uc811\uadfc\uc744 \ud5c8\uc6a9\ud558\ub3c4\ub85d \uc124\uc815\ub418\uc5b4 \uc788\uc2b5\ub2c8\ub2e4. \uc678\ubd80\uc5d0\uc11c \uc811\uadfc\uc744 \ud5c8\uc6a9\ud558\ub824\uba74 \uba87 \uac00\uc9c0 \uc124\uc815\uc744 \ubcc0\uacbd\ud574\uc57c \ud569\ub2c8\ub2e4. sudo nano \/etc\/mysql\/mysql.conf.d\/mysqld.cnf\ubc14\uc778\ub4dc \uc8fc\uc18c \ubcc0\uacbd:\ud30c\uc77c\uc5d0\uc11c bind-address \uc18d\uc131\uc744 \ucc3e\uc2b5\ub2c8\ub2e4. \uae30\ubcf8\uac12\uc740 127.0.0.1\ub85c \uc124\uc815\ub418\uc5b4 \uc788\uc5b4 \ub85c\uceec \ud638\uc2a4\ud2b8\uc5d0\uc11c\ub9cc \uc811\uadfc\uc744 \ud5c8\uc6a9\ud569\ub2c8\ub2e4. \uc774\ub97c \ubcc0\uacbd\ud558\uc5ec \uc678\ubd80 \uc811\uadfc\uc744 \ud5c8\uc6a9\ud558\ub824\uba74 0.0.0.0\uc73c\ub85c \uc124\uc815\ud569\ub2c8\ub2e4. \uc774\ub807\uac8c \ud558\uba74 \ubaa8\ub4e0 IP \uc8fc\uc18c\uc5d0\uc11c\uc758 \uc811\uadfc\uc744&#8230;<\/p>\n<p class=\"more-link-wrap\"><a href=\"https:\/\/1000.co.kr\/the10\/?p=60\" class=\"more-link\">Read More<span class=\"screen-reader-text\"> &ldquo;mysql \uc5d0\uc11c \uc678\ubd80IP \uc811\uadfc \ud5c8\uc6a9\ubc29\ubc95&rdquo;<\/span> &raquo;<\/a><\/p>\n","protected":false},"author":1,"featured_media":62,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-60","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-1"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.9.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>mysql \uc5d0\uc11c \uc678\ubd80IP \uc811\uadfc \ud5c8\uc6a9\ubc29\ubc95 - bongbong-w<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/1000.co.kr\/the10\/?p=60\" \/>\n<meta property=\"og:locale\" content=\"ko_KR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"mysql \uc5d0\uc11c \uc678\ubd80IP \uc811\uadfc \ud5c8\uc6a9\ubc29\ubc95 - bongbong-w\" \/>\n<meta property=\"og:description\" content=\"MySQL\uc5d0 \uc678\ubd80 IP \uc811\uadfc\uc744 \ud5c8\uc6a9\ud558\ub294 \ubc29\ubc95\uc740 \ub2e4\uc74c\uacfc \uac19\uc740 \ub2e8\uacc4\ub97c \ud3ec\ud568\ud569\ub2c8\ub2e4. \uae30\ubcf8\uc801\uc73c\ub85c MySQL\uc740 \ub85c\uceec \ud638\uc2a4\ud2b8\uc5d0\uc11c\ub9cc \uc811\uadfc\uc744 \ud5c8\uc6a9\ud558\ub3c4\ub85d \uc124\uc815\ub418\uc5b4 \uc788\uc2b5\ub2c8\ub2e4. \uc678\ubd80\uc5d0\uc11c \uc811\uadfc\uc744 \ud5c8\uc6a9\ud558\ub824\uba74 \uba87 \uac00\uc9c0 \uc124\uc815\uc744 \ubcc0\uacbd\ud574\uc57c \ud569\ub2c8\ub2e4. sudo nano \/etc\/mysql\/mysql.conf.d\/mysqld.cnf\ubc14\uc778\ub4dc \uc8fc\uc18c \ubcc0\uacbd:\ud30c\uc77c\uc5d0\uc11c bind-address \uc18d\uc131\uc744 \ucc3e\uc2b5\ub2c8\ub2e4. \uae30\ubcf8\uac12\uc740 127.0.0.1\ub85c \uc124\uc815\ub418\uc5b4 \uc788\uc5b4 \ub85c\uceec \ud638\uc2a4\ud2b8\uc5d0\uc11c\ub9cc \uc811\uadfc\uc744 \ud5c8\uc6a9\ud569\ub2c8\ub2e4. \uc774\ub97c \ubcc0\uacbd\ud558\uc5ec \uc678\ubd80 \uc811\uadfc\uc744 \ud5c8\uc6a9\ud558\ub824\uba74 0.0.0.0\uc73c\ub85c \uc124\uc815\ud569\ub2c8\ub2e4. \uc774\ub807\uac8c \ud558\uba74 \ubaa8\ub4e0 IP \uc8fc\uc18c\uc5d0\uc11c\uc758 \uc811\uadfc\uc744...Read More &ldquo;mysql \uc5d0\uc11c \uc678\ubd80IP \uc811\uadfc \ud5c8\uc6a9\ubc29\ubc95&rdquo; &raquo;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/1000.co.kr\/the10\/?p=60\" \/>\n<meta property=\"og:site_name\" content=\"bongbong-w\" \/>\n<meta property=\"article:published_time\" content=\"2024-01-29T00:36:06+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-01-29T00:36:07+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/1000.co.kr\/the10\/wp-content\/uploads\/2024\/01\/DALL\u00b7E-2024-01-29-09.33.53-An-expansive-view-of-an-Internet-Data-Center-IDC-filled-with-rows-upon-rows-of-high-capacity-server-racks.-The-racks-are-densely-packed-with-various.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1024\" \/>\n\t<meta property=\"og:image:height\" content=\"1024\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"the10\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"the10\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2\ubd84\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/1000.co.kr\/the10\/?p=60\",\"url\":\"https:\/\/1000.co.kr\/the10\/?p=60\",\"name\":\"mysql \uc5d0\uc11c \uc678\ubd80IP \uc811\uadfc \ud5c8\uc6a9\ubc29\ubc95 - bongbong-w\",\"isPartOf\":{\"@id\":\"https:\/\/1000.co.kr\/the10\/#website\"},\"datePublished\":\"2024-01-29T00:36:06+00:00\",\"dateModified\":\"2024-01-29T00:36:07+00:00\",\"author\":{\"@id\":\"https:\/\/1000.co.kr\/the10\/#\/schema\/person\/8b034e2e401fb3e503688a18ea86b475\"},\"breadcrumb\":{\"@id\":\"https:\/\/1000.co.kr\/the10\/?p=60#breadcrumb\"},\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/1000.co.kr\/the10\/?p=60\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/1000.co.kr\/the10\/?p=60#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/1000.co.kr\/the10\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"mysql \uc5d0\uc11c \uc678\ubd80IP \uc811\uadfc \ud5c8\uc6a9\ubc29\ubc95\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/1000.co.kr\/the10\/#website\",\"url\":\"https:\/\/1000.co.kr\/the10\/\",\"name\":\"bongbong-w\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/1000.co.kr\/the10\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"ko-KR\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/1000.co.kr\/the10\/#\/schema\/person\/8b034e2e401fb3e503688a18ea86b475\",\"name\":\"the10\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\/\/1000.co.kr\/the10\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/75f120a19fdf1795e68d13e89d5f111c576a24aa7e95823ff4908818518e6258?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/75f120a19fdf1795e68d13e89d5f111c576a24aa7e95823ff4908818518e6258?s=96&d=mm&r=g\",\"caption\":\"the10\"},\"sameAs\":[\"https:\/\/1000.co.kr\/the10\"],\"url\":\"https:\/\/1000.co.kr\/the10\/?author=1\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"mysql \uc5d0\uc11c \uc678\ubd80IP \uc811\uadfc \ud5c8\uc6a9\ubc29\ubc95 - bongbong-w","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/1000.co.kr\/the10\/?p=60","og_locale":"ko_KR","og_type":"article","og_title":"mysql \uc5d0\uc11c \uc678\ubd80IP \uc811\uadfc \ud5c8\uc6a9\ubc29\ubc95 - bongbong-w","og_description":"MySQL\uc5d0 \uc678\ubd80 IP \uc811\uadfc\uc744 \ud5c8\uc6a9\ud558\ub294 \ubc29\ubc95\uc740 \ub2e4\uc74c\uacfc \uac19\uc740 \ub2e8\uacc4\ub97c \ud3ec\ud568\ud569\ub2c8\ub2e4. \uae30\ubcf8\uc801\uc73c\ub85c MySQL\uc740 \ub85c\uceec \ud638\uc2a4\ud2b8\uc5d0\uc11c\ub9cc \uc811\uadfc\uc744 \ud5c8\uc6a9\ud558\ub3c4\ub85d \uc124\uc815\ub418\uc5b4 \uc788\uc2b5\ub2c8\ub2e4. \uc678\ubd80\uc5d0\uc11c \uc811\uadfc\uc744 \ud5c8\uc6a9\ud558\ub824\uba74 \uba87 \uac00\uc9c0 \uc124\uc815\uc744 \ubcc0\uacbd\ud574\uc57c \ud569\ub2c8\ub2e4. sudo nano \/etc\/mysql\/mysql.conf.d\/mysqld.cnf\ubc14\uc778\ub4dc \uc8fc\uc18c \ubcc0\uacbd:\ud30c\uc77c\uc5d0\uc11c bind-address \uc18d\uc131\uc744 \ucc3e\uc2b5\ub2c8\ub2e4. \uae30\ubcf8\uac12\uc740 127.0.0.1\ub85c \uc124\uc815\ub418\uc5b4 \uc788\uc5b4 \ub85c\uceec \ud638\uc2a4\ud2b8\uc5d0\uc11c\ub9cc \uc811\uadfc\uc744 \ud5c8\uc6a9\ud569\ub2c8\ub2e4. \uc774\ub97c \ubcc0\uacbd\ud558\uc5ec \uc678\ubd80 \uc811\uadfc\uc744 \ud5c8\uc6a9\ud558\ub824\uba74 0.0.0.0\uc73c\ub85c \uc124\uc815\ud569\ub2c8\ub2e4. \uc774\ub807\uac8c \ud558\uba74 \ubaa8\ub4e0 IP \uc8fc\uc18c\uc5d0\uc11c\uc758 \uc811\uadfc\uc744...Read More &ldquo;mysql \uc5d0\uc11c \uc678\ubd80IP \uc811\uadfc \ud5c8\uc6a9\ubc29\ubc95&rdquo; &raquo;","og_url":"https:\/\/1000.co.kr\/the10\/?p=60","og_site_name":"bongbong-w","article_published_time":"2024-01-29T00:36:06+00:00","article_modified_time":"2024-01-29T00:36:07+00:00","og_image":[{"width":1024,"height":1024,"url":"https:\/\/1000.co.kr\/the10\/wp-content\/uploads\/2024\/01\/DALL\u00b7E-2024-01-29-09.33.53-An-expansive-view-of-an-Internet-Data-Center-IDC-filled-with-rows-upon-rows-of-high-capacity-server-racks.-The-racks-are-densely-packed-with-various.jpg","type":"image\/jpeg"}],"author":"the10","twitter_card":"summary_large_image","twitter_misc":{"Written by":"the10","Est. reading time":"2\ubd84"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/1000.co.kr\/the10\/?p=60","url":"https:\/\/1000.co.kr\/the10\/?p=60","name":"mysql \uc5d0\uc11c \uc678\ubd80IP \uc811\uadfc \ud5c8\uc6a9\ubc29\ubc95 - bongbong-w","isPartOf":{"@id":"https:\/\/1000.co.kr\/the10\/#website"},"datePublished":"2024-01-29T00:36:06+00:00","dateModified":"2024-01-29T00:36:07+00:00","author":{"@id":"https:\/\/1000.co.kr\/the10\/#\/schema\/person\/8b034e2e401fb3e503688a18ea86b475"},"breadcrumb":{"@id":"https:\/\/1000.co.kr\/the10\/?p=60#breadcrumb"},"inLanguage":"ko-KR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/1000.co.kr\/the10\/?p=60"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/1000.co.kr\/the10\/?p=60#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/1000.co.kr\/the10"},{"@type":"ListItem","position":2,"name":"mysql \uc5d0\uc11c \uc678\ubd80IP \uc811\uadfc \ud5c8\uc6a9\ubc29\ubc95"}]},{"@type":"WebSite","@id":"https:\/\/1000.co.kr\/the10\/#website","url":"https:\/\/1000.co.kr\/the10\/","name":"bongbong-w","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/1000.co.kr\/the10\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"ko-KR"},{"@type":"Person","@id":"https:\/\/1000.co.kr\/the10\/#\/schema\/person\/8b034e2e401fb3e503688a18ea86b475","name":"the10","image":{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/1000.co.kr\/the10\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/75f120a19fdf1795e68d13e89d5f111c576a24aa7e95823ff4908818518e6258?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/75f120a19fdf1795e68d13e89d5f111c576a24aa7e95823ff4908818518e6258?s=96&d=mm&r=g","caption":"the10"},"sameAs":["https:\/\/1000.co.kr\/the10"],"url":"https:\/\/1000.co.kr\/the10\/?author=1"}]}},"_links":{"self":[{"href":"https:\/\/1000.co.kr\/the10\/index.php?rest_route=\/wp\/v2\/posts\/60","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/1000.co.kr\/the10\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/1000.co.kr\/the10\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/1000.co.kr\/the10\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/1000.co.kr\/the10\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=60"}],"version-history":[{"count":1,"href":"https:\/\/1000.co.kr\/the10\/index.php?rest_route=\/wp\/v2\/posts\/60\/revisions"}],"predecessor-version":[{"id":63,"href":"https:\/\/1000.co.kr\/the10\/index.php?rest_route=\/wp\/v2\/posts\/60\/revisions\/63"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/1000.co.kr\/the10\/index.php?rest_route=\/wp\/v2\/media\/62"}],"wp:attachment":[{"href":"https:\/\/1000.co.kr\/the10\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=60"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/1000.co.kr\/the10\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=60"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/1000.co.kr\/the10\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=60"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}