{"id":333,"date":"2017-05-16T10:18:00","date_gmt":"2017-05-16T01:18:00","guid":{"rendered":"https:\/\/trret.com\/?p=333"},"modified":"2024-10-09T11:20:24","modified_gmt":"2024-10-09T02:20:24","slug":"mysql-grant-%ea%b6%8c%ed%95%9c%eb%b6%80%ec%97%ac%ec%a0%9c%ea%b1%b0%ec%a0%81%ec%9a%a9%ed%95%98%ea%b8%b0","status":"publish","type":"post","link":"https:\/\/trret.com\/?p=333","title":{"rendered":"[MySQL] grant \uad8c\ud55c\ubd80\uc5ec,\uc81c\uac70,\uc801\uc6a9\ud558\uae30"},"content":{"rendered":"\n

\/\/\uc720\uc800\uc0dd\uc131\uacfc \ud568\uaed8 \ud55c \uc811\uc18d\uc9c0 \uc8fc\uc18c\uc5d0\uc11c \ud55c \ud14c\uc774\ube14\uc5d0 \uad8c\ud55c\ubd80\uc5ec
grant all privileges on \ub514\ube44\uba85.\ud14c\uc774\ube14\uba85 to \uc720\uc800\uba85@’\uc811\uc18d\uc9c0 \uc8fc\uc18c’ identified by ‘\uc554\ud638’;<\/p>\n\n\n\n

\/\/\uc720\uc800\uc0dd\uc131\uacfc \ud568\uaed8 \uc678\ubd80\uc5d0\uc11c \ud55c DB\uc5d0 \uad8c\ud55c\ubd80\uc5ec
grant all privileges on \ub514\ube44\uba85.* to \uc720\uc800\uba85@’%’ identified by ‘\uc554\ud638’; \/\/%\ub294 \uc678\ubd80\uc811\uadfc<\/p>\n\n\n\n

\/\/\uc720\uc800\uc0dd\uc131\uacfc \ud568\uaed8 \ub0b4\ubd80\uc5d0\uc11c \ubaa8\ub4e0 DB\uc5d0 \uad8c\ud55c\ubd80\uc5ec
grant all privileges on *.* to \uc720\uc800\uba85@’localhost’ identified by ‘\uc554\ud638’; \/\/localhost\ub294 \ub0b4\ubd80\uc811\uadfc<\/p>\n\n\n\n

\/\/\ud55c \uc0ac\uc6a9\uc790\uc758 DB \ubaa8\ub4e0 \uad8c\ud55c \uc81c\uac70
revoke all on \ub514\ube44\uba85.* from \uc0ac\uc6a9\uc790;<\/p>\n\n\n\n

\/\/\ud55c \uc544\uc774\ud53c\uc5d0\uc11c \uc0ac\uc6a9\uc790\uc758 \ud14c\uc774\ube14 \uad8c\ud55c \uc81c\uac70
revoke all privileges on \ub514\ube44\uba85.\ud14c\uc774\ube14\uba85 from \uc0ac\uc6a9\uc790@\uc544\uc774\ud53c;<\/p>\n\n\n\n

\/\/\uad8c\ud55c \uc801\uc6a9
\ubaa8\ub4e0 \uba85\ub839 \ud6c4\uc5d0 \ud56d\uc0c1 \uc544\ub798 \uba85\ub839\uc744 \uc2e4\ud589\ud574\uc57c \uc2e4\uc81c\ub85c \uc801\uc6a9\ub41c\ub2e4.
flush privileges;<\/p>\n\n\n\n

\n\n\n\n

<\uc0d8\ud50c><\/p>\n\n\n\n

\/\/ ‘\uc0ac\uc6a9\uc790’\uac00 ‘\uc554\ud638’\uc73c\ub85c 111.222.333.xxx \uc5d0\uc11c \ubaa8\ub4e0 \ub514\ube44\uc640 \ud14c\uc774\ube14\uc5d0 \uc811\uc18d\ud558\ub3c4\ub85d \ud5c8\uc6a9
grant all privileges on .<\/em> to \uc0ac\uc6a9\uc790 @’111.222.333.%’ identified by ‘\uc554\ud638’;<\/p>\n\n\n\n

\/\/ ‘\uc0ac\uc6a9\uc790’\uac00 ‘\uc554\ud638’\uc73c\ub85c 111.222.333.444 \uc5d0\uc11c db1 \ub514\ube44\uc758 \ubaa8\ub4e0 \ud14c\uc774\ube14\uc5d0 \uc811\uc18d\ud558\ub3c4\ub85d \ud5c8\uc6a9
grant all privileges on db1.* to \uc0ac\uc6a9\uc790@’111.222.333.444′ identified by ‘\uc554\ud638’;<\/p>\n\n\n\n

\/\/ ‘\uc0ac\uc6a9\uc790’\uac00 ‘\uc554\ud638’\uc73c\ub85c localhost \uc5d0\uc11c db1 \ub514\ube44\uc758 table1\uc5d0 \uc811\uc18d\ud558\ub3c4\ub85d \ud5c8\uc6a9
grant all privileges on db1.table1 to \uc0ac\uc6a9\uc790@’localhost’ identified by ‘\uc554\ud638’;<\/p>\n","protected":false},"excerpt":{"rendered":"

\/\/\uc720\uc800\uc0dd\uc131\uacfc \ud568\uaed8 \ud55c \uc811\uc18d\uc9c0 \uc8fc\uc18c\uc5d0\uc11c \ud55c \ud14c\uc774\ube14\uc5d0 \uad8c\ud55c\ubd80\uc5ecgrant all privileges on \ub514\ube44\uba85.\ud14c\uc774\ube14\uba85 to \uc720\uc800\uba85@’\uc811\uc18d\uc9c0 \uc8fc\uc18c’ identified by ‘\uc554\ud638’; \/\/\uc720\uc800\uc0dd\uc131\uacfc \ud568\uaed8 \uc678\ubd80\uc5d0\uc11c \ud55c DB\uc5d0 \uad8c\ud55c\ubd80\uc5ecgrant all privileges on \ub514\ube44\uba85.* to \uc720\uc800\uba85@’%’ identified by ‘\uc554\ud638’; \/\/%\ub294 \uc678\ubd80\uc811\uadfc \/\/\uc720\uc800\uc0dd\uc131\uacfc \ud568\uaed8 \ub0b4\ubd80\uc5d0\uc11c \ubaa8\ub4e0 DB\uc5d0 \uad8c\ud55c\ubd80\uc5ecgrant all privileges on *.* to \uc720\uc800\uba85@’localhost’ identified by ‘\uc554\ud638’; \ub354 \uc77d\uae30<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[26,25],"tags":[],"_links":{"self":[{"href":"https:\/\/trret.com\/index.php?rest_route=\/wp\/v2\/posts\/333"}],"collection":[{"href":"https:\/\/trret.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/trret.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/trret.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/trret.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=333"}],"version-history":[{"count":6,"href":"https:\/\/trret.com\/index.php?rest_route=\/wp\/v2\/posts\/333\/revisions"}],"predecessor-version":[{"id":356,"href":"https:\/\/trret.com\/index.php?rest_route=\/wp\/v2\/posts\/333\/revisions\/356"}],"wp:attachment":[{"href":"https:\/\/trret.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=333"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/trret.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=333"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/trret.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=333"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}