{"id":243,"date":"2020-06-13T22:28:37","date_gmt":"2020-06-13T13:28:37","guid":{"rendered":"https:\/\/tech.softbell.net\/?p=243"},"modified":"2020-06-13T22:28:37","modified_gmt":"2020-06-13T13:28:37","slug":"mysql-%ec%82%ac%ec%9a%a9%ec%9e%90-%ec%b6%94%ea%b0%80-%eb%b0%8f-%ea%b6%8c%ed%95%9c-%ec%84%a4%ec%a0%95","status":"publish","type":"post","link":"https:\/\/tech.softbell.net\/?p=243","title":{"rendered":"MySQL \uc0ac\uc6a9\uc790 \ucd94\uac00 \ubc0f \uad8c\ud55c \uc124\uc815"},"content":{"rendered":"\n
\n

\uc804\uc81c \uc870\uac74<\/h2>\n\n\n\n
  • MySQL Server 5.7.29<\/li>
  • MySQL \ucf58\uc194 \uc811\uc18d<\/li><\/ul>\n<\/div><\/div>\n\n\n\n
    <\/div>\n\n\n\n
    \n

    MySQL \uc811\uc18d<\/h2>\n\n\n\n

    \ub9ac\ub205\uc2a4\uc5d0 MySQL \uc11c\ubc84\uac00 \uc788\uc744 \ub54c<\/p>\n\n\n\n

    $ sudo mysql<\/pre>\n\n\n\n
    MySQL \ucf58\uc194 \uc811\uc18d \ud6c4<\/p>\n\n\n\n
    mysql> USE mysql;<\/pre>\n<\/div><\/div>\n\n\n\n
    <\/div>\n\n\n\n
    \n
    \uacc4\uc815 \ud655\uc778<\/h2>\n\n\n\n
    mysql> SELECT host, user, authentication_string FROM user;<\/pre>\n\n\n\n
    \uacc4\uc815 \ud655\uc778 \ucffc\ub9ac\ubb38\uc774 MySQL \ubc84\uc804\uc5d0 \ub530\ub77c \uc57d\uac04 \ub2e4\ub974\ub2e4.
    \ud604\uc7ac \ubc84\uc804\uc5d0\uc11c\ub294 \uc704 \ucffc\ub9ac \uad6c\ubb38\uc744 \uc0ac\uc6a9\ud558\uba74 \ub41c\ub2e4.<\/p>\n<\/div><\/div>\n\n\n\n
    <\/div>\n\n\n\n
    \n
    \uacc4\uc815 \ucd94\uac00<\/h2>\n\n\n\n
    mysql> CREATE USER '\uc0ac\uc6a9\uc790'@'localhost' IDENTIFIED BY '\ube44\ubc00\ubc88\ud638';\nmysql> CREATE USER '\uc0ac\uc6a9\uc790'@'%' IDENTIFIED BY '\ube44\ubc00\ubc88\ud638';\nmysql> CREATE USER '\uc0ac\uc6a9\uc790'@'192.168.1.%' IDENTIFIED BY '\ube44\ubc00\ubc88\ud638';<\/pre>\n\n\n\n
    1: localhost(\uc11c\ubc84)\uc5d0\uc11c\ub9cc \uc811\uc18d \uac00\ub2a5
    2: %(\uc640\uc77c\ub4dc\uce74\ub4dc) \ubaa8\ub4e0 \ub300\uc5ed\uc5d0\uc11c \uc811\uc18d \uac00\ub2a5
    3: 192.168.1.* \ub300\uc5ed\uc5d0\uc11c \uc811\uc18d \uac00\ub2a5<\/p>\n<\/div><\/div>\n\n\n\n
    <\/div>\n\n\n\n
    \uad8c\ud55c \ubd80\uc5ec<\/h2>\n\n\n\n
    mysql> GRANT ALL PRIVILEGES ON *.* TO '\uc0ac\uc6a9\uc790'@'\uc811\uadfc \ub300\uc5ed';\nmysql> GRANT ALL PRIVILEGES ON \uc2a4\ud0a4\ub9c8.* TO '\uc0ac\uc6a9\uc790'@'\uc811\uadfc \ub300\uc5ed';<\/pre>\n\n\n\n
    <\/div>\n\n\n\n
    \uacc4\uc815 \uc0ad\uc81c<\/h2>\n\n\n\n
    mysql> DROP USER  '\uc0ac\uc6a9\uc790'@'localhost';<\/pre>\n\n\n\n
    <\/div>\n\n\n\n
    \ubcc0\uacbd\uc0ac\ud56d \uc801\uc6a9<\/h2>\n\n\n\n
    mysql> FLUSH PRIVILEGES;<\/pre>\n\n\n\n
    <\/div>\n
    \uc870\ud68c\uc218: 148<\/p>","protected":false},"excerpt":{"rendered":"
    \uc804\uc81c \uc870\uac74 MySQL Server 5.7.29 MySQL \ucf58\uc194 \uc811\uc18d MySQL \uc811\uc18d \ub9ac\ub205\uc2a4\uc5d0 MySQL \uc11c\ubc84\uac00 \uc788\uc744 \ub54c MySQL \ucf58\uc194 \uc811\uc18d \ud6c4 \uacc4\uc815 \ud655\uc778 \uacc4\uc815 \ud655\uc778 \ucffc\ub9ac\ubb38\uc774 MySQL \ubc84\uc804\uc5d0 \ub530\ub77c \uc57d\uac04 \ub2e4\ub974\ub2e4.\ud604\uc7ac \ubc84\uc804\uc5d0\uc11c\ub294 \uc704 \ucffc\ub9ac \uad6c\ubb38\uc744 \uc0ac\uc6a9\ud558\uba74 \ub41c\ub2e4. \uacc4\uc815 \ucd94\uac00 1: localhost(\uc11c\ubc84)\uc5d0\uc11c\ub9cc \uc811\uc18d \uac00\ub2a52: %(\uc640\uc77c\ub4dc\uce74\ub4dc) \ubaa8\ub4e0 \ub300\uc5ed\uc5d0\uc11c \uc811\uc18d \uac00\ub2a53: 192.168.1.* \ub300\uc5ed\uc5d0\uc11c \uc811\uc18d \uac00\ub2a5 \uad8c\ud55c \ubd80\uc5ec \uacc4\uc815 \uc0ad\uc81c \ubcc0\uacbd\uc0ac\ud56d […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"_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_post_was_ever_published":false},"categories":[12,52],"tags":[96,104,106,108,112],"class_list":["post-243","post","type-post","status-publish","format-standard","hentry","category-data-base-storage","category-mysql","tag-mysql","tag-104","tag-106","tag-108","tag-112"],"aioseo_notices":[],"jetpack_featured_media_url":"","jetpack_likes_enabled":true,"jetpack_sharing_enabled":true,"jetpack-related-posts":[],"_links":{"self":[{"href":"https:\/\/tech.softbell.net\/index.php?rest_route=\/wp\/v2\/posts\/243","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tech.softbell.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tech.softbell.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tech.softbell.net\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/tech.softbell.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=243"}],"version-history":[{"count":0,"href":"https:\/\/tech.softbell.net\/index.php?rest_route=\/wp\/v2\/posts\/243\/revisions"}],"wp:attachment":[{"href":"https:\/\/tech.softbell.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=243"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tech.softbell.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=243"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tech.softbell.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=243"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}