{"id":149,"date":"2017-12-26T20:49:24","date_gmt":"2017-12-26T11:49:24","guid":{"rendered":"https:\/\/www.itchefblog.com\/?p=149"},"modified":"2018-01-02T10:43:41","modified_gmt":"2018-01-02T01:43:41","slug":"%ec%8b%a4%ec%88%98%eb%a1%9c-%ec%82%ad%ec%a0%9c%ed%95%9c-mysql-root-%ea%b3%84%ec%a0%95-%eb%b3%b5%ea%b5%ac","status":"publish","type":"post","link":"https:\/\/www.itchefblog.com\/?p=149","title":{"rendered":"\uc2e4\uc218\ub85c \uc0ad\uc81c\ud55c MySQL ROOT \uacc4\uc815 \ubcf5\uad6c"},"content":{"rendered":"

\uc5bc\ud1a0\ub2f9\ud1a0\uc54a\uc740 \uc2e4\uc218\ub97c \ud574\ubc84\ub838\ub2e4.
\n<\/span>\uc6b4\uc601 \uc911\uc778 \uc11c\ubc84\uc758 \uac1c\ubc1c \uc11c\ubc84\uc5d0\uc11c \uc0ac\uc6a9\ud558\uc9c0 \uc54a\ub294\u00a0Database<\/span>\ub4e4\uc744 \uc0ad\uc81c\ud558\ub294 \uacfc\uc815\uc5d0\uc11c
\n\uc2e4\uc218\ub85c\u00a0ROOT\u00a0<\/span>\uacc4\uc815\uc744 \ud3ec\ud568\ud574\uc11c \uc0ad\uc81c\ud574\ubc84\ub9b0 \uac83\uc774\ub2e4.<\/span><\/p>\n

\n\uc544\ubfd4\uc2f8.\u00a0<\/span>\uc774\ubbf8 \ub54c\ub294 \ub2a6\uc5c8\ub2e4.
\n<\/span>\ud558\uc9c0\ub9cc \ub2e4\ud589\uc778 \uac83\uc740 \uc2e4\uc81c \uc11c\ube44\uc2a4 \uc911\uc774 \uc544\ub2cc \uac1c\ubc1c \uc11c\ubc84 \ud658\uacbd\uc774\ub77c\ub294 \uac83…;<\/span><\/p>\n


\nroot\u00a0<\/span>\uacc4\uc815 \uc5c6\uc774\ub294 \ub2e4\ub978 \uacc4\uc815 \ucd94\uac00 \uc0ad\uc81c\ub294 \ubb3c\ub860 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uad00\ub9ac\uac00 \ubd88\uac00\ud558\uae30\uc5d0
\n\uc815\ub9d0 \ub09c\uac10\ud55c \uc0c1\ud669\uc774 \uc544\ub2d0 \uc218 \uc5c6\ub2e4.<\/span><\/p>\n

\ud558\uc9c0\ub9cc \uc190\uc27d\uac8c \ubcf5\uad6c\ud560 \uc218 \uc788\ub294 \ubc29\ubc95\uc774 \uc788\uc73c\ub2c8 \ub2f9\ud669\uc740 \uae08\ubb3c!<\/span><\/p>\n

\uc2e4\uc218\ub85c \uc0ad\uc81c\ud55c\u00a0root\u00a0<\/span>\uacc4\uc815\uc744 \ubcf5\uad6c\ud558\ub294 \uc808\ucc28\ub294 \ub2e4\uc74c\uacfc \uac19\ub2e4.<\/span><\/p>\n

\n

1. MySQL\u00a0\ud639\uc740<\/span>\u00a0MariaDB\uc758<\/span>\u00a0\ud504\ub85c\uc138\uc2a4<\/span>\u00a0\uc885\ub8cc<\/span><\/p>\n

2.\u00a0<\/span>\uc778\uc99d \uc808\ucc28 \uc5c6\ub294 \uc811\uc18d \ubaa8\ub4dc\ub85c\u00a0DB\u00a0<\/span>\ud504\ub85c\uc138\uc2a4 \uc2dc\uc791<\/p>\n

3. root\u00a0\uacc4\uc815<\/span>\u00a0\ucd94\uac00<\/span><\/p>\n

4.\u00a0\ucd94\uac00\ud55c<\/span>\u00a0root\u00a0\uacc4\uc815\uc5d0<\/span>\u00a0\ubaa8\ub4e0<\/span>\u00a0\uad8c\ud55c<\/span>\u00a0\ubd80\uc5ec<\/span><\/p>\n

5. DB\u00a0<\/span>\ud504\ub85c\uc138\uc2a4 \uc815\uc0c1\uc801\uc73c\ub85c \uc7ac\uc2dc\uc791<\/p>\n

\n

\uc704\uc640 \uac19\uc774\u00a05<\/span>\ub2e8\uacc4\ub85c \uad6c\uc131\ub418\uba70 \ub2e4\uc74c\uacfc \uac19\uc740 \uba85\ub839\uc5b4\ub85c \uac00\ub2a5\ud558\ub2e4.
\n<\/span>($\ub294<\/span>\u00a0\ub9ac\ub205\uc2a4<\/span>\u00a0\ucf58\uc194<\/span>, >\ub294<\/span>\u00a0MySQL\u00a0\ucf58\uc194<\/span>)<\/p>\n

\n

$ps -ef | grep mysqld
\n\uc774 \uba85\ub839\uc5b4\ub85c \uc2e4\ud589 \uc911\uc778\u00a0DB\u00a0<\/span>\ud504\ub85c\uc138\uc2a4\uc758\u00a0pid<\/span>\ub97c \uc54c\uc544\ub0b8\ub2e4.<\/span><\/p>\n

$kill -9 ‘\ud504\ub85c\uc138\uc2a4<\/span>\u00a0ID’\ub85c<\/span>\u00a0\ud504\ub85c\uc138\uc2a4<\/span>\u00a0\uc885\ub8cc<\/span><\/p>\n

$mysql\u00a0 –skip-grant &
\n\uc704\uc758 \uba85\ub839\uc5b4\ub85c \uc778\uc99d \uc808\ucc28 \uc5c6\uc774 \ub85c\uadf8\uc778 \uac00\ub2a5\ud558\uac8c \uc2e4\ud589
\n(<\/span>\ud639\uc740\u00a0mysqld_safe\u00a0<\/span>\uc2a4\ud06c\ub9bd\ud2b8\uac00 \uc774\uc6a9\ub418\uae30\ub3c4 \ud55c\ub2e4.\u00a0<\/span>\uc11c\ubc84 \ud658\uacbd\uc774\ub098 \uc124\uce58 \ubc29\uc2dd\uc5d0 \ub530\ub77c \uc0c1\uc774)<\/span><\/p>\n

\n

$mysql -u root mysql
\n\uc704\uc758 \uba85\ub839\uc5b4\ub85c \uc778\uc99d \uc808\ucc28 \uc5c6\uc774\u00a0MySQL\u00a0<\/span>\ucf58\uc194 \uc811\uc18d<\/p>\n

>use mysql;
\n\uc704<\/span>\u00a0\uba85\ub839\uc5b4\ub85c<\/span>\u00a0mysql database\u00a0\uc120\ud0dd<\/span><\/p>\n

>insert into user (Host, User, Password) values (‘localhost’, ‘root’, password(‘\uc0ac\uc6a9\ud560<\/span>\u00a0\ud328\uc2a4\uc6cc\ub4dc<\/span>‘));
\n\uc704\uc758 \uba85\ub839\uc5b4\ub85c \uc0ad\uc81c\ub41c\u00a0root\u00a0<\/span>\uacc4\uc815 \ucd94\uac00<\/p>\n

>grant all privileges on *.* to\u00a0root@localhost<\/span><\/a>\u00a0 with grant option;
\n\uc704\uc758 \uba85\ub839\uc5b4\ub85c \uc0dd\uc131\ub41c\u00a0root\u00a0<\/span>\uacc4\uc815\uc5d0 \ubaa8\ub4e0 \uad8c\ud55c\uc744 \ubd80\uc5ec<\/p>\n

>flush privileges;
\n\uc704\uc758 \uad6c\ubb38\uc73c\ub85c \ubcc0\uacbd\ub41c \ubaa8\ub4e0 \uc0ac\ud56d \uc801\uc6a9<\/p>\n

>exit;
\nexit\u00a0\uad6c\ubb38\uc73c\ub85c<\/span>\u00a0MySQL\u00a0\ucf58\uc194<\/span>\u00a0\uc885\ub8cc<\/span><\/p>\n

\uc704\uc758 \uc808\ucc28\ub97c \ub9c8\uce5c \ud6c4 \ub2e4\uc2dc \uc815\uc0c1\uc801\uc73c\ub85c\u00a0MySQL\u00a0<\/span>\ud639\uc740\u00a0MariaDB\u00a0<\/span>\ud504\ub85c\uc138\uc2a4\ub97c \uc2e4\ud589\uc2dc\ucf1c\uc8fc\uba74
\nroot\u00a0<\/span>\uacc4\uc815\uc744 \uc815\uc0c1\uc801\uc73c\ub85c \ub2e4\uc2dc \uc0ac\uc6a9\ud560 \uc218 \uc788\ub2e4.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

\uc5bc\ud1a0\ub2f9\ud1a0\uc54a\uc740 \uc2e4\uc218\ub97c \ud574\ubc84\ub838\ub2e4. \uc6b4\uc601 \uc911\uc778 \uc11c\ubc84\uc758 \uac1c\ubc1c \uc11c\ubc84\uc5d0\uc11c \uc0ac\uc6a9\ud558\uc9c0 \uc54a\ub294\u00a0Database\ub4e4\uc744 \uc0ad\uc81c\ud558\ub294 \uacfc\uc815\uc5d0\uc11c \uc2e4\uc218\ub85c\u00a0ROOT\u00a0\uacc4\uc815\uc744 \ud3ec\ud568\ud574\uc11c \uc0ad\uc81c\ud574\ubc84\ub9b0 \uac83\uc774\ub2e4. \uc544\ubfd4\uc2f8.\u00a0\uc774\ubbf8 \ub54c\ub294 \ub2a6\uc5c8\ub2e4. \ud558\uc9c0\ub9cc \ub2e4\ud589\uc778 \uac83\uc740 \uc2e4\uc81c \uc11c\ube44\uc2a4 \uc911\uc774 \uc544\ub2cc \uac1c\ubc1c \uc11c\ubc84 \ud658\uacbd\uc774\ub77c\ub294 \uac83…; root\u00a0\uacc4\uc815 \uc5c6\uc774\ub294 \ub2e4\ub978 \uacc4\uc815 \ucd94\uac00 \uc0ad\uc81c\ub294 \ubb3c\ub860 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uad00\ub9ac\uac00 \ubd88\uac00\ud558\uae30\uc5d0 \uc815\ub9d0 \ub09c\uac10\ud55c \uc0c1\ud669\uc774 \uc544\ub2d0 \uc218 \uc5c6\ub2e4. \ud558\uc9c0\ub9cc \uc190\uc27d\uac8c \ubcf5\uad6c\ud560 \uc218 \uc788\ub294 \ubc29\ubc95\uc774 \uc788\uc73c\ub2c8 \ub2f9\ud669\uc740 \uae08\ubb3c! … <\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[20],"tags":[34,35,36,37,29,30,31,32,33],"_links":{"self":[{"href":"https:\/\/www.itchefblog.com\/index.php?rest_route=\/wp\/v2\/posts\/149"}],"collection":[{"href":"https:\/\/www.itchefblog.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.itchefblog.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.itchefblog.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.itchefblog.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=149"}],"version-history":[{"count":1,"href":"https:\/\/www.itchefblog.com\/index.php?rest_route=\/wp\/v2\/posts\/149\/revisions"}],"predecessor-version":[{"id":151,"href":"https:\/\/www.itchefblog.com\/index.php?rest_route=\/wp\/v2\/posts\/149\/revisions\/151"}],"wp:attachment":[{"href":"https:\/\/www.itchefblog.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=149"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.itchefblog.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=149"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.itchefblog.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=149"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}