{"id":38263,"date":"2024-11-01T16:40:44","date_gmt":"2024-11-01T16:40:44","guid":{"rendered":"http:\/\/atmokpo.com\/w\/?p=38263"},"modified":"2024-11-26T06:44:49","modified_gmt":"2024-11-26T06:44:49","slug":"%eb%8d%b0%ec%9d%b4%ed%84%b0%eb%b2%a0%ec%9d%b4%ec%8a%a4-%ec%84%9c%eb%b2%84-%ec%84%a4%ec%b9%98-%eb%b0%8f-%ea%b4%80%eb%a6%ac-%eb%8d%b0%ec%9d%b4%ed%84%b0%eb%b2%a0%ec%9d%b4%ec%8a%a4-%ec%84%b1%eb%8a%a5","status":"publish","type":"post","link":"https:\/\/atmokpo.com\/w\/38263\/","title":{"rendered":"\ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc11c\ubc84 \uc124\uce58 \ubc0f \uad00\ub9ac, \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc131\ub2a5 \ucd5c\uc801\ud654 \ubc0f \ubaa8\ub2c8\ud130\ub9c1"},"content":{"rendered":"<p><body><\/p>\n<h2>1. \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc11c\ubc84 \uac1c\uc694<\/h2>\n<p>\ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc11c\ubc84\ub294 \ub370\uc774\ud130\ub97c \uc800\uc7a5\ud558\uace0 \uad00\ub9ac\ud558\ub294 \uc911\uc559 \uc9d1\uc911\uc2dd \ucef4\ud4e8\ud130 \uc2dc\uc2a4\ud15c\uc785\ub2c8\ub2e4. \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc11c\ubc84\ub294 \uc5ec\ub7ec \uc0ac\uc6a9\uc790\uac00 \ub370\uc774\ud130\ub97c \uc548\uc804\ud558\uac8c \uc811\uadfc\ud558\uace0 \uc218\uc815\ud560 \uc218 \uc788\ub3c4\ub85d \uc9c0\uc6d0\ud569\ub2c8\ub2e4. \ub178\ub4dc\uc758 \uc218\uac00 \uc99d\uac00\ud568\uc5d0 \ub530\ub77c \uc131\ub2a5\uacfc \uad00\ub9ac\uc758 \ubcf5\uc7a1\uc131\ub3c4 \uc99d\uac00\ud558\uae30 \ub54c\ubb38\uc5d0 \uc801\uc808\ud55c \uc124\uce58 \ubc0f \uad00\ub9ac\uac00 \ud544\uc218\uc801\uc785\ub2c8\ub2e4.<\/p>\n<h2>2. \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc11c\ubc84 \uc124\uce58<\/h2>\n<p>\uc5ec\uae30\uc11c\ub294 MySQL \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc11c\ubc84\ub97c \uc124\uce58\ud558\ub294 \ubc29\ubc95\uc5d0 \ub300\ud574 \ub2e4\ub8e8\uaca0\uc2b5\ub2c8\ub2e4. MySQL\uc740 \ub110\ub9ac \uc0ac\uc6a9\ub418\ub294 \uc624\ud508 \uc18c\uc2a4 \uad00\uacc4\ud615 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uad00\ub9ac \uc2dc\uc2a4\ud15c\uc785\ub2c8\ub2e4.<\/p>\n<h3>2.1. MySQL \uc124\uce58\ud558\uae30<\/h3>\n<p>MySQL \uc124\uce58\ub97c \uc704\ud574 \ub2e4\uc74c \uba85\ub839\uc5b4\ub97c \uc0ac\uc6a9\ud558\uc138\uc694.<\/p>\n<pre><code>sudo apt update\nsudo apt install mysql-server<\/code><\/pre>\n<h3>2.2. MySQL \uc11c\ube44\uc2a4 \uc2dc\uc791 \ubc0f \uc0c1\ud0dc \ud655\uc778<\/h3>\n<p>MySQL \uc11c\ube44\uc2a4\ub97c \uc2dc\uc791\ud558\uace0 \uc0c1\ud0dc\ub97c \ud655\uc778\ud569\ub2c8\ub2e4:<\/p>\n<pre><code>sudo systemctl start mysql\nsudo systemctl status mysql<\/code><\/pre>\n<h3>2.3. MySQL \ubcf4\uc548 \uc124\uc815<\/h3>\n<p>MySQL \uc124\uce58 \ud6c4, \ubcf4\uc548\uc744 \uac15\ud654\ud558\uae30 \uc704\ud574 \ub2e4\uc74c \uba85\ub839\uc5b4\ub97c \uc2e4\ud589\ud569\ub2c8\ub2e4:<\/p>\n<pre><code>sudo mysql_secure_installation<\/code><\/pre>\n<ul>\n<li>\ub8e8\ud2b8 \ube44\ubc00\ubc88\ud638 \uc124\uc815<\/li>\n<li>\uc775\uba85 \uc0ac\uc6a9\uc790 \uc81c\uac70<\/li>\n<li>\ub8e8\ud2b8 \uc0ac\uc6a9\uc790 \uc6d0\uaca9 \ub85c\uadf8\uc778 \uc81c\ud55c<\/li>\n<li>\ud14c\uc2a4\ud2b8 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc81c\uac70<\/li>\n<li>\uad8c\ud55c \ud14c\uc774\ube14 \uc7ac\ub85c\ub4dc<\/li>\n<\/ul>\n<h2>3. \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uad00\ub9ac<\/h2>\n<p>\ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uad00\ub9ac\ud558\ub294 \uac83\uc740 \uc131\ub2a5\uc744 \ucd5c\uc801\ud654\ud558\uace0, \ub370\uc774\ud130 \ubb34\uacb0\uc131\uc744 \uc720\uc9c0\ud558\uba70, \uc548\uc804\uc131\uc744 \uac15\ud654\ud558\ub294 \ub370 \uc911\uc694\ud569\ub2c8\ub2e4. \ub2e4\uc74c\uc740 \uae30\ubcf8\uc801\uc778 \uad00\ub9ac \uc791\uc5c5\uc785\ub2c8\ub2e4.<\/p>\n<h3>3.1. \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ubc0f \ud14c\uc774\ube14 \uc0dd\uc131<\/h3>\n<p>\uc0c8\ub85c\uc6b4 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc640 \ud14c\uc774\ube14\uc744 \ub9cc\ub4dc\ub294 SQL \uba85\ub839\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4:<\/p>\n<pre><code>CREATE DATABASE my_database;\nUSE my_database;\nCREATE TABLE users (\n    id INT AUTO_INCREMENT PRIMARY KEY,\n    name VARCHAR(100),\n    email VARCHAR(100)\n);<\/code><\/pre>\n<h3>3.2. \ub370\uc774\ud130 \uc0bd\uc785<\/h3>\n<p>\uc0ac\uc6a9\uc790 \ub370\uc774\ud130\ub97c \uc0bd\uc785\ud558\ub294 \uc608\uc81c\uc785\ub2c8\ub2e4:<\/p>\n<pre><code>INSERT INTO users (name, email) VALUES ('\ud64d\uae38\ub3d9', 'hong@example.com');<\/code><\/pre>\n<h3>3.3. \ub370\uc774\ud130 \uc870\ud68c<\/h3>\n<p>\ud14c\uc774\ube14\uc758 \ub370\uc774\ud130\ub97c \uc870\ud68c\ud558\ub294 \ubc29\ubc95:<\/p>\n<pre><code>SELECT * FROM users;<\/code><\/pre>\n<h3>3.4. \ub370\uc774\ud130 \uc218\uc815 \ubc0f \uc0ad\uc81c<\/h3>\n<p>\ub370\uc774\ud130 \uc218\uc815 \ubc0f \uc0ad\uc81c\ub97c \uc704\ud55c \ubc29\ubc95:<\/p>\n<pre><code>UPDATE users SET email='new_email@example.com' WHERE name='\ud64d\uae38\ub3d9';\nDELETE FROM users WHERE name='\ud64d\uae38\ub3d9';<\/code><\/pre>\n<h2>4. \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc131\ub2a5 \ucd5c\uc801\ud654<\/h2>\n<p>\ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc131\ub2a5\uc744 \ucd5c\uc801\ud654\ud558\uae30 \uc704\ud55c \ubc29\ubc95\uc740 \ub2e4\uc591\ud569\ub2c8\ub2e4. \uc774 \uc139\uc158\uc5d0\uc11c\ub294 \uba87 \uac00\uc9c0 \uc911\uc694\ud55c \ud14c\ud06c\ub2c9\uc744 \uc18c\uac1c\ud558\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n<h3>4.1. \uc778\ub371\uc2a4 \uc0ac\uc6a9<\/h3>\n<p>\uc778\ub371\uc2a4\ub294 \uac80\uc0c9 \uc131\ub2a5\uc744 \ud06c\uac8c \ud5a5\uc0c1\uc2dc\ud0ac \uc218 \uc788\ub294 \ub370\uc774\ud130 \uad6c\uc870\uc785\ub2c8\ub2e4. \uc778\ub371\uc2a4\ub97c \uc0dd\uc131\ud558\ub294 \ubc29\ubc95:<\/p>\n<pre><code>CREATE INDEX idx_name ON users (name);<\/code><\/pre>\n<h3>4.2. \ucffc\ub9ac \ucd5c\uc801\ud654<\/h3>\n<p>\ube44\ud6a8\uc728\uc801\uc778 \ucffc\ub9ac\ub294 \uc131\ub2a5 \uc800\ud558\ub97c \ucd08\ub798\ud569\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4, <code>SELECT<\/code>\ubb38\uc744 \ub2e4\uc74c\uacfc \uac19\uc774 \ucd5c\uc801\ud654\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4:<\/p>\n<pre><code>SELECT name FROM users WHERE email LIKE '%@example.com';<\/code><\/pre>\n<h3>4.3. \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc124\uc815 \uc870\uc815<\/h3>\n<p>MySQL\uc758 \uc124\uc815 \ud30c\uc77c\uc744 \uc218\uc815\ud558\uc5ec \uc131\ub2a5\uc744 \ucd5c\uc801\ud654\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc77c\ubc18\uc801\uc73c\ub85c <code>\/etc\/mysql\/my.cnf<\/code> \ud30c\uc77c\uc5d0\uc11c \uc870\uc815\ud569\ub2c8\ub2e4.<\/p>\n<h2>5. \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ubaa8\ub2c8\ud130\ub9c1<\/h2>\n<p>\ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc131\ub2a5\uc744 \uc9c0\uc18d\uc801\uc73c\ub85c \ubaa8\ub2c8\ud130\ub9c1\ud558\ub294 \uac83\uc740 \ubb38\uc81c\ub97c \uc870\uae30\uc5d0 \ubc1c\uacac\ud558\uace0 \ub300\ucc98\ud558\ub294 \ub370 \uc720\uc6a9\ud569\ub2c8\ub2e4. \ub2e4\uc74c\uc740 MySQL \ubaa8\ub2c8\ud130\ub9c1\uc744 \uc704\ud55c \uae30\ubcf8\uc801\uc778 \ubc29\ubc95\uc785\ub2c8\ub2e4.<\/p>\n<h3>5.1. MySQL \uc0c1\ud0dc \ubcf4\uae30<\/h3>\n<p>\ud604\uc7ac \uc11c\ubc84 \uc0c1\ud0dc\ub97c \ud655\uc778\ud558\ub294 SQL \uba85\ub839:<\/p>\n<pre><code>SHOW STATUS;<\/code><\/pre>\n<h3>5.2. \ucffc\ub9ac \uc131\ub2a5 \ubaa8\ub2c8\ud130\ub9c1<\/h3>\n<p>\uc2ac\ub85c\uc6b0 \ucffc\ub9ac \ub85c\uadf8\ub97c \ud65c\uc131\ud654\ud558\uc5ec \uc131\ub2a5 \ubb38\uc81c\ub97c \uc2dd\ubcc4\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc774 \uc124\uc815\uc740 <code>my.cnf<\/code>\uc5d0\uc11c \ub2e4\uc74c\uacfc \uac19\uc774 \uc124\uc815\ud569\ub2c8\ub2e4:<\/p>\n<pre><code>[mysqld]\nslow_query_log = 1\nslow_query_log_file = \/var\/log\/mysql\/mysql-slow.log\nlong_query_time = 1<\/code><\/pre>\n<h3>5.3. \ubaa8\ub2c8\ud130\ub9c1 \ub3c4\uad6c<\/h3>\n<p>\uc5ec\ub7ec\uac00\uc9c0 \ub3c4\uad6c\ub97c \uc0ac\uc6a9\ud558\uc5ec \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc131\ub2a5\uc744 \ubaa8\ub2c8\ud130\ub9c1\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ucd94\ucc9c \ub3c4\uad6c\ub85c\ub294 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4:<\/p>\n<ul>\n<li>MySQL Workbench<\/li>\n<li>phpMyAdmin<\/li>\n<li>Prometheus \ubc0f Grafana<\/li>\n<\/ul>\n<h2>6. \uacb0\ub860<\/h2>\n<p>\ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc11c\ubc84 \uc124\uce58, \uad00\ub9ac, \ucd5c\uc801\ud654 \ubc0f \ubaa8\ub2c8\ud130\ub9c1\uc740 \ubcf5\uc7a1\ud558\uc9c0\ub9cc \ud544\uc218\uc801\uc778 \uc791\uc5c5\uc785\ub2c8\ub2e4. \uc704\uc5d0\uc11c \uc124\uba85\ud55c \ubc29\ubc95\ub4e4\uc744 \ud1b5\ud574 \ud6a8\uc728\uc801\uc778 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc6b4\uc601\uc744 \uc720\uc9c0\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc9c0\uc18d\uc801\uc778 \ud559\uc2b5\uacfc \uacbd\ud5d8\uc744 \ud1b5\ud574 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uad00\ub9ac\uc758 \ub178\ud558\uc6b0\ub97c \uc313\uc544\uac00\uc2dc\uae30 \ubc14\ub78d\ub2c8\ub2e4.<\/p>\n<h2>\ucc38\uace0\uc790\ub8cc<\/h2>\n<ul>\n<li><a community=\"\" how-to-install-mysql-on-ubuntu-20-04\"=\"\" href=\"https:\/\/dev.mysql.com\/doc\/&gt;MySQL \uacf5\uc2dd \ubb38\uc11c&lt;\/a&gt;&lt;\/li&gt;\n        &lt;li&gt;&lt;a href=\" https:=\"\" tutorials=\"\" www.digitalocean.com=\"\">DigitalOcean: MySQL \uc124\uce58 \ud29c\ud1a0\ub9ac\uc5bc<\/a><\/li>\n<li><a href=\"https:\/\/www.tutorialspoint.com\/mysql\/index.htm\">TutorialsPoint: MySQL \uc790\uc2b5\uc11c<\/a><\/li>\n<\/ul>\n<p><\/body><\/p>\n","protected":false},"excerpt":{"rendered":"<p>1. \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc11c\ubc84 \uac1c\uc694 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc11c\ubc84\ub294 \ub370\uc774\ud130\ub97c \uc800\uc7a5\ud558\uace0 \uad00\ub9ac\ud558\ub294 \uc911\uc559 \uc9d1\uc911\uc2dd \ucef4\ud4e8\ud130 \uc2dc\uc2a4\ud15c\uc785\ub2c8\ub2e4. \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc11c\ubc84\ub294 \uc5ec\ub7ec \uc0ac\uc6a9\uc790\uac00 \ub370\uc774\ud130\ub97c \uc548\uc804\ud558\uac8c \uc811\uadfc\ud558\uace0 \uc218\uc815\ud560 \uc218 \uc788\ub3c4\ub85d \uc9c0\uc6d0\ud569\ub2c8\ub2e4. \ub178\ub4dc\uc758 \uc218\uac00 \uc99d\uac00\ud568\uc5d0 \ub530\ub77c \uc131\ub2a5\uacfc \uad00\ub9ac\uc758 \ubcf5\uc7a1\uc131\ub3c4 \uc99d\uac00\ud558\uae30 \ub54c\ubb38\uc5d0 \uc801\uc808\ud55c \uc124\uce58 \ubc0f \uad00\ub9ac\uac00 \ud544\uc218\uc801\uc785\ub2c8\ub2e4. 2. \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc11c\ubc84 \uc124\uce58 \uc5ec\uae30\uc11c\ub294 MySQL \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc11c\ubc84\ub97c \uc124\uce58\ud558\ub294 \ubc29\ubc95\uc5d0 \ub300\ud574 \ub2e4\ub8e8\uaca0\uc2b5\ub2c8\ub2e4. MySQL\uc740 \ub110\ub9ac \uc0ac\uc6a9\ub418\ub294 \uc624\ud508 \uc18c\uc2a4 &hellip; <a href=\"https:\/\/atmokpo.com\/w\/38263\/\" class=\"more-link\">\ub354 \ubcf4\uae30<span class=\"screen-reader-text\"> &#8220;\ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc11c\ubc84 \uc124\uce58 \ubc0f \uad00\ub9ac, \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc131\ub2a5 \ucd5c\uc801\ud654 \ubc0f \ubaa8\ub2c8\ud130\ub9c1&#8221;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[179],"tags":[],"class_list":["post-38263","post","type-post","status-publish","format-standard","hentry","category-179"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.2 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>\ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc11c\ubc84 \uc124\uce58 \ubc0f \uad00\ub9ac, \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc131\ub2a5 \ucd5c\uc801\ud654 \ubc0f \ubaa8\ub2c8\ud130\ub9c1 - \ub77c\uc774\ube0c\uc2a4\ub9c8\ud2b8<\/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:\/\/atmokpo.com\/w\/38263\/\" \/>\n<meta property=\"og:locale\" content=\"ko_KR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc11c\ubc84 \uc124\uce58 \ubc0f \uad00\ub9ac, \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc131\ub2a5 \ucd5c\uc801\ud654 \ubc0f \ubaa8\ub2c8\ud130\ub9c1 - \ub77c\uc774\ube0c\uc2a4\ub9c8\ud2b8\" \/>\n<meta property=\"og:description\" content=\"1. \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc11c\ubc84 \uac1c\uc694 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc11c\ubc84\ub294 \ub370\uc774\ud130\ub97c \uc800\uc7a5\ud558\uace0 \uad00\ub9ac\ud558\ub294 \uc911\uc559 \uc9d1\uc911\uc2dd \ucef4\ud4e8\ud130 \uc2dc\uc2a4\ud15c\uc785\ub2c8\ub2e4. \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc11c\ubc84\ub294 \uc5ec\ub7ec \uc0ac\uc6a9\uc790\uac00 \ub370\uc774\ud130\ub97c \uc548\uc804\ud558\uac8c \uc811\uadfc\ud558\uace0 \uc218\uc815\ud560 \uc218 \uc788\ub3c4\ub85d \uc9c0\uc6d0\ud569\ub2c8\ub2e4. \ub178\ub4dc\uc758 \uc218\uac00 \uc99d\uac00\ud568\uc5d0 \ub530\ub77c \uc131\ub2a5\uacfc \uad00\ub9ac\uc758 \ubcf5\uc7a1\uc131\ub3c4 \uc99d\uac00\ud558\uae30 \ub54c\ubb38\uc5d0 \uc801\uc808\ud55c \uc124\uce58 \ubc0f \uad00\ub9ac\uac00 \ud544\uc218\uc801\uc785\ub2c8\ub2e4. 2. \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc11c\ubc84 \uc124\uce58 \uc5ec\uae30\uc11c\ub294 MySQL \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc11c\ubc84\ub97c \uc124\uce58\ud558\ub294 \ubc29\ubc95\uc5d0 \ub300\ud574 \ub2e4\ub8e8\uaca0\uc2b5\ub2c8\ub2e4. MySQL\uc740 \ub110\ub9ac \uc0ac\uc6a9\ub418\ub294 \uc624\ud508 \uc18c\uc2a4 &hellip; \ub354 \ubcf4\uae30 &quot;\ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc11c\ubc84 \uc124\uce58 \ubc0f \uad00\ub9ac, \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc131\ub2a5 \ucd5c\uc801\ud654 \ubc0f \ubaa8\ub2c8\ud130\ub9c1&quot;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/atmokpo.com\/w\/38263\/\" \/>\n<meta property=\"og:site_name\" content=\"\ub77c\uc774\ube0c\uc2a4\ub9c8\ud2b8\" \/>\n<meta property=\"article:published_time\" content=\"2024-11-01T16:40:44+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-11-26T06:44:49+00:00\" \/>\n<meta name=\"author\" content=\"root\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@bebubo4\" \/>\n<meta name=\"twitter:site\" content=\"@bebubo4\" \/>\n<meta name=\"twitter:label1\" content=\"\uae00\uc4f4\uc774\" \/>\n\t<meta name=\"twitter:data1\" content=\"root\" \/>\n\t<meta name=\"twitter:label2\" content=\"\uc608\uc0c1 \ub418\ub294 \ud310\ub3c5 \uc2dc\uac04\" \/>\n\t<meta name=\"twitter:data2\" content=\"1\ubd84\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/atmokpo.com\/w\/38263\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/atmokpo.com\/w\/38263\/\"},\"author\":{\"name\":\"root\",\"@id\":\"https:\/\/atmokpo.com\/w\/#\/schema\/person\/91b6b3b138fbba0efb4ae64b1abd81d7\"},\"headline\":\"\ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc11c\ubc84 \uc124\uce58 \ubc0f \uad00\ub9ac, \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc131\ub2a5 \ucd5c\uc801\ud654 \ubc0f \ubaa8\ub2c8\ud130\ub9c1\",\"datePublished\":\"2024-11-01T16:40:44+00:00\",\"dateModified\":\"2024-11-26T06:44:49+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/atmokpo.com\/w\/38263\/\"},\"wordCount\":18,\"publisher\":{\"@id\":\"https:\/\/atmokpo.com\/w\/#organization\"},\"articleSection\":[\"\uc11c\ubc84\uad6c\ucd95\uc6b4\uc601\"],\"inLanguage\":\"ko-KR\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/atmokpo.com\/w\/38263\/\",\"url\":\"https:\/\/atmokpo.com\/w\/38263\/\",\"name\":\"\ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc11c\ubc84 \uc124\uce58 \ubc0f \uad00\ub9ac, \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc131\ub2a5 \ucd5c\uc801\ud654 \ubc0f \ubaa8\ub2c8\ud130\ub9c1 - \ub77c\uc774\ube0c\uc2a4\ub9c8\ud2b8\",\"isPartOf\":{\"@id\":\"https:\/\/atmokpo.com\/w\/#website\"},\"datePublished\":\"2024-11-01T16:40:44+00:00\",\"dateModified\":\"2024-11-26T06:44:49+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/atmokpo.com\/w\/38263\/#breadcrumb\"},\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/atmokpo.com\/w\/38263\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/atmokpo.com\/w\/38263\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\ud648\",\"item\":\"https:\/\/atmokpo.com\/w\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc11c\ubc84 \uc124\uce58 \ubc0f \uad00\ub9ac, \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc131\ub2a5 \ucd5c\uc801\ud654 \ubc0f \ubaa8\ub2c8\ud130\ub9c1\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/atmokpo.com\/w\/#website\",\"url\":\"https:\/\/atmokpo.com\/w\/\",\"name\":\"\ub77c\uc774\ube0c\uc2a4\ub9c8\ud2b8\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/atmokpo.com\/w\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/atmokpo.com\/w\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"ko-KR\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/atmokpo.com\/w\/#organization\",\"name\":\"\ub77c\uc774\ube0c\uc2a4\ub9c8\ud2b8\",\"url\":\"https:\/\/atmokpo.com\/w\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\/\/atmokpo.com\/w\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/atmokpo.com\/w\/wp-content\/uploads\/2024\/11\/logo.png\",\"contentUrl\":\"https:\/\/atmokpo.com\/w\/wp-content\/uploads\/2024\/11\/logo.png\",\"width\":400,\"height\":400,\"caption\":\"\ub77c\uc774\ube0c\uc2a4\ub9c8\ud2b8\"},\"image\":{\"@id\":\"https:\/\/atmokpo.com\/w\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/x.com\/bebubo4\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/atmokpo.com\/w\/#\/schema\/person\/91b6b3b138fbba0efb4ae64b1abd81d7\",\"name\":\"root\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\/\/atmokpo.com\/w\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/708197b41fc6435a7ce22d951b25d4a47e9e904270cb1f04682d4f025066f80c?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/708197b41fc6435a7ce22d951b25d4a47e9e904270cb1f04682d4f025066f80c?s=96&d=mm&r=g\",\"caption\":\"root\"},\"sameAs\":[\"http:\/\/atmokpo.com\/w\"],\"url\":\"https:\/\/atmokpo.com\/w\/author\/root\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc11c\ubc84 \uc124\uce58 \ubc0f \uad00\ub9ac, \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc131\ub2a5 \ucd5c\uc801\ud654 \ubc0f \ubaa8\ub2c8\ud130\ub9c1 - \ub77c\uc774\ube0c\uc2a4\ub9c8\ud2b8","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:\/\/atmokpo.com\/w\/38263\/","og_locale":"ko_KR","og_type":"article","og_title":"\ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc11c\ubc84 \uc124\uce58 \ubc0f \uad00\ub9ac, \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc131\ub2a5 \ucd5c\uc801\ud654 \ubc0f \ubaa8\ub2c8\ud130\ub9c1 - \ub77c\uc774\ube0c\uc2a4\ub9c8\ud2b8","og_description":"1. \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc11c\ubc84 \uac1c\uc694 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc11c\ubc84\ub294 \ub370\uc774\ud130\ub97c \uc800\uc7a5\ud558\uace0 \uad00\ub9ac\ud558\ub294 \uc911\uc559 \uc9d1\uc911\uc2dd \ucef4\ud4e8\ud130 \uc2dc\uc2a4\ud15c\uc785\ub2c8\ub2e4. \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc11c\ubc84\ub294 \uc5ec\ub7ec \uc0ac\uc6a9\uc790\uac00 \ub370\uc774\ud130\ub97c \uc548\uc804\ud558\uac8c \uc811\uadfc\ud558\uace0 \uc218\uc815\ud560 \uc218 \uc788\ub3c4\ub85d \uc9c0\uc6d0\ud569\ub2c8\ub2e4. \ub178\ub4dc\uc758 \uc218\uac00 \uc99d\uac00\ud568\uc5d0 \ub530\ub77c \uc131\ub2a5\uacfc \uad00\ub9ac\uc758 \ubcf5\uc7a1\uc131\ub3c4 \uc99d\uac00\ud558\uae30 \ub54c\ubb38\uc5d0 \uc801\uc808\ud55c \uc124\uce58 \ubc0f \uad00\ub9ac\uac00 \ud544\uc218\uc801\uc785\ub2c8\ub2e4. 2. \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc11c\ubc84 \uc124\uce58 \uc5ec\uae30\uc11c\ub294 MySQL \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc11c\ubc84\ub97c \uc124\uce58\ud558\ub294 \ubc29\ubc95\uc5d0 \ub300\ud574 \ub2e4\ub8e8\uaca0\uc2b5\ub2c8\ub2e4. MySQL\uc740 \ub110\ub9ac \uc0ac\uc6a9\ub418\ub294 \uc624\ud508 \uc18c\uc2a4 &hellip; \ub354 \ubcf4\uae30 \"\ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc11c\ubc84 \uc124\uce58 \ubc0f \uad00\ub9ac, \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc131\ub2a5 \ucd5c\uc801\ud654 \ubc0f \ubaa8\ub2c8\ud130\ub9c1\"","og_url":"https:\/\/atmokpo.com\/w\/38263\/","og_site_name":"\ub77c\uc774\ube0c\uc2a4\ub9c8\ud2b8","article_published_time":"2024-11-01T16:40:44+00:00","article_modified_time":"2024-11-26T06:44:49+00:00","author":"root","twitter_card":"summary_large_image","twitter_creator":"@bebubo4","twitter_site":"@bebubo4","twitter_misc":{"\uae00\uc4f4\uc774":"root","\uc608\uc0c1 \ub418\ub294 \ud310\ub3c5 \uc2dc\uac04":"1\ubd84"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/atmokpo.com\/w\/38263\/#article","isPartOf":{"@id":"https:\/\/atmokpo.com\/w\/38263\/"},"author":{"name":"root","@id":"https:\/\/atmokpo.com\/w\/#\/schema\/person\/91b6b3b138fbba0efb4ae64b1abd81d7"},"headline":"\ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc11c\ubc84 \uc124\uce58 \ubc0f \uad00\ub9ac, \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc131\ub2a5 \ucd5c\uc801\ud654 \ubc0f \ubaa8\ub2c8\ud130\ub9c1","datePublished":"2024-11-01T16:40:44+00:00","dateModified":"2024-11-26T06:44:49+00:00","mainEntityOfPage":{"@id":"https:\/\/atmokpo.com\/w\/38263\/"},"wordCount":18,"publisher":{"@id":"https:\/\/atmokpo.com\/w\/#organization"},"articleSection":["\uc11c\ubc84\uad6c\ucd95\uc6b4\uc601"],"inLanguage":"ko-KR"},{"@type":"WebPage","@id":"https:\/\/atmokpo.com\/w\/38263\/","url":"https:\/\/atmokpo.com\/w\/38263\/","name":"\ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc11c\ubc84 \uc124\uce58 \ubc0f \uad00\ub9ac, \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc131\ub2a5 \ucd5c\uc801\ud654 \ubc0f \ubaa8\ub2c8\ud130\ub9c1 - \ub77c\uc774\ube0c\uc2a4\ub9c8\ud2b8","isPartOf":{"@id":"https:\/\/atmokpo.com\/w\/#website"},"datePublished":"2024-11-01T16:40:44+00:00","dateModified":"2024-11-26T06:44:49+00:00","breadcrumb":{"@id":"https:\/\/atmokpo.com\/w\/38263\/#breadcrumb"},"inLanguage":"ko-KR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/atmokpo.com\/w\/38263\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/atmokpo.com\/w\/38263\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\ud648","item":"https:\/\/atmokpo.com\/w\/en\/"},{"@type":"ListItem","position":2,"name":"\ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc11c\ubc84 \uc124\uce58 \ubc0f \uad00\ub9ac, \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc131\ub2a5 \ucd5c\uc801\ud654 \ubc0f \ubaa8\ub2c8\ud130\ub9c1"}]},{"@type":"WebSite","@id":"https:\/\/atmokpo.com\/w\/#website","url":"https:\/\/atmokpo.com\/w\/","name":"\ub77c\uc774\ube0c\uc2a4\ub9c8\ud2b8","description":"","publisher":{"@id":"https:\/\/atmokpo.com\/w\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/atmokpo.com\/w\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"ko-KR"},{"@type":"Organization","@id":"https:\/\/atmokpo.com\/w\/#organization","name":"\ub77c\uc774\ube0c\uc2a4\ub9c8\ud2b8","url":"https:\/\/atmokpo.com\/w\/","logo":{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/atmokpo.com\/w\/#\/schema\/logo\/image\/","url":"https:\/\/atmokpo.com\/w\/wp-content\/uploads\/2024\/11\/logo.png","contentUrl":"https:\/\/atmokpo.com\/w\/wp-content\/uploads\/2024\/11\/logo.png","width":400,"height":400,"caption":"\ub77c\uc774\ube0c\uc2a4\ub9c8\ud2b8"},"image":{"@id":"https:\/\/atmokpo.com\/w\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/x.com\/bebubo4"]},{"@type":"Person","@id":"https:\/\/atmokpo.com\/w\/#\/schema\/person\/91b6b3b138fbba0efb4ae64b1abd81d7","name":"root","image":{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/atmokpo.com\/w\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/708197b41fc6435a7ce22d951b25d4a47e9e904270cb1f04682d4f025066f80c?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/708197b41fc6435a7ce22d951b25d4a47e9e904270cb1f04682d4f025066f80c?s=96&d=mm&r=g","caption":"root"},"sameAs":["http:\/\/atmokpo.com\/w"],"url":"https:\/\/atmokpo.com\/w\/author\/root\/"}]}},"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack-related-posts":[],"_links":{"self":[{"href":"https:\/\/atmokpo.com\/w\/wp-json\/wp\/v2\/posts\/38263","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/atmokpo.com\/w\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/atmokpo.com\/w\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/atmokpo.com\/w\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/atmokpo.com\/w\/wp-json\/wp\/v2\/comments?post=38263"}],"version-history":[{"count":1,"href":"https:\/\/atmokpo.com\/w\/wp-json\/wp\/v2\/posts\/38263\/revisions"}],"predecessor-version":[{"id":38264,"href":"https:\/\/atmokpo.com\/w\/wp-json\/wp\/v2\/posts\/38263\/revisions\/38264"}],"wp:attachment":[{"href":"https:\/\/atmokpo.com\/w\/wp-json\/wp\/v2\/media?parent=38263"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/atmokpo.com\/w\/wp-json\/wp\/v2\/categories?post=38263"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/atmokpo.com\/w\/wp-json\/wp\/v2\/tags?post=38263"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}