{"id":2820,"date":"2009-03-26T03:53:03","date_gmt":"2009-03-26T03:53:03","guid":{"rendered":"http:\/\/www.happyfam.or.kr\/ysoh\/mysql-%ea%b8%b0%eb%b3%b8\/"},"modified":"2015-02-10T21:12:16","modified_gmt":"2015-02-10T12:12:16","slug":"mysql-%ea%b8%b0%eb%b3%b8","status":"publish","type":"post","link":"https:\/\/www.happyfam.or.kr\/ysoh\/mysql-%ea%b8%b0%eb%b3%b8\/","title":{"rendered":"MySQL \uae30\ubcf8"},"content":{"rendered":"

MySQL Server\uc758 \uc124\uce58\uac00 \uc644\ub8cc\ub410\uc73c\uba74 \uc774\uc81c MySQL \uc0ac\uc6a9\ubc95\uc744 \uc775\ud600\ubcf4\uae30 \uc704\ud574 Windows “\uba85\ub839 \ud504\ub86c\ud504\ud2b8”\ub97c \uc2e4\ud589\ud558\uc790. “\uba85\ub839 \ud504\ub86c\ud504\ud2b8”\ub294 XP\uc758 \uacbd\uc6b0 “\uc2dc\uc791 -> \ubaa8\ub4e0\ud504\ub85c\uadf8\ub7a8 -> \ubcf4\uc870\ud504\ub85c\uadf8\ub7a8 -> \uba85\ub82c \ud504\ub86c\ud504\ud2b8”\ub97c \ud1b5\ud574 \uc2e4\ud589\ud558\uac70\ub098 \ub610\ub294 “\uc2dc\uc791 -> \uc2e4\ud589” \ucc3d\uc5d0\uc11c “cmd”\ub97c \uc785\ub825\ud558\uba74 \uc2e4\ud589\ud560 \uc218 \uc788\ub2e4.

\uc6b0\ub9ac\uac00 \uc124\uce58\ud55c MySQL Server\ub294 OS(Windows \ub610\ub294 UNIX)\uac00 \ubd80\ud305\ub420 \ub54c \uc790\ub3d9\uc73c\ub85c \uc2dc\uc791\ub418\ub294 \ubc94\uc6a9 DBMS\uc774\uba70, \uc11c\ubc84\uc640 \ud074\ub77c\uc774\uc5b8\ud2b8 \uad6c\uc870\ub85c \ub098\ub25c\ub2e4. \uc11c\ubc84\ub294 \ub370\uc774\ud130\ub97c \ud130\ub9ac\ud558\ub294 \ud575\uc2ec\uc774 \ub418\ub294 \ud504\ub85c\uadf8\ub7a8\uc73c\ub85c \uba85\ub839 \ub610\ub294 \ucffc\ub9ac\ub97c \ubc1b\uc73c\uba74 \uadf8\uc5d0 \ud569\ub2f9\ud558\uac8c \ub370\uc774\ud130\ub97c \uc870\uc791\ud558\ub294 \uc5ed\ud560\uc744 \ud55c\ub2e4. \uc11c\ubc84\ub294 \uc0ac\uc6a9\uc790\uac00 \uc9c1\uc811 \uc870\uc791\ud560 \uc218 \uc5c6\uc73c\uba70, \ud074\ub77c\uc774\uc5b8\ud2b8 \ud504\ub85c\uadf8\ub7a8\uc744 \ud1b5\ud574 \uc11c\ubc84\uc5d0 \uba85\ub839\uc744 \uc804\ub2ec\ud558\uace0 \uc11c\ubc84\ub85c\ubd80\ud130 \ucc98\ub9ac\ub41c \uacb0\uacfc \uc5ed\uc2dc \ud074\ub77c\uc774\uc5b8\ud2b8\ub97c \ud1b5\ud574 \uc804\ub2ec \ubc1b\ub294\ub2e4. \uadf8\ub7ec\ubbc0\ub85c \uc11c\ubc84\ub97c \uc124\uce58\ud560 \ub54c \ubb38\uc790 \uae30\ubc18\uc758 “mysql”\uc774\ub780 \ud074\ub77c\uc774\uc5b8\ud2b8 \ud504\ub85c\uadf8\ub7a8\uc744 \ud568\uaed8 \uc124\uce58\ud55c\ub2e4. “mysql”\uc744 \uc774\uc6a9 \uc11c\ubc84\uc5d0 \uc811\uc18d\ud558\ub294 \ubc29\ubc95\uc740 \uc5ec\ub7ec\uac00\uc9c0\uac00 \uc788\uc73c\ub098 \uc77c\ubc18\uc801\uc73c\ub85c \ub2e4\uc74c\uacfc \uac19\uc740 \ubc29\ubc95\uc744 \uc0ac\uc6a9\ud55c\ub2e4.


\n

mysql   -u  \uc0ac\uc6a9\uc790ID<\/SPAN>  -p<\/DIV>

“-u” \uc635\uc158 \ub4a4\uc5d0\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc0ac\uc6a9\uc790 ID\ub97c \uc900\ub2e4. \uadf8\ub9ac\uace0 \ud574\ub2f9 \uc0ac\uc6a9\uc790 ID\ub85c \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc11c\ubc84\uc5d0 \uc811\uc18d\ud560 \ub54c \ube44\ubc00\ubc88\ud638\uac00 \ud544\uc694\ud558\uba74 “-p” \uc635\uc158\uc744 \uc918\uc57c \ud55c\ub2e4.

\uadf8\ub7ec\uba74 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc11c\ubc84\uc5d0 \uad00\ub9ac\uc790\ub85c \uc811\uc18d\ud558\uae30 \uc704\ud574 \ub2e4\uc74c \uba85\ub839\uc744 \uc785\ub825\ud574 \ubcf4\uc790.


\n
mysql  -u  root  -p<\/DIV>
\uc704\uc5d0\uc11c \uc0ac\uc6a9\uc790 ID\ub85c \uc8fc\uc5b4\uc9c4 “root”\ub294 MySQL \uc5d0\uc11c \uad00\ub9ac\uc790 \uc544\uc774\ub514\ub97c \uc758\ubbf8\ud55c\ub2e4. \uadf8\ub9ac\uace0 “-p”\uc635\uc158\uc774 \uc788\uc73c\ubbc0\ub85c \ube44\ubc00\ubc88\ud638\ub97c \ud544\uc694\ub85c\ud55c\ub2e4. \ube44\ubc00\ubc88\ud638\ub294 MySQL Server \uc124\uce58\uc2dc \uc124\uc815\ud55c \uad00\ub9ac\uc790 \ube44\ubc00\ubc88\ud638\ub97c \uc785\ub825\ud558\uba74 \ub41c\ub2e4. \uc811\uc18d\uc5d0 \uc131\uacf5\ud558\uc600\ub2e4\uba74 \ub2e4\uc74c \uadf8\ub9bc\uacfc \uac19\uc740 \ud654\uba74\uc774 \ucd9c\ub825\ub41c\ub2e4.

\"\uc0ac\uc6a9\uc790
\uc704 \ud654\uba74\uc5d0\uc11c \uba54\uc138\uc9c0\uc640 \ud568\uaed8 \ud504\ub86c\ud504\ud2b8 “mysql>”\uc774 \ucd9c\ub825\ub418\ub294\ub370 \uc774 \uac83\uc740 \ud074\ub77c\uc774\uc5b8\ud2b8\uac00 \uc0c8\ub85c\uc6b4 \uba85\ub839\uc744 \uae30\ub2e4\ub9ac\uace0 \uc788\uc74c\uc744 \uc758\ubbf8\ud55c\ub2e4. \uadf8\ub7ec\uba74 \ub2e4\uc74c \uba85\ub839\uc744 \uc785\ub825\ud574 \ubcf4\uc790.


\n
show databases;<\/DIV>
\"\uc0ac\uc6a9\uc790
\uc774 \uba85\ub839\uc740 \ud604\uc7ac \uc11c\ubc84\uac00 \uad00\ub9ac\ud558\uace0 \uc788\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \ubaa9\ub85d\uc744 \ub098\uc5f4\ud574 \uc900\ub2e4. \ucd9c\ub825 \uacb0\uacfc\ub294 \ud604\uc7ac \uc11c\ubc84\uac00 \ucd1d \uc138 \uac1c\uc758 \ub370\uc774\ud130\ubca0\uc774\uc2a4 “information_schema”, “mysql”, “test”\ub97c \uad00\ub9ac\ud558\uace0 \uc788\uc74c\uc744 \ubcf4\uc5ec\uc900\ub2e4. \uc5ec\uae30\uc11c “mysql”\uc774\ub780 \uc774\ub984\uc758 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub294 \uc0ac\uc6a9\uc790, \uc811\uadfc\uad8c\ud55c \ub4f1\uacfc \uac19\uc774 \uc11c\ubc84\uc5d0 \uc758\ud574 \ud2b9\ubcc4\ud558\uac8c \uad00\ub9ac\ub418\ub294 \uc815\ubcf4\ub97c \uc704\ud55c \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub2e4.

\ud604 \uc2dc\uc810\uc5d0\uc11c\ub294 \uc138 \uac1c\uc758 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc911 \uc5b4\ub290 \uac83\ub3c4 \uc0ac\uc6a9\ud560 \uc218 \uc5c6\ub294 \uc0c1\ud0dc\ub2e4. \uadf8\ub7ec\ubbc0\ub85c \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc911 \uc0ac\uc6a9\ud558\uace0\uc790 \ud558\ub294 \ud558\ub098\uc758 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uc120\ud0dd\ud574\uc57c \ud55c\ub2e4. \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc120\ud0dd\uc744 \uc704\ud55c \uba85\ub839\uc740 \ub2e4\uc74c\uacfc \uac19\ub2e4.


\n
use   \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc774\ub984<\/SPAN> ;<\/DIV>

\uadf8\ub7ec\uba74 \ub2e4\uc74c \uba85\ub839\uc744 \uc774\uc6a9 \uc11c\ubc84\uacfc \ud2b9\ubcc4\ud558\uac8c \uad00\ub9ac\ud558\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc778 “mysql”\ub97c \uc120\ud0dd\ud574 \ubcf4\uc790.


\n
use  mysql ;<\/DIV>
\"\uc0ac\uc6a9\uc790
“Database changed”\ub780 \uba54\uc138\uc9c0\uac00 \ucd9c\ub825\ub418\uba74 “use mysql;” \uba85\ub839\uc774 \uc62c\ubc14\ub974\uac8c \ucc98\ub9ac\ub41c \uac83\uc774\ub2e4. \uac01 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub294 \uc5ec\ub7ec\uac1c\uc758 \ud14c\uc774\ube14\uc744 \uad00\ub9ac\ud55c\ub2e4. \ub530\ub77c\uc11c \uc784\uc758\uc758 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uac00 \uad00\ub9ac\ud558\ub294 \ud14c\uc774\ube14\uc744 \ud655\uc778\ud558\ub824\uba74 \ub2e4\uc74c \uba85\ub839\uc73c\ub85c \ud655\uc778\ud560 \uc218 \uc788\ub2e4.


\n
show tables ;<\/DIV>
\"\uc0ac\uc6a9\uc790
\uc774 \uba85\ub839\uc740 \ud604\uc7ac \uc0ac\uc6a9 \uc911\uc778 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uac00 \uad00\ub9ac\ud558\ub294 \ud14c\uc774\ube14 \ubaa9\ub85d\uc744 \ucd9c\ub825\ud55c\ub2e4. \uadf8\ub7ec\ubbc0\ub85c “show tables;” \uba85\ub839\uc758 \uacb0\uacfc \ud654\uba74\uc740 “use mysql;”\uba85\ub839\uc5d0 \uc758\ud574 \ud604\uc7ac \uc0ac\uc6a9 \uc911\uc778 \ub370\uc774\ud130\ubca0\uc774\uc2a4 “mysql”\uc774 \uad00\ub9ac\ud558\ub294 \ud14c\uc774\ube14\uc758 \ubaa9\ub85d\uc73c\ub85c “columns_priv” \ubd80\ud130 “user”\uae4c\uc9c0 \ucd1d 17 \uac1c\uc758 \ud14c\uc774\ube14\ub4e4\uc744 \uad00\ub9ac\ud558\uace0 \uc788\uc74c\uc744 \uc54c \uc218 \uc788\ub2e4.

\ub370\uc774\ud130\ubca0\uc774\uc2a4 \ud14c\uc774\ube14\uc740 \ud544\ub4dc\uc640 \ub808\ucf54\ub4dc\ub4e4\ub85c \uad6c\uc131\ub418\uc5b4 \uc788\ub2e4. \ub530\uc11c\uc11c \ud14c\uc774\ube14 \ud544\ub4dc\uc758 \uad6c\uc870\ub97c \ud655\uc778\ud558\uae30 \uc704\ud55c \uba85\ub839\uc740 \ub2e4\uc74c\uacfc \uac19\ub2e4.


\n
desc \ud14c\uc774\ube14\uba85<\/SPAN> ;<\/DIV>

\ub9cc\uc57d “mysql”\uc774 \uad00\ub9ac\ud558\uace0 \uc788\ub294 \ud14c\uc774\ube14 \uc911 “host” \ud14c\uc774\ube14\uc758 \ud544\ub4dc \uad6c\uc870\ub97c \ud655\uc778\ud558\uace0 \uc2f6\uc73c\uba74 \ub2e4\uc74c \uba85\ub839\uc744 \uc785\ub825\ud55c\ub2e4.


\n
desc  host ;<\/DIV>
\"\uc0ac\uc6a9\uc790
\uc704 \ud654\uba74\uc740 “host” \ud14c\uc774\ube14\uc758 \uad6c\uc870\ub97c \ubcf4\uc5ec\uc8fc\uace0 \uc788\ub2e4. \uc774 \uacb0\uacfc\ub97c \ud1b5\ud574 “host” \ud14c\uc774\ube14\uc740 19 \uac1c\uc758 \ud544\ub4dc\ub85c \uad6c\uc131\ub418\uc5b4 \uc788\uc74c\uc744 \ud655\uc778\ud560 \uc218 \uc788\uc73c\uba70, \uac01 \ud544\uc758\uc758 \ud0c0\uc785\uacfc \uc18d\uc131 \ub4f1\ub3c4 \ud568\uaed8 \ud655\uc778\ud560 \uc218 \uc788\ub2e4. \uc608\ub97c \ub4e4\uba74 “Host” \ud544\ub4dc\uc758 \uacbd\uc6b0 \ud0c0\uc785\uc740 char(60)\uc774\uace0, null \uac12\uc744 \ud5c8\uc6a9\ud558\uc9c0 \uc54a\uc73c\uba70, \uc8fc\ud0a4(Primary Key)\ub85c \uc124\uc815\ub3fc \uc788\ub2e4. \ub610 \ud558\ub098\uc758 \ud544\ub4dc “Index_priv”\uc758 \uacbd\uc6b0 \ud0c0\uc785 emun(‘N’,’Y’)\uc5d0 \uc758\ud574 \uac00\uc9c8 \uc218 \uc788\ub294 \uac12\uc740 \ubb38\uc790 ‘N’ \ub610\ub294 ‘Y’\uc774\uba70, null \uac12\uc744 \uac00\uc9c8 \uc218 \uc5c6\uace0, null \uac12\uc774 \uc8fc\uc5b4\uc9c0\uba74 \uae30\ubcf8\uac12 ‘N’\uc744 \uac16\uac8c\ub41c\ub2e4.

\ub370\uc774\ud130\ubca0\uc774\uc2a4 “mysql”\uc774 \uad00\ub9ac\ud558\ub294 \ud14c\uc774\ube14 \uc911 “user”\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc0ac\uc6a9\uc790 \uc815\ubcf4\ub97c \uc800\uc7a5 \uad00\ub9ac\ud558\ub294 \ud14c\uc774\ube14\uc774\ub2e4. \uc774 \ud14c\uc774\ube14\uc740 \uc0ac\uc6a9\uc790\uc544\uc774\ub514\uc640 \ube44\ubc00\ubc88\ud638 \ubc0f MySQL Server\uac00 \uad00\ub9ac\ud558\ub294 \ubaa8\ub4e0 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \ub300\ud55c \uc0ac\uc6a9\uc790\uc758 \uc811\uadfc\uad8c\ud55c \ub4f1\uc758 \uc815\ubcf4\ub97c \uac00\uc9c0\uace0 \uc788\ub2e4. \uc774 \ud14c\uc774\ube14\uc758 \ub0b4\uc6a9\uc744 \ubcf4\uae30 \uc704\ud574\uc11c\ub294 SQL \uc911 \uac80\uc0c9\uc744 \uc704\ud55c “SELECT” \ubb38\uc744 \uc774\uc6a9\ud574 \ud655\uc778\ud560 \uc218 \uc788\ub2e4. \ub2e4\uc74c \uba85\ub839\uc744 \uc785\ub825\ud574 \ubcf4\uc790.


\n
SELECT host, user from user ;<\/DIV>
\"\uc0ac\uc6a9\uc790
\uc704 \uba85\ub839\uc740 \ud14c\uc774\ube14 “user”\uc5d0 \uc800\uc7a5\ub41c \uc0ac\uc6a9\uc790 \uc815\ubcf4 \uc911 “host”, “user” \ud544\ub4dc\uc758 \ub0b4\uc6a9\uc744 \ubcf4\uc5ec\uc8fc\uace0 \uc788\ub2e4. \uc124\uce58 \uc635\uc158\uc5d0 \ub530\ub77c \ub2e4\ub974\uaca0\uc9c0\ub9cc \uc704 \uacb0\uacfc\ub97c \uc0b4\ud3b4\ubcf4\uba74 “user” \ud14c\uc774\ube14\uc740 \uc138 \uac1c\uc758 \ub808\ucf54\ub4dc\ub97c \uac00\uc9d0\uc744 \uc54c \uc218 \uc788\ub2e4. \uadf8\ub9ac\uace0 “user” \ud544\ub4dc\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc0ac\uc6a9\uc790 \uc544\uc774\ub514\ub97c \uc800\uc7a5\ud558\ub294 \ud544\ub4dc\ub85c “root”\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uad00\ub9ac\uc790\ub97c \uc758\ubbf8\ud55c\ub2e4. “host” \ud544\ub4dc\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc11c\ubc84\ub85c \uc811\uc18d\ud560 \uc218 \uc788\ub294 \ucef4\ud4e8\ud130\ub97c \uc9c0\uc815\ud558\ub294\ub370, \uc774 \uac12\uc774 “%”\uc774\uba74 \uc778\ud130\ub137\uc0c1\uc758 \ubaa8\ub4e0 \ucef4\ud4e8\ud130\ub97c \uc758\ubbf8\ud558\uba70, “localhost”\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc11c\ubc84 \uc790\uc2e0\uc744 \uc758\ubbf8\ud55c\ub2e4. \uadf8\ub7ec\ubbc0\ub85c “root” \uc989 \uad00\ub9ac\uc790\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc11c\ubc84\uc5d0 \uc811\uc18d\ud560 \ub54c \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc11c\ubc84\uac00 \uc2e4\ud589 \uc911\uc778 \ucef4\ud4e8\ud130\uc5d0\uc11c\ub9cc \uc811\uc18d\uc774 \uac00\ub2a5\ud558\uace0 \uc778\ud130\ub137 \uc0c1\uc758 \ub2e4\ub978 \ucef4\ud4e8\ud130\uc5d0\uc11c\ub294 \uc811\uc18d\uc774 \ubd88\uac00\ub2a5 \ud558\ub2e4. \uc774 \uc678\uc5d0\ub3c4 \uae30\ud0c0 \uad8c\ud55c\uc740 “user” \ud14c\uc774\ube14\uc758 \ub2e4\ub978 \ud544\ub4dc\uac12\uc5d0 \uc758\ud574 \uacb0\uc815\ub41c\ub2e4.

\ub610 \ub2e4\ub978 \ud14c\uc774\ube14 “db”\uc758 \ub0b4\uc6a9\uc744 \ud655\uc778\ud558\uae30 \uc704\ud574 \ub2e4\uc74c SQL \ubb38\uc744 \uc2e4\ud589\ud558\uc790.


\n
SELECT host, user, db from db ;<\/DIV>
\"\uc0ac\uc6a9\uc790
“db” \ud14c\uc774\ube14\uc740 \ud2b9\uc815 \uc0ac\uc6a9\uc790\uc640 \ud2b9\uc815 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc0ac\uc774\uc758 \uc811\uadfc\uad8c\ud55c \ub4f1\uc758 \uad00\uacc4 \uc815\ubcf4\ub97c \uc800\uc7a5\ud558\ub294 \ud14c\uc774\ube14\uc774\ub2e4. \uc704 \uacb0\uacfc\ub97c \uc0b4\ud3b4\ubcf4\uba74 \uc775\uba85\uc758 \uc0ac\uc6a9\uc790\uc640 “test”\ub780 \uc774\ub984\uc758 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ub610\ub294 “test_”\ub85c \uc2dc\uc791\ub418\ub294 \ubaa8\ub4e0 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc0ac\uc774\uc758 \uad00\uacc4\ub41c \uc815\uc758\ub97c \ud558\uace0 \uc788\ub2e4. \ub458 \uc0ac\uc774\uc758 \uc815\ud655\ud55c \uad00\uacc4\ub294 “db” \ud14c\uc774\ube14\uc758 \ub2e4\ub978 \ud544\ub4dc\uc5d0 \uc815\uc758\ub418\uc5b4 \uc788\uc9c0\ub9cc \uc5ec\uae30\uc11c\ub294 \uc0dd\ub7b5\ud558\ub3c4\ub85d \ud55c\ub2e4.

\uc790 \uadf8\ub7ec\uba74 \uc2e4\uc2b5\uc744 \uc704\ud574 \uc0c8\ub85c\uc6b4 \ub370\uc774\ud130\ubca0\uc774\uc2a4 “jsp”\ub97c \ub9cc\ub4e4\uc5b4\ubcf4\uc790. \uc0c8\ub85c\uc6b4 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \ub9cc\ub4e4\uae30 \uc704\ud55c SQL \ubb38\uc740


\n
CREATE DATABASE  database-name ;<\/DIV>
\uc774\ubbc0\ub85c database-name \ubd80\ubd84\uc744 jsp\ub85c \ubc14\uafb8\uba74 \ub370\uc774\ud130\ubca0\uc774\uc2a4 “jsp”\ub97c \ub9cc\ub4e4 \uc218 \uc788\ub2e4.


\n
CREATE  DATABASE  jsp ;
<\/DIV>
\"\uc0ac\uc6a9\uc790
“Query OK, 1 row affected (0.00 sec)” \uba54\uc138\uc9c0\uac00 \ub098\uc624\uba74 \ub370\uc774\ud130\ubca0\uc774\uc2a4 “jsp”\uac00 \ub9cc\ub4e4\uc5b4\uc9c4 \uac83\uc774\ub2e4. \ud655\uc778\uc744 \uc704\ud574 \uc55e\uc5d0\uc11c \ubc30\uc6e0\ub358 “show databases ;”\ub97c \uc785\ub825\ud574 \ubcf4\uc790.

\"\uc0ac\uc6a9\uc790
\uacb0\uacfc\ub97c \ud655\uc778\ud574 \ubcf4\uba74 \ub370\uc774\ud130\ubca0\uc774\uc2a4 “jsp”\uac00 \ucd94\uac00\ub418\uc5c8\uc74c\uc744 \uc54c \uc218 \uc788\ub2e4. \uc2e4\uc2b5\uc744 \uc704\ud55c \ub370\uc774\ud130\ubca0\uc774\uc2a4 “jsp”\ub97c \ucd94\uac00\ud588\uc73c\uba74 \ub2e4\uc74c \ucffc\ub9ac\ub97c \uc774\uc6a9\ud558\uc5ec \uc2e4\uc2b5\uc744 \uc704\ud55c \uc0c8\ub85c\uc6b4 \uc0ac\uc6a9\uc790\ub97c \ucd94\uac00\ud574 \ubcf4\uc790. \uc5ec\uae30\uc11c \uae30\uc6b8\uc784\uccb4\ub85c \ub41c your_password<\/SPAN> \ubd80\ubd84\uc740 \uc790\uc2e0\uc774 \uc6d0\ud558\ub294 \ube44\ubc00\ubc88\ud638\ub85c \ub300\uce58\ud55c\ub2e4.


\n
GRANT SELECT, UPDATE, INSERT, DELETE, CREATE, DROP, ALTER
ON jsp.* TO ‘jsp’@’localhost’
IDENTIFIED BY ‘your_password<\/SPAN>‘ ;<\/DIV>
\"\uc0ac\uc6a9\uc790
\uc704 \ucffc\ub9ac\ub294 “localhost”\uc5d0\uc11c \uc811\uadfc \uac00\ub2a5\ud55c \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc0ac\uc6a9\uc790 “jsp”\ub97c \ub4f1\ub85d\ud558\uc600\ub2e4. \uc774 \uc0ac\uc6a9\uc790 “jsp”\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc11c\ubc84\uc5d0 \uc811\uc18d\ud560 \ub54c “your_password<\/SPAN>“\ub97c \uc0ac\uc6a9\ud574 \uc811\uc18d\ud574\uc57c \ud558\uba70, \uc811\uc18d \ud6c4 \ub370\uc774\ud130\ubca0\uc774\uc2a4 “jsp”\uc5d0 \ub300\ud55c \uc811\uadfc\uad8c\ud55c\uacfc \uc5f0\uad00\ub41c \uad00\uacc4\ub97c \uc815\uc758\ud558\uace0 \uc788\ub2e4. \uc774 \ucffc\ub9ac\uc5d0\uc11c \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc0ac\uc6a9\uc790 “jsp”\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4 “jsp”\uc5d0 \ub300\ud574 “SELECT”, “UPDATE”, “INSERT”, “DELETE”, “CREATE”, “DROP”, “ALTER” \ub4f1\uc758 \ucffc\ub9ac\ub97c \uc2e4\ud589\ud560 \uc218 \uc788\ub3c4\ub85d \uad8c\ud55c\uc774 \uc124\uc815\ub418\uc5c8\ub2e4.

\uadf8\ub7ec\uba74 \uc62c\ubc14\ub974\uac8c \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc0ac\uc6a9\uc790\uac00 \ucd94\uac00 \ub418\uc5c8\ub294\uc9c0 “user” \ud14c\uc774\ube14\uc744 \uc0b4\ud3b4\ubcf4\uc790.


\n
SELECT host, user FROM user ;<\/DIV>
\"\uc0ac\uc6a9\uc790
\uacb0\uacfc\ub97c \uc0b4\ud3b4\ubcf4\uba74 “LOCALHOST”\uc5d0\uc11c \uc811\uc18d \uac00\ub2a5\ud55c \uc0ac\uc6a9\uc790 “jsp”\uac00 \ub4f1\ub85d\ub418\uc5c8\uc74c\uc744 \ud655\uc778\ud560 \uc218 \uc788\ub2e4. \ub610\ud55c \uc0ac\uc6a9\uc790\uc640 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc640\uc758 \uad00\uacc4\ub97c \uc815\uc758\ud558\uace0 \uc788\ub294 “db” \ud14c\uc774\ube14\uc744 \uc0b4\ud3b4\ubcf4\uc790.


\n
SELECT host, user, db FROM db ;<\/DIV>
\"\uc0ac\uc6a9\uc790
\uacb0\uacfc\ub97c \uc0b4\ud3b4\ubcf4\uba74 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc0ac\uc6a9\uc790 “jsp”\uac00 “localhost”\uc5d0\uc11c \uc811\uc18d\ud588\uc744 \ub54c \ub370\uc774\ud130\ubca0\uc774\uc2a4 “jsp”\uc5d0 \ub300\ud55c \uad00\uacc4\ub97c \uc815\uc758\ud558\uace0 \uc788\ub2e4. \uacb0\uacfc\uc5d0\uc11c\ub294 \uad00\uacc4\ub97c \uc54c \uc218 \uc5c6\uc9c0\ub9cc \uc774 \uad00\uacc4\ub294 “db” \ud14c\uc774\ube14\uc758 \ub2e4\ub978 \ud544\ub4dc\uc5d0 \uc815\uc758\ub418\uc5b4 \uc788\uc73c\ubbc0\ub85c


\n
SELECT * FROM db ;<\/DIV>

\ucffc\ub9ac\ub97c \ud1b5\ud574 \ud655\uc778\ud560 \uc218 \uc788\ub2e4. \uad00\uacc4\ub97c \ud655\uc778\ud588\uc73c\uba74


\n
exit ;<\/DIV>

\uba85\ub839\uc744 \ud1b5\ud574 MySQL Client \ud504\ub85c\uadf8\ub7a8\uc744 \uc885\ub8cc\ud558\uc790.

\"\uc0ac\uc6a9\uc790
\uc774\uc81c \uc0c8\ub86d\uac8c \ub4f1\ub85d\ud55c \uc0ac\uc6a9\uc790\ub85c “\uba85\ub839 \ud504\ub86c\ud504\ud2b8” \uc0c1\uc5d0\uc11c \ub2e4\uc74c \uba85\ub839\uc744 \uc774\uc6a9 \uc7ac \uc811\uc18d\uc744 \uc2dc\ub3c4\ud574 \ubcf4\uc790.


\n
mysql  -u  jsp  -p<\/DIV>
\uc774 \ub54c \ube44\ubc00\ubc88\ud638\ub294 “GRANT”\ub97c \uc774\uc6a9 \uc0ac\uc6a9\uc790 “jsp”\ub97c \ub4f1\ub85d\ud560 \ub54c \uc8fc\uc5b4\uc9c4 \ube44\ubc00\ubc88\ud638\ub97c \uc785\ub825\ud55c\ub2e4.

\"\uc0ac\uc6a9\uc790
\uc811\uc18d\uc5d0 \uc131\uacf5\ud558\uba74 \ub2e4\uc74c \uba85\ub839\uc744 \uc21c\uc11c\ub300\ub85c \uc785\ub825\ud558\uc5ec \uadf8 \uacb0\uacfc\ub97c \ud655\uc778\ud574 \ubcf4\uc790.


\n
show  databases ;
use  jsp
show tables ;<\/DIV>
\"\uc0ac\uc6a9\uc790
MySQL\uacfc \uad00\ub828\ub41c \ub354 \uc790\uc138\ud55c \ub0b4\uc6a9\uc744 \uacf5\ubd80\ud558\uace0 \uc2f6\ub2e4\uba74 \ub2e4\ub978 \ucc38\uace0\uc11c\uc801\uc744 \ucc3e\uc544\ubcf4\ub3c4\ub85d \ud558\uc790.
<\/p>\n","protected":false},"excerpt":{"rendered":"

MySQL Server\uc758 \uc124\uce58\uac00 \uc644\ub8cc\ub410\uc73c\uba74 \uc774\uc81c MySQL \uc0ac\uc6a9\ubc95\uc744 \uc775\ud600\ubcf4\uae30 \uc704\ud574 Windows “\uba85\ub839 \ud504\ub86c\ud504\ud2b8”\ub97c \uc2e4\ud589\ud558\uc790. “\uba85\ub839 \ud504\ub86c\ud504\ud2b8”\ub294 XP\uc758 \uacbd\uc6b0 “\uc2dc\uc791 -> \ubaa8\ub4e0\ud504\ub85c\uadf8\ub7a8 -> \ubcf4\uc870\ud504\ub85c\uadf8\ub7a8 -> \uba85\ub82c \ud504\ub86c\ud504\ud2b8”\ub97c \ud1b5\ud574 \uc2e4\ud589\ud558\uac70\ub098 \ub610\ub294 “\uc2dc\uc791 -> \uc2e4\ud589” \ucc3d\uc5d0\uc11c “cmd”\ub97c \uc785\ub825\ud558\uba74 \uc2e4\ud589\ud560 \uc218 \uc788\ub2e4. \uc6b0\ub9ac\uac00 \uc124\uce58\ud55c MySQL Server\ub294 OS(Windows \ub610\ub294 UNIX)\uac00 \ubd80\ud305\ub420 \ub54c \uc790\ub3d9\uc73c\ub85c \uc2dc\uc791\ub418\ub294 \ubc94\uc6a9 DBMS\uc774\uba70, \uc11c\ubc84\uc640 \ud074\ub77c\uc774\uc5b8\ud2b8 \uad6c\uc870\ub85c \ub098\ub25c\ub2e4. \uc11c\ubc84\ub294\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":3,"featured_media":2821,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false},"categories":[243],"tags":[34],"class_list":["post-2820","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mysql","tag-mysql"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/www.happyfam.or.kr\/ysoh\/wp-content\/uploads\/sites\/3\/1\/cfile5.uf.110BCF0E4A9A0E93023DC0.png?fit=508%2C381&ssl=1","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p776QY-Ju","jetpack-related-posts":[],"_links":{"self":[{"href":"https:\/\/www.happyfam.or.kr\/ysoh\/wp-json\/wp\/v2\/posts\/2820","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.happyfam.or.kr\/ysoh\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.happyfam.or.kr\/ysoh\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.happyfam.or.kr\/ysoh\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.happyfam.or.kr\/ysoh\/wp-json\/wp\/v2\/comments?post=2820"}],"version-history":[{"count":0,"href":"https:\/\/www.happyfam.or.kr\/ysoh\/wp-json\/wp\/v2\/posts\/2820\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.happyfam.or.kr\/ysoh\/wp-json\/wp\/v2\/media\/2821"}],"wp:attachment":[{"href":"https:\/\/www.happyfam.or.kr\/ysoh\/wp-json\/wp\/v2\/media?parent=2820"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.happyfam.or.kr\/ysoh\/wp-json\/wp\/v2\/categories?post=2820"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.happyfam.or.kr\/ysoh\/wp-json\/wp\/v2\/tags?post=2820"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}