{"id":1194,"date":"2020-12-30T22:22:31","date_gmt":"2020-12-30T13:22:31","guid":{"rendered":"http:\/\/leenux.kr\/?p=1194"},"modified":"2020-12-30T22:24:57","modified_gmt":"2020-12-30T13:24:57","slug":"sql-mysql-root-host-localhost-to","status":"publish","type":"post","link":"https:\/\/leenux.kr\/?p=1194","title":{"rendered":"[SQL] MYSQL root host &#8216;localhost&#8217; to &#8216;%&#8217;"},"content":{"rendered":"\n<p class=\"has-text-color has-medium-font-size has-very-dark-gray-color\"><strong>\uc774 \uae00\uc740 phpmyadmin\uc5d0\uc11c root \ud638\uc2a4\ud2b8\uac12\uc774 &#8216;localhost&#8217;\uc758 \uac12\uc774\uc5ec\uc11c \uc811\uc18d\uc744 \ubabb\ud558\ub294 \uc0c1\ud669\uc73c\ub85c \uc778\ud574 \uc791\uc131\uc774 \ub418\uc5c8\ub2e4.<\/strong><\/p>\n\n\n\n<p class=\"has-text-color has-medium-font-size has-very-dark-gray-color\"><strong>DB \uc811\uc18d<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>mysql -u root -p<\/code><\/pre>\n\n\n\n<p class=\"has-text-color has-medium-font-size has-very-dark-gray-color\"><strong>mysql \uc811\uc18d<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>use mysql;<\/code><\/pre>\n\n\n\n<p class=\"has-text-color has-medium-font-size has-very-dark-gray-color\"><strong>\ubcc0\uacbd\ud558\uae30 \uc804 \uc0ac\uc6a9\uc790 \ud655\uc778<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>select host, user, password from user;<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" width=\"332\" height=\"115\" src=\"https:\/\/leenux.kro.kr\/wp-content\/uploads\/2020\/12\/image-17.png\" alt=\"\" class=\"wp-image-1196\" srcset=\"https:\/\/leenux.kr\/wp-content\/uploads\/2020\/12\/image-17.png 332w, https:\/\/leenux.kr\/wp-content\/uploads\/2020\/12\/image-17-300x104.png 300w, https:\/\/leenux.kr\/wp-content\/uploads\/2020\/12\/image-17-230x80.png 230w\" sizes=\"(max-width: 332px) 100vw, 332px\" \/><\/figure>\n\n\n\n<p class=\"has-text-color has-medium-font-size has-very-dark-gray-color\"><strong>root \ud638\uc2a4\ud2b8 \ubcc0\uacbd<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>UPDATE mysql.user SET Host='%' WHERE Host='localhost' AND User=''root';\nFLUSH PRIVILEGES;<\/code><\/pre>\n\n\n\n<p class=\"has-text-color has-medium-font-size has-very-dark-gray-color\"><strong>\ubcc0\uacbd \ud6c4 \uc0ac\uc6a9\uc790 \ud655\uc778<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>select host, user, password from user;<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" width=\"326\" height=\"123\" src=\"https:\/\/leenux.kro.kr\/wp-content\/uploads\/2020\/12\/image-18.png\" alt=\"\" class=\"wp-image-1197\" srcset=\"https:\/\/leenux.kr\/wp-content\/uploads\/2020\/12\/image-18.png 326w, https:\/\/leenux.kr\/wp-content\/uploads\/2020\/12\/image-18-300x113.png 300w, https:\/\/leenux.kr\/wp-content\/uploads\/2020\/12\/image-18-230x87.png 230w\" sizes=\"(max-width: 326px) 100vw, 326px\" \/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>MYSQL root host &#8216;localhost&#8217; to &#8216;%&#8217;<\/p>\n","protected":false},"author":1,"featured_media":1069,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[27],"tags":[],"_links":{"self":[{"href":"https:\/\/leenux.kr\/index.php?rest_route=\/wp\/v2\/posts\/1194"}],"collection":[{"href":"https:\/\/leenux.kr\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/leenux.kr\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/leenux.kr\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/leenux.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1194"}],"version-history":[{"count":2,"href":"https:\/\/leenux.kr\/index.php?rest_route=\/wp\/v2\/posts\/1194\/revisions"}],"predecessor-version":[{"id":1198,"href":"https:\/\/leenux.kr\/index.php?rest_route=\/wp\/v2\/posts\/1194\/revisions\/1198"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/leenux.kr\/index.php?rest_route=\/wp\/v2\/media\/1069"}],"wp:attachment":[{"href":"https:\/\/leenux.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1194"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/leenux.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1194"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/leenux.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1194"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}