{"id":63,"date":"2016-10-26T12:00:14","date_gmt":"2016-10-26T03:00:14","guid":{"rendered":"http:\/\/jook.pe.kr\/?p=63"},"modified":"2016-10-26T12:00:14","modified_gmt":"2016-10-26T03:00:14","slug":"mysql-%ec%82%ac%ec%9a%a9%ec%9e%90-%ec%b6%94%ea%b0%80%eb%b0%a9%eb%b2%95-%eb%b0%8f-%ec%b6%94%ea%b0%80-%ec%8a%a4%ed%81%ac%eb%a6%bd%ed%8a%b8","status":"publish","type":"post","link":"http:\/\/jook.pe.kr\/?p=63","title":{"rendered":"mysql \uc0ac\uc6a9\uc790 \ucd94\uac00\ubc29\ubc95 \ubc0f \ucd94\uac00 \uc2a4\ud06c\ub9bd\ud2b8"},"content":{"rendered":"

1. mysql Database\uc5d0 root \uad8c\ud55c\uc73c\ub85c \uc811\uc18d \ud55c\ub2e4.<\/p>\n

[root@localhost root]# \/usr\/local\/mysql\/bin\/mysql -u root -p<\/p>\n

2. db\ub97c \ucd94\uac00 \ud55c\ub2e4.<\/p>\n

mysql> create database db\uba85;<\/p>\n

3. mysql db\ub97c \uc120\ud0dd\ud55c\ub2e4.<\/p>\n

mysql> use mysql;<\/p>\n

4. mysql db\uc758 user\ud14c\uc774\ube14\uc5d0 \uc0ac\uc6a9\ud560\uacc4\uc815\uacfc \ud328\uc2a4\uc6cc\ub4dc\ub97c \uc785\ub825\ud55c\ub2e4.<\/p>\n

mysql> insert into user (host,user,password) values(‘localhost’,’\uacc4\uc815’,password(‘\ud328\uc2a4\uc6cc\ub4dc’));<\/p>\n

5. mydql db\uc758 db\ud14c\uc774\ube14\uc758 \ud544\ub4dc\uc218 \ud655\uc778.<\/p>\n

mysql> desc db;
\n+—————–+—————–+——+—–+———+——-+
\n| Field\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0 | Type\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0| Null\u00a0\u00a0| Key | Defaul\u00a0\u00a0t | Extra\u00a0\u00a0|
\n+—————–+—————–+——+—–+———+——-+
\n| Host\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0| char(60) binary\u00a0\u00a0 |\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0| PRI\u00a0\u00a0|\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0 |
\n| Db\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0| char(64) binary\u00a0\u00a0 |\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | PRI\u00a0\u00a0|\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0 |
\n| User\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0| char(16) binary\u00a0\u00a0 |\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | PRI\u00a0\u00a0|\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0 |\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0 |
\n| Select_priv\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | enum(‘N’,’Y’)\u00a0\u00a0\u00a0\u00a0 |\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0|\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0| N\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0|\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0|
\n| Insert_priv\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | enum(‘N’,’Y’)\u00a0\u00a0\u00a0\u00a0 |\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0|\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0| N\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0|\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0|
\n| Update_priv\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | enum(‘N’,’Y’)\u00a0\u00a0\u00a0\u00a0 |\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0|\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0| N\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0|\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0|
\n| Delete_priv\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | enum(‘N’,’Y’)\u00a0\u00a0\u00a0\u00a0 |\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0|\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0| N\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0|\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0 |
\n| Create_priv\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0| enum(‘N’,’Y’)\u00a0\u00a0\u00a0\u00a0 |\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0|\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | N\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0|\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |
\n| Drop_priv\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0| enum(‘N’,’Y’)\u00a0\u00a0\u00a0\u00a0 |\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0|\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | N\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0|\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0|
\n| Grant_priv\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0| enum(‘N’,’Y’)\u00a0\u00a0\u00a0\u00a0 |\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0|\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0| N\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0|\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0|
\n| References_priv\u00a0\u00a0| enum(‘N’,’Y’)\u00a0\u00a0\u00a0\u00a0 |\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0|\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0| N\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0|\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0|
\n| Index_priv\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | enum(‘N’,’Y’)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0|\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0|\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0| N\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0|\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0 |
\n| Alter_priv\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0| enum(‘N’,’Y’)\u00a0\u00a0\u00a0\u00a0 |\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0|\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0| N\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0|\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0 |
\n+—————–+—————–+——+—–+———+——-+
\n13 rows in set (0.01 sec)<\/p>\n

6. mysql db\uc758 db \ud14c\uc774\ube14\uc5d0 \uc0ac\uc6a9\ud560 db\uc640 \uacc4\uc815\uc744 \uc5f0\uacb0\uc2dc\ud0a4\uace0 db\ud14c\uc774\ube14\uc758 \ud544\ub4dc \uc218\ub9cc\ud07c, \uc811\uadfc\uad8c\ud55c\uc744 \ubd80\uc5ec\ud55c\ub2e4.<\/p>\n

mysql> insert into db values(‘localhost’,’db\uba85’,’\uacc4\uc815’,’y’,’y’,’y’,’y’,’y’,’y’,’y’,’y’,’y’,’y’);<\/p>\n

7. \ucd94\uac00\ud55c \ub0b4\uc6a9\uc744 \uc801\uc6a9\uc2dc\ud0a8\ub2e4.<\/p>\n

mysql> flush privileges;<\/p>\n

8. shell \uc0c1\uc5d0\uc11c mysql \uc811\uc18d \ud14c\uc2a4\ud2b8.<\/p>\n

[root@localhost root]# \/usr\/local\/mysql\/bin\/mysql -u \uacc4\uc815 -p db\uba85<\/p>\n","protected":false},"excerpt":{"rendered":"

1. mysql Database\uc5d0 root \uad8c\ud55c\uc73c\ub85c \uc811\uc18d \ud55c\ub2e4. [root@localhost root]# \/usr\/local\/mysql\/bin\/mysql -u root -p 2. db\ub97c \ucd94\uac00 \ud55c\ub2e4. mysql> create database<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5,6],"tags":[],"_links":{"self":[{"href":"http:\/\/jook.pe.kr\/index.php?rest_route=\/wp\/v2\/posts\/63"}],"collection":[{"href":"http:\/\/jook.pe.kr\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/jook.pe.kr\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/jook.pe.kr\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/jook.pe.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=63"}],"version-history":[{"count":0,"href":"http:\/\/jook.pe.kr\/index.php?rest_route=\/wp\/v2\/posts\/63\/revisions"}],"wp:attachment":[{"href":"http:\/\/jook.pe.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=63"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/jook.pe.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=63"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/jook.pe.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=63"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}