{"id":655,"date":"2002-11-07T03:06:34","date_gmt":"2002-11-07T03:06:34","guid":{"rendered":"http:\/\/dev.jblove.net\/?p=655"},"modified":"2002-11-07T03:06:34","modified_gmt":"2002-11-07T03:06:34","slug":"mysql-%ec%bd%98%ec%86%94%ec%9d%84-%ed%99%9c%ec%9a%a9%ed%95%98%ec%9e%90","status":"publish","type":"post","link":"https:\/\/jblove.net\/?p=655","title":{"rendered":"mysql \ucf58\uc194\uc744 \ud65c\uc6a9\ud558\uc790"},"content":{"rendered":"

\uc870\ub098\ub2e8<\/p>\n

\nmysql \ucf58\uc194\ud074\ub77c\uc774\uc5b8\ud2b8\ubcf4\ub2e4 \uc694\uc998\uc740 phpMyAdmin \uac19\uc740 \uad00\ub9ac\ud234\uc744 \ub9ce\uc774 \uc0ac\uc6a9\ud558\ub294\uac83 \uac19\uc2b5\ub2c8\ub2e4.
\n\ucf58\uc194\ud074\ub77c\uc774\uc5b8\ud2b8\ub3c4 \ub098\ub984\ub300\ub85c \uc798 \uc0ac\uc6a9\ud558\uba74 \uc720\uc6a9\ud558\uac8c \uc0ac\uc6a9\ud560\uc218 \uc788\uc2b5\ub2c8\ub2e4.
\n\uc81c\uac00 \uc790\uc8fc \uc4f0\ub294 \uba87\uac00\uc9c0 \uae30\ub2a5\uc744 \uc18c\uac1c\ud560\uae4c \ud569\ub2c8\ub2e4.
\n\uc5ec\uae30\ub2e4\uac00 \uadf8\ub0e5 \ubc14\ub85c \uc0dd\uac01\ub098\ub294 \ub300\ub85c \uc4f0\ub294 \uad00\uacc4\ub85c \uc880 \uc815\ub9ac\uac00 \uc548\ub420\uc218\ub3c4 \uc788\uaca0\ub124\uc694.<\/p>\n

1. \ucffc\ub9ac \uacb0\uacfc \uc815\ub82c\ubc29\uc2dd
\nmysql> use mysql
\nmysql> select * form user where user = ‘root’ ;
\n\uc774\ub7f0\uc2dd\uc73c\ub85c \uc0ac\uc6a9\ud588\uc744\uacbd\uc6b0 \uacb0\uacfc\uac00 \uc88c\uc6b0\ub85c \uae38\uac8c \ub098\uc640 \ubcf4\uae30\uac00 \ubd88\ud3b8\ud558\ub2e4\uad6c\uc694?
\n\uadf8\ub7fc \uc774\ub807\uac8c \uc0ac\uc6a9\ud574\ubcf4\uc138\uc694.
\nmysql> select * from user where user=’root’ G
\n\uadf8\ub7fc \uc138\ub85c\ub85c \uacb0\uacfc\ub97c \ucd9c\ub825\ud569\ub2c8\ub2e4.<\/p>\n

\uc124\uba85) ; \uc640 g \ub294 \uac00\ub85c\ucd9c\ub825 G \uc138\ub85c \ucd9c\ub825\uc785\ub2c8\ub2e4.<\/p>\n

2. \ucffc\ub9ac \uc5d0\ub514\ud130
\n\uae38\uac8c \uc785\ub824\ud55c \ucffc\ub9ac\uc758 \uc774\ubd80\ubd84\ub9cc \uace0\uce58\uace0 \uc2f6\uc740\ub370 \uc218\uc815\uc774 \ubd88\ud3b8\ud55c\uac00\uc694?<\/p>\n

mysql > use mysql
\nmysql > select * from user where user=’root’
\nmysql > and host=’localhost’ and Select_priv = ‘Y’
\nmysql > and Insert_priv = ‘Y’ ;
\n\uc790 \uc774\ub807\uac8c \uae38\uac8c \ucffc\ub9ac\ub97c \ub0a0\ub838\ub294\ub370 \uc774\uc911\uc5d0 \uc77c\ubd80\ubd84\ub9cc \uc218\uc815\ud574\uc57c \ud55c\ub2e4\uba74
\nmysql> e
\n\uadf8\ub7ec\uba74 vi \uc5d0\ub514\ud130\uac00 \uc2e4\ud589\ub429\ub2c8\ub2e4. \uc5ec\uae30\uc11c \uc801\uc808\ud788 \uc218\uc815\ud558\uc2e0\ud6c4 \uc800\uc7a5\ud6c4 \uc885\ub8cc (:wq) \ud558\uc2dc\uace0
\nmysql> G
\n; g G \ub97c \ub123\uc5b4\uc8fc\uc2dc\uba74 \ud3b8\uc9d1\ud55c \ub0b4\uc6a9\uc774 \uc2e4\ud589\ub429\ub2c8\ub2e4.<\/p>\n

3. \ucffc\ub9ac \uae30\ub85d
\n\uacb0\uacfc\ub098 \ucffc\ub9ac \ub0b4\uc6a9\uc744 \ud30c\uc77c\ub85c \uc800\uc7a5\ud558\uace0 \uc2f6\ub2e4\uad6c\uc694?<\/p>\n

msyql> tee \/tmp\/test.txt
\n\uc774\ud6c4\uc5d0 \uc0ac\uc6a9\ud558\ub294 \ubaa8\ub4e0 \ub0b4\uc6a9\uc740 test.txt \uc5d0 \ub0a8\uac8c \ub429\ub2c8\ub2e4.
\n\ud574\uc81c\ub294
\nmysql> notee<\/p>\n","protected":false},"excerpt":{"rendered":"

\uc870\ub098\ub2e8 mysql \ucf58\uc194\ud074\ub77c\uc774\uc5b8\ud2b8\ubcf4\ub2e4 \uc694\uc998\uc740 phpMyAdmin \uac19\uc740 \uad00\ub9ac\ud234\uc744 \ub9ce\uc774 \uc0ac\uc6a9\ud558\ub294\uac83 \uac19\uc2b5\ub2c8\ub2e4. \ucf58\uc194\ud074\ub77c\uc774\uc5b8\ud2b8\ub3c4 \ub098\ub984\ub300\ub85c \uc798 \uc0ac\uc6a9\ud558\uba74 \uc720\uc6a9\ud558\uac8c \uc0ac\uc6a9\ud560\uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc81c\uac00 \uc790\uc8fc \uc4f0\ub294 \uba87\uac00\uc9c0 \uae30\ub2a5\uc744 \uc18c\uac1c\ud560\uae4c \ud569\ub2c8\ub2e4. \uc5ec\uae30\ub2e4\uac00 \uadf8\ub0e5 \ubc14\ub85c \uc0dd\uac01\ub098\ub294 \ub300\ub85c \uc4f0\ub294 \uad00\uacc4\ub85c \uc880 \uc815\ub9ac\uac00 \uc548\ub420\uc218\ub3c4 \uc788\uaca0\ub124\uc694. 1. \ucffc\ub9ac \uacb0\uacfc \uc815\ub82c\ubc29\uc2dd mysql> use mysql mysql> select * form user where user = ‘root’ ; \uc774\ub7f0\uc2dd\uc73c\ub85c \uc0ac\uc6a9\ud588\uc744\uacbd\uc6b0 \uacb0\uacfc\uac00 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[51],"tags":[],"class_list":["post-655","post","type-post","status-publish","format-standard","hentry","category-papa-php"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/jblove.net\/index.php?rest_route=\/wp\/v2\/posts\/655","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jblove.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jblove.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jblove.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jblove.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=655"}],"version-history":[{"count":0,"href":"https:\/\/jblove.net\/index.php?rest_route=\/wp\/v2\/posts\/655\/revisions"}],"wp:attachment":[{"href":"https:\/\/jblove.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=655"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jblove.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=655"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jblove.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=655"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}