{"id":1477,"date":"2026-05-13T23:22:06","date_gmt":"2026-05-13T14:22:06","guid":{"rendered":"http:\/\/www.igoni.kr\/?p=1477"},"modified":"2026-05-13T23:22:06","modified_gmt":"2026-05-13T14:22:06","slug":"mysql-grant%ec%8b%a4%ed%96%89%ec%8b%9c-access-denied-%eb%b0%9c%ec%83%9d%ec%8b%9c-%ec%a1%b0%ec%b9%98%eb%b0%a9%eb%b2%95","status":"publish","type":"post","link":"http:\/\/www.igoni.kr\/?p=1477","title":{"rendered":"mysql grant\uc2e4\ud589\uc2dc access denied \ubc1c\uc0dd\uc2dc \uc870\uce58\ubc29\ubc95"},"content":{"rendered":"<p>\uc548\ub155\ud558\uc138\uc694, \uace0\ub2c8 \uc785\ub2c8\ub2e4.<\/p>\n<p id=\"bkmrk-mysql-%EB%8D%B0%EC%9D%B4%ED%84%B0-%EC%9D%B4%EC%A0%84%28%EC%9E%AC%EC%84%A4%EC%B9%98-%EC%9D%B4%ED%9B%84%29\">mysql \ub370\uc774\ud130 \uc774\uc804(\uc7ac\uc124\uce58 \uc774\ud6c4) root\ub85c \ub85c\uadf8\uc778\ud558\uc5ec \ucffc\ub9ac \uc791\uc5c5\uc774 \ub2e4\ub978 \ucffc\ub9ac\ub294 \uc815\uc0c1\uc801\uc73c\ub85c \uc801\uc6a9\ub418\ub294\ub370,<br \/>\ngrant\uad6c\ubb38 \uc2e4\ud589\ud558\uba74 access denied \ucc98\ub9ac\ub420\ub54c,<br \/>\n\uc694\ub877\uac8c..???<\/p>\n<pre id=\"bkmrk-mysql%3E-grant-all-pri\"><code class=\"language-SQL\">mysql&gt; grant all privileges on *.* to 'root'@'1.2.3.4' identified by '123123' with grant option;\r\nERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)<\/code><\/pre>\n<table style=\"border-collapse: collapse; width: 100%;\" border=\"1\">\n<colgroup>\n<col style=\"width: 99.881%;\" \/><\/colgroup>\n<tbody>\n<tr>\n<td><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1479\" src=\"http:\/\/www.igoni.kr\/wp-content\/uploads\/2026\/05\/59b7ed97-442b-4400-868c-1a4faf552a7b.png\" alt=\"\" width=\"900\" height=\"672\" srcset=\"http:\/\/www.igoni.kr\/wp-content\/uploads\/2026\/05\/59b7ed97-442b-4400-868c-1a4faf552a7b.png 900w, http:\/\/www.igoni.kr\/wp-content\/uploads\/2026\/05\/59b7ed97-442b-4400-868c-1a4faf552a7b-300x224.png 300w, http:\/\/www.igoni.kr\/wp-content\/uploads\/2026\/05\/59b7ed97-442b-4400-868c-1a4faf552a7b-768x573.png 768w\" sizes=\"auto, (max-width: 900px) 100vw, 900px\" \/><\/td>\n<\/tr>\n<tr>\n<td>perplexity\uc5d0\uc11c \uc0dd\uc131\ud55c AI\uc774\ubbf8\uc9c0<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p id=\"bkmrk-%EA%B5%AC%EA%B8%80%EB%A7%81%EA%B2%B0%EA%B3%BC..-%EB%8D%B0%EC%9D%B4%ED%84%B0-%EC%9D%B4%EC%A0%84-%EC%9E%91%EC%97%85-%EC%A4%91-\">\uad6c\uae00\ub9c1\uacb0\uacfc.. \ub370\uc774\ud130 \uc774\uc804 \uc791\uc5c5 \uc911 \uba3c\uac00 \ud638\ud658\uc774 \uc548\ub418\uc5c8\ub358 \ubaa8\uc591.<br \/>\n\ub2e4\uc74c\uacfc\uac19\uc774 mysqlupgrade\ub97c \uc2e4\ud589\ud588\ub2e4.<\/p>\n<pre id=\"bkmrk-%24%3E-mysql_upgrade--u-\"><code class=\"language-SQL\">$&gt; mysql_upgrade -u root -p\r\nEnter password: \u2026<\/code><\/pre>\n<p id=\"bkmrk-%EC%9D%B4%ED%95%98-%ED%99%94%EB%A9%B4-%EC%83%9D%EB%9E%B5%E2%80%A6-%E2%80%A6%EB%A7%A8-%EB%A7%88%EC%A7%80%EB%A7%89-%ED%99%94%EB%A9%B4%EC%9D%80\">\uc774\ud558 \ud654\uba74 \uc0dd\ub7b5\u2026 \u2026<br \/>\n\ub9e8 \ub9c8\uc9c0\ub9c9 \ud654\uba74\uc740 Running \u2018mysql_fix_privilege_tables\u2019\u2026 OK<br \/>\n\uc77c\ub2e8 OK\ub5a8\uc5b4\uc84c\uc73c\ub2c8, \ub2e4\uc2dc grant \uc801\uc6a9\ud574\ubcf4\uc790.<\/p>\n<pre id=\"bkmrk-mysql%3E-grant-all-pri-0\"><code class=\"language-SQL\">mysql&gt; grant all privileges on *.* to 'root'@'1.2.3.4' identified by '123123' with grant option;\r\nQuery OK, 0 rows affected (0.00 sec)<\/code><\/pre>\n<p id=\"bkmrk-%EC%98%A4%E2%80%A6%EB%90%9C%EB%8B%A4%E2%80%A6.%E3%85%8B%E3%85%8B%EB%AC%BC%EB%A1%A0%2C-grant-%EA%B5%AC%EB%AC%B8\">\uc624\u2026\ub41c\ub2e4\u2026.\u314b\u314b<br \/>\n\ubb3c\ub860, grant \uad6c\ubb38\uc5d0 \ub300\ud55c \uc801\uc6a9\ub3c4 \ub41c\ub2e4.\u314e\u314e\u314e<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\uc548\ub155\ud558\uc138\uc694, \uace0\ub2c8 \uc785\ub2c8\ub2e4. mysql \ub370\uc774\ud130 \uc774\uc804(\uc7ac\uc124\uce58 \uc774\ud6c4) root\ub85c \ub85c\uadf8\uc778\ud558\uc5ec \ucffc\ub9ac \uc791\uc5c5\uc774 \ub2e4\ub978 \ucffc\ub9ac\ub294 \uc815\uc0c1\uc801\uc73c\ub85c \uc801\uc6a9\ub418\ub294\ub370, grant\uad6c\ubb38&hellip;<\/p>\n","protected":false},"author":1,"featured_media":1479,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7],"tags":[419,383,421],"class_list":["post-1477","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-linux-","tag-dcl","tag-mysql","tag-privileges"],"aioseo_notices":[],"_links":{"self":[{"href":"http:\/\/www.igoni.kr\/index.php?rest_route=\/wp\/v2\/posts\/1477","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.igoni.kr\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.igoni.kr\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.igoni.kr\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.igoni.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1477"}],"version-history":[{"count":1,"href":"http:\/\/www.igoni.kr\/index.php?rest_route=\/wp\/v2\/posts\/1477\/revisions"}],"predecessor-version":[{"id":1481,"href":"http:\/\/www.igoni.kr\/index.php?rest_route=\/wp\/v2\/posts\/1477\/revisions\/1481"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/www.igoni.kr\/index.php?rest_route=\/wp\/v2\/media\/1479"}],"wp:attachment":[{"href":"http:\/\/www.igoni.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1477"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.igoni.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1477"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.igoni.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1477"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}