{"id":243,"date":"2016-10-26T16:30:21","date_gmt":"2016-10-26T07:30:21","guid":{"rendered":"http:\/\/jook.pe.kr\/?p=243"},"modified":"2016-10-26T16:30:21","modified_gmt":"2016-10-26T07:30:21","slug":"grant-%eb%ac%b8%ec%9d%84-%ec%9d%b4%ec%9a%a9%ed%95%9c-mysql-%ea%b3%84%ec%a0%95-%ec%83%9d%ec%84%b1","status":"publish","type":"post","link":"http:\/\/jook.pe.kr\/?p=243","title":{"rendered":"grant \ubb38\uc744 \uc774\uc6a9\ud55c mysql \uacc4\uc815 \uc0dd\uc131"},"content":{"rendered":"<p>1. mysql Database\uc5d0 root \uad8c\ud55c\uc73c\ub85c \uc811\uc18d \ud55c\ub2e4.<br \/>\n[root@localhost root]# \/usr\/local\/mysql\/bin\/mysql -u root -p mysql<\/p>\n<p>&nbsp;<\/p>\n<p>2. grnat \ubb38\uc73c\ub85c DB\uad8c\ud55c, \uacc4\uc815, \ud328\uc2a4\uc6cc\ub4dc\ub97c \ud55c\ubc88\uc5d0 \uc124\uc815 \ud55c\ub2e4.<br \/>\nmysql&gt; grant all privileges on DB\uba85.* to <a href=\"http:\/\/jook.pe.kr\/xe\/mailto:%EA%B3%84%EC%A0%95@localhost\">\uacc4\uc815@localhost<\/a> identified by &#8216;\ud328\uc2a4\uc6cc\ub4dc&#8217; with grant option;<br \/>\nQuery OK, 0 rows affected (0.00 sec)<\/p>\n<p>&nbsp;<\/p>\n<p>3. select \ubb38\uc73c\ub85c user \ud14c\uc774\ube14\uc5d0 \ucd94\uac00\ub41c \uacc4\uc815 \ud655\uc778<br \/>\nmysql&gt; select * from user where user=&#8217;\uacc4\uc815&#8217;;<\/p>\n<p>4. select \ubb38\uc73c\ub85c db \ud14c\uc774\ube14\uc5d0 \ucd94\uac00\ub41c \uad8c\ud55c \ud655\uc778<br \/>\nmysql&gt; select * from db where db=&#8217;DB\uba85&#8217;;<\/p>\n<p>5. \ucd94\uac00\ub41c \ub0b4\uc6a9\uc744 \uc801\uc6a9<br \/>\nmysql&gt; flush privileges;<\/p>\n<p>&nbsp;<\/p>\n<p>6. mysql \uc811\uc18d \ud14c\uc2a4\ud2b8<br \/>\n[root@localhost root]# \/usr\/local\/mysql\/bin\/mysql -u \uacc4\uc815 -p DB\uba85<\/p>\n","protected":false},"excerpt":{"rendered":"<p>1. mysql Database\uc5d0 root \uad8c\ud55c\uc73c\ub85c \uc811\uc18d \ud55c\ub2e4. [root@localhost root]# \/usr\/local\/mysql\/bin\/mysql -u root -p mysql &nbsp; 2. grnat \ubb38\uc73c\ub85c DB\uad8c\ud55c, \uacc4\uc815,<\/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\/243"}],"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=243"}],"version-history":[{"count":0,"href":"http:\/\/jook.pe.kr\/index.php?rest_route=\/wp\/v2\/posts\/243\/revisions"}],"wp:attachment":[{"href":"http:\/\/jook.pe.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=243"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/jook.pe.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=243"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/jook.pe.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=243"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}