{"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,\ngrant\uad6c\ubb38 \uc2e4\ud589\ud558\uba74 access denied \ucc98\ub9ac\ub420\ub54c,\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 &#039;root&#039;@&#039;1.2.3.4&#039; identified by &#039;123123&#039; with grant option;\nERROR 1045 (28000): Access denied for user &#039;root&#039;@&#039;localhost&#039; (using password: NO)<\/code><\/pre>\n<table style=\"border-collapse: collapse;width: 100%\" border=\"1\"><colgroup> <col style=\"width: 99.881%\"><\/colgroup>\n<tbody>\n<tr>\n<td><figure id=\"attachment_mmd_1479\" class=\"wp-block-image alignnone\"><img decoding=\"async\" width=\"900\" height=\"672\" src=\"http:\/\/www.igoni.kr\/wp-content\/uploads\/2026\/05\/59b7ed97-442b-4400-868c-1a4faf552a7b.png\" class=\"attachment-full size-full\" alt=\"\" loading=\"lazy\" align=\"none\" \/><\/figure><\/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.\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\nEnter password: &hellip;<\/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\n\ub9e8 \ub9c8\uc9c0\ub9c9 \ud654\uba74\uc740 Running \u2018mysql_fix_privilege_tables\u2019\u2026 OK\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 &#039;root&#039;@&#039;1.2.3.4&#039; identified by &#039;123123&#039; with grant option;\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\n\ubb3c\ub860, grant \uad6c\ubb38\uc5d0 \ub300\ud55c \uc801\uc6a9\ub3c4 \ub41c\ub2e4.\u314e\u314e\u314e<\/p>","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>","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":[],"aioseo_head":"\n\t\t<!-- All in One SEO 5.0.0.1 - aioseo.com -->\n\t<meta name=\"description\" content=\"\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 \uc2e4\ud589\ud558\uba74 access denied \ucc98\ub9ac\ub420\ub54c, \uc694\ub877\uac8c..??? mysql&gt; grant all privileges on *.* to &#039;root&#039;@&#039;1.2.3.4&#039; identified by &#039;123123&#039; with grant option; ERROR 1045 (28000): Access denied for user &#039;root&#039;@&#039;localhost&#039; (using password: NO) perplexity\uc5d0\uc11c \uc0dd\uc131\ud55c AI\uc774\ubbf8\uc9c0 \uad6c\uae00\ub9c1\uacb0\uacfc.. \ub370\uc774\ud130 \uc774\uc804 \uc791\uc5c5 \uc911 \uba3c\uac00\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"artop0420\"\/>\n\t<link rel=\"canonical\" href=\"http:\/\/www.igoni.kr\/?p=1477\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.0.1\" \/>\n\t\t<meta property=\"og:locale\" content=\"ko_KR\" \/>\n\t\t<meta property=\"og:site_name\" content=\"\uc774\uace4\uc544\uc774 - \uc798\ub098\uac00\ub294 \uc804\uc0b0\uc7c1\uc774\uc758 \ube14\ub85c\uadf8\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"mysql grant\uc2e4\ud589\uc2dc access denied \ubc1c\uc0dd\uc2dc \uc870\uce58\ubc29\ubc95 - \uc774\uace4\uc544\uc774\" \/>\n\t\t<meta property=\"og:description\" content=\"\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 \uc2e4\ud589\ud558\uba74 access denied \ucc98\ub9ac\ub420\ub54c, \uc694\ub877\uac8c..??? mysql&gt; grant all privileges on *.* to &#039;root&#039;@&#039;1.2.3.4&#039; identified by &#039;123123&#039; with grant option; ERROR 1045 (28000): Access denied for user &#039;root&#039;@&#039;localhost&#039; (using password: NO) perplexity\uc5d0\uc11c \uc0dd\uc131\ud55c AI\uc774\ubbf8\uc9c0 \uad6c\uae00\ub9c1\uacb0\uacfc.. \ub370\uc774\ud130 \uc774\uc804 \uc791\uc5c5 \uc911 \uba3c\uac00\" \/>\n\t\t<meta property=\"og:url\" content=\"http:\/\/www.igoni.kr\/?p=1477\" \/>\n\t\t<meta property=\"og:image\" content=\"http:\/\/word.igoni.kr\/wp-content\/uploads\/2026\/01\/cropped-j3fi6eistvc5ixa6lvm3ra-1.jpg\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2026-05-13T14:22:06+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2026-05-13T14:22:06+00:00\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n\t\t<meta name=\"twitter:title\" content=\"mysql grant\uc2e4\ud589\uc2dc access denied \ubc1c\uc0dd\uc2dc \uc870\uce58\ubc29\ubc95 - \uc774\uace4\uc544\uc774\" \/>\n\t\t<meta name=\"twitter:description\" content=\"\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 \uc2e4\ud589\ud558\uba74 access denied \ucc98\ub9ac\ub420\ub54c, \uc694\ub877\uac8c..??? mysql&gt; grant all privileges on *.* to &#039;root&#039;@&#039;1.2.3.4&#039; identified by &#039;123123&#039; with grant option; ERROR 1045 (28000): Access denied for user &#039;root&#039;@&#039;localhost&#039; (using password: NO) perplexity\uc5d0\uc11c \uc0dd\uc131\ud55c AI\uc774\ubbf8\uc9c0 \uad6c\uae00\ub9c1\uacb0\uacfc.. \ub370\uc774\ud130 \uc774\uc804 \uc791\uc5c5 \uc911 \uba3c\uac00\" \/>\n\t\t<meta name=\"twitter:image\" content=\"http:\/\/word.igoni.kr\/wp-content\/uploads\/2026\/01\/cropped-j3fi6eistvc5ixa6lvm3ra-1.jpg\" \/>\n\t\t<script type=\"application\/ld+json\" class=\"aioseo-schema\">\n\t\t\t{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"BlogPosting\",\"@id\":\"http:\\\/\\\/www.igoni.kr\\\/?p=1477#blogposting\",\"name\":\"mysql grant\\uc2e4\\ud589\\uc2dc access denied \\ubc1c\\uc0dd\\uc2dc \\uc870\\uce58\\ubc29\\ubc95 - \\uc774\\uace4\\uc544\\uc774\",\"headline\":\"mysql grant\\uc2e4\\ud589\\uc2dc access denied \\ubc1c\\uc0dd\\uc2dc \\uc870\\uce58\\ubc29\\ubc95\",\"author\":{\"@id\":\"http:\\\/\\\/www.igoni.kr\\\/?author=1#author\"},\"publisher\":{\"@id\":\"http:\\\/\\\/www.igoni.kr\\\/#person\"},\"image\":{\"@type\":\"ImageObject\",\"url\":\"http:\\\/\\\/www.igoni.kr\\\/wp-content\\\/uploads\\\/2026\\\/05\\\/59b7ed97-442b-4400-868c-1a4faf552a7b.png\",\"width\":900,\"height\":672},\"datePublished\":\"2026-05-13T23:22:06+09:00\",\"dateModified\":\"2026-05-13T23:22:06+09:00\",\"inLanguage\":\"ko-KR\",\"mainEntityOfPage\":{\"@id\":\"http:\\\/\\\/www.igoni.kr\\\/?p=1477#webpage\"},\"isPartOf\":{\"@id\":\"http:\\\/\\\/www.igoni.kr\\\/?p=1477#webpage\"},\"articleSection\":\"Linux \\uacf5\\ud1b5, dcl, mysql, privileges\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"http:\\\/\\\/www.igoni.kr\\\/?p=1477#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"http:\\\/\\\/www.igoni.kr#listItem\",\"position\":1,\"name\":\"Home\",\"item\":\"http:\\\/\\\/www.igoni.kr\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"http:\\\/\\\/www.igoni.kr\\\/?cat=5#listItem\",\"name\":\"1. OS\\uae30\\uc220\\ub178\\ud2b8\"}},{\"@type\":\"ListItem\",\"@id\":\"http:\\\/\\\/www.igoni.kr\\\/?cat=5#listItem\",\"position\":2,\"name\":\"1. OS\\uae30\\uc220\\ub178\\ud2b8\",\"item\":\"http:\\\/\\\/www.igoni.kr\\\/?cat=5\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"http:\\\/\\\/www.igoni.kr\\\/?cat=7#listItem\",\"name\":\"Linux \\uacf5\\ud1b5\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"http:\\\/\\\/www.igoni.kr#listItem\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"@id\":\"http:\\\/\\\/www.igoni.kr\\\/?cat=7#listItem\",\"position\":3,\"name\":\"Linux \\uacf5\\ud1b5\",\"item\":\"http:\\\/\\\/www.igoni.kr\\\/?cat=7\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"http:\\\/\\\/www.igoni.kr\\\/?p=1477#listItem\",\"name\":\"mysql grant\\uc2e4\\ud589\\uc2dc access denied \\ubc1c\\uc0dd\\uc2dc \\uc870\\uce58\\ubc29\\ubc95\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"http:\\\/\\\/www.igoni.kr\\\/?cat=5#listItem\",\"name\":\"1. OS\\uae30\\uc220\\ub178\\ud2b8\"}},{\"@type\":\"ListItem\",\"@id\":\"http:\\\/\\\/www.igoni.kr\\\/?p=1477#listItem\",\"position\":4,\"name\":\"mysql grant\\uc2e4\\ud589\\uc2dc access denied \\ubc1c\\uc0dd\\uc2dc \\uc870\\uce58\\ubc29\\ubc95\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"http:\\\/\\\/www.igoni.kr\\\/?cat=7#listItem\",\"name\":\"Linux \\uacf5\\ud1b5\"}}]},{\"@type\":\"Person\",\"@id\":\"http:\\\/\\\/www.igoni.kr\\\/#person\",\"name\":\"artop0420\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"http:\\\/\\\/www.igoni.kr\\\/?p=1477#personImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/6ed969bb042731f83571e940de11778b3d6af729b07d53ffb1c9cf224e32620f?s=96&d=mm&r=g\",\"width\":96,\"height\":96,\"caption\":\"artop0420\"}},{\"@type\":\"Person\",\"@id\":\"http:\\\/\\\/www.igoni.kr\\\/?author=1#author\",\"url\":\"http:\\\/\\\/www.igoni.kr\\\/?author=1\",\"name\":\"artop0420\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"http:\\\/\\\/www.igoni.kr\\\/?p=1477#authorImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/6ed969bb042731f83571e940de11778b3d6af729b07d53ffb1c9cf224e32620f?s=96&d=mm&r=g\",\"width\":96,\"height\":96,\"caption\":\"artop0420\"}},{\"@type\":\"WebPage\",\"@id\":\"http:\\\/\\\/www.igoni.kr\\\/?p=1477#webpage\",\"url\":\"http:\\\/\\\/www.igoni.kr\\\/?p=1477\",\"name\":\"mysql grant\\uc2e4\\ud589\\uc2dc access denied \\ubc1c\\uc0dd\\uc2dc \\uc870\\uce58\\ubc29\\ubc95 - \\uc774\\uace4\\uc544\\uc774\",\"description\":\"\\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 \\uc2e4\\ud589\\ud558\\uba74 access denied \\ucc98\\ub9ac\\ub420\\ub54c, \\uc694\\ub877\\uac8c..??? mysql> grant all privileges on *.* to 'root'@'1.2.3.4' identified by '123123' with grant option; ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) perplexity\\uc5d0\\uc11c \\uc0dd\\uc131\\ud55c AI\\uc774\\ubbf8\\uc9c0 \\uad6c\\uae00\\ub9c1\\uacb0\\uacfc.. \\ub370\\uc774\\ud130 \\uc774\\uc804 \\uc791\\uc5c5 \\uc911 \\uba3c\\uac00\",\"inLanguage\":\"ko-KR\",\"isPartOf\":{\"@id\":\"http:\\\/\\\/www.igoni.kr\\\/#website\"},\"breadcrumb\":{\"@id\":\"http:\\\/\\\/www.igoni.kr\\\/?p=1477#breadcrumblist\"},\"author\":{\"@id\":\"http:\\\/\\\/www.igoni.kr\\\/?author=1#author\"},\"creator\":{\"@id\":\"http:\\\/\\\/www.igoni.kr\\\/?author=1#author\"},\"image\":{\"@type\":\"ImageObject\",\"url\":\"http:\\\/\\\/www.igoni.kr\\\/wp-content\\\/uploads\\\/2026\\\/05\\\/59b7ed97-442b-4400-868c-1a4faf552a7b.png\",\"@id\":\"http:\\\/\\\/www.igoni.kr\\\/?p=1477\\\/#mainImage\",\"width\":900,\"height\":672},\"primaryImageOfPage\":{\"@id\":\"http:\\\/\\\/www.igoni.kr\\\/?p=1477#mainImage\"},\"datePublished\":\"2026-05-13T23:22:06+09:00\",\"dateModified\":\"2026-05-13T23:22:06+09:00\"},{\"@type\":\"WebSite\",\"@id\":\"http:\\\/\\\/www.igoni.kr\\\/#website\",\"url\":\"http:\\\/\\\/www.igoni.kr\\\/\",\"name\":\"\\uc774\\uace4\\uc544\\uc774\",\"description\":\"\\uc798\\ub098\\uac00\\ub294 \\uc804\\uc0b0\\uc7c1\\uc774\\uc758 \\ube14\\ub85c\\uadf8\",\"inLanguage\":\"ko-KR\",\"publisher\":{\"@id\":\"http:\\\/\\\/www.igoni.kr\\\/#person\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"mysql grant\uc2e4\ud589\uc2dc access denied \ubc1c\uc0dd\uc2dc \uc870\uce58\ubc29\ubc95 - \uc774\uace4\uc544\uc774","description":"\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 \uc2e4\ud589\ud558\uba74 access denied \ucc98\ub9ac\ub420\ub54c, \uc694\ub877\uac8c..??? mysql> grant all privileges on *.* to 'root'@'1.2.3.4' identified by '123123' with grant option; ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) perplexity\uc5d0\uc11c \uc0dd\uc131\ud55c AI\uc774\ubbf8\uc9c0 \uad6c\uae00\ub9c1\uacb0\uacfc.. \ub370\uc774\ud130 \uc774\uc804 \uc791\uc5c5 \uc911 \uba3c\uac00","canonical_url":"http:\/\/www.igoni.kr\/?p=1477","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"BlogPosting","@id":"http:\/\/www.igoni.kr\/?p=1477#blogposting","name":"mysql grant\uc2e4\ud589\uc2dc access denied \ubc1c\uc0dd\uc2dc \uc870\uce58\ubc29\ubc95 - \uc774\uace4\uc544\uc774","headline":"mysql grant\uc2e4\ud589\uc2dc access denied \ubc1c\uc0dd\uc2dc \uc870\uce58\ubc29\ubc95","author":{"@id":"http:\/\/www.igoni.kr\/?author=1#author"},"publisher":{"@id":"http:\/\/www.igoni.kr\/#person"},"image":{"@type":"ImageObject","url":"http:\/\/www.igoni.kr\/wp-content\/uploads\/2026\/05\/59b7ed97-442b-4400-868c-1a4faf552a7b.png","width":900,"height":672},"datePublished":"2026-05-13T23:22:06+09:00","dateModified":"2026-05-13T23:22:06+09:00","inLanguage":"ko-KR","mainEntityOfPage":{"@id":"http:\/\/www.igoni.kr\/?p=1477#webpage"},"isPartOf":{"@id":"http:\/\/www.igoni.kr\/?p=1477#webpage"},"articleSection":"Linux \uacf5\ud1b5, dcl, mysql, privileges"},{"@type":"BreadcrumbList","@id":"http:\/\/www.igoni.kr\/?p=1477#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"http:\/\/www.igoni.kr#listItem","position":1,"name":"Home","item":"http:\/\/www.igoni.kr","nextItem":{"@type":"ListItem","@id":"http:\/\/www.igoni.kr\/?cat=5#listItem","name":"1. OS\uae30\uc220\ub178\ud2b8"}},{"@type":"ListItem","@id":"http:\/\/www.igoni.kr\/?cat=5#listItem","position":2,"name":"1. OS\uae30\uc220\ub178\ud2b8","item":"http:\/\/www.igoni.kr\/?cat=5","nextItem":{"@type":"ListItem","@id":"http:\/\/www.igoni.kr\/?cat=7#listItem","name":"Linux \uacf5\ud1b5"},"previousItem":{"@type":"ListItem","@id":"http:\/\/www.igoni.kr#listItem","name":"Home"}},{"@type":"ListItem","@id":"http:\/\/www.igoni.kr\/?cat=7#listItem","position":3,"name":"Linux \uacf5\ud1b5","item":"http:\/\/www.igoni.kr\/?cat=7","nextItem":{"@type":"ListItem","@id":"http:\/\/www.igoni.kr\/?p=1477#listItem","name":"mysql grant\uc2e4\ud589\uc2dc access denied \ubc1c\uc0dd\uc2dc \uc870\uce58\ubc29\ubc95"},"previousItem":{"@type":"ListItem","@id":"http:\/\/www.igoni.kr\/?cat=5#listItem","name":"1. OS\uae30\uc220\ub178\ud2b8"}},{"@type":"ListItem","@id":"http:\/\/www.igoni.kr\/?p=1477#listItem","position":4,"name":"mysql grant\uc2e4\ud589\uc2dc access denied \ubc1c\uc0dd\uc2dc \uc870\uce58\ubc29\ubc95","previousItem":{"@type":"ListItem","@id":"http:\/\/www.igoni.kr\/?cat=7#listItem","name":"Linux \uacf5\ud1b5"}}]},{"@type":"Person","@id":"http:\/\/www.igoni.kr\/#person","name":"artop0420","image":{"@type":"ImageObject","@id":"http:\/\/www.igoni.kr\/?p=1477#personImage","url":"https:\/\/secure.gravatar.com\/avatar\/6ed969bb042731f83571e940de11778b3d6af729b07d53ffb1c9cf224e32620f?s=96&d=mm&r=g","width":96,"height":96,"caption":"artop0420"}},{"@type":"Person","@id":"http:\/\/www.igoni.kr\/?author=1#author","url":"http:\/\/www.igoni.kr\/?author=1","name":"artop0420","image":{"@type":"ImageObject","@id":"http:\/\/www.igoni.kr\/?p=1477#authorImage","url":"https:\/\/secure.gravatar.com\/avatar\/6ed969bb042731f83571e940de11778b3d6af729b07d53ffb1c9cf224e32620f?s=96&d=mm&r=g","width":96,"height":96,"caption":"artop0420"}},{"@type":"WebPage","@id":"http:\/\/www.igoni.kr\/?p=1477#webpage","url":"http:\/\/www.igoni.kr\/?p=1477","name":"mysql grant\uc2e4\ud589\uc2dc access denied \ubc1c\uc0dd\uc2dc \uc870\uce58\ubc29\ubc95 - \uc774\uace4\uc544\uc774","description":"\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 \uc2e4\ud589\ud558\uba74 access denied \ucc98\ub9ac\ub420\ub54c, \uc694\ub877\uac8c..??? mysql> grant all privileges on *.* to 'root'@'1.2.3.4' identified by '123123' with grant option; ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) perplexity\uc5d0\uc11c \uc0dd\uc131\ud55c AI\uc774\ubbf8\uc9c0 \uad6c\uae00\ub9c1\uacb0\uacfc.. \ub370\uc774\ud130 \uc774\uc804 \uc791\uc5c5 \uc911 \uba3c\uac00","inLanguage":"ko-KR","isPartOf":{"@id":"http:\/\/www.igoni.kr\/#website"},"breadcrumb":{"@id":"http:\/\/www.igoni.kr\/?p=1477#breadcrumblist"},"author":{"@id":"http:\/\/www.igoni.kr\/?author=1#author"},"creator":{"@id":"http:\/\/www.igoni.kr\/?author=1#author"},"image":{"@type":"ImageObject","url":"http:\/\/www.igoni.kr\/wp-content\/uploads\/2026\/05\/59b7ed97-442b-4400-868c-1a4faf552a7b.png","@id":"http:\/\/www.igoni.kr\/?p=1477\/#mainImage","width":900,"height":672},"primaryImageOfPage":{"@id":"http:\/\/www.igoni.kr\/?p=1477#mainImage"},"datePublished":"2026-05-13T23:22:06+09:00","dateModified":"2026-05-13T23:22:06+09:00"},{"@type":"WebSite","@id":"http:\/\/www.igoni.kr\/#website","url":"http:\/\/www.igoni.kr\/","name":"\uc774\uace4\uc544\uc774","description":"\uc798\ub098\uac00\ub294 \uc804\uc0b0\uc7c1\uc774\uc758 \ube14\ub85c\uadf8","inLanguage":"ko-KR","publisher":{"@id":"http:\/\/www.igoni.kr\/#person"}}]},"og:locale":"ko_KR","og:site_name":"\uc774\uace4\uc544\uc774 - \uc798\ub098\uac00\ub294 \uc804\uc0b0\uc7c1\uc774\uc758 \ube14\ub85c\uadf8","og:type":"article","og:title":"mysql grant\uc2e4\ud589\uc2dc access denied \ubc1c\uc0dd\uc2dc \uc870\uce58\ubc29\ubc95 - \uc774\uace4\uc544\uc774","og:description":"\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 \uc2e4\ud589\ud558\uba74 access denied \ucc98\ub9ac\ub420\ub54c, \uc694\ub877\uac8c..??? mysql&gt; grant all privileges on *.* to 'root'@'1.2.3.4' identified by '123123' with grant option; ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) perplexity\uc5d0\uc11c \uc0dd\uc131\ud55c AI\uc774\ubbf8\uc9c0 \uad6c\uae00\ub9c1\uacb0\uacfc.. \ub370\uc774\ud130 \uc774\uc804 \uc791\uc5c5 \uc911 \uba3c\uac00","og:url":"http:\/\/www.igoni.kr\/?p=1477","og:image":"http:\/\/word.igoni.kr\/wp-content\/uploads\/2026\/01\/cropped-j3fi6eistvc5ixa6lvm3ra-1.jpg","article:published_time":"2026-05-13T14:22:06+00:00","article:modified_time":"2026-05-13T14:22:06+00:00","twitter:card":"summary_large_image","twitter:title":"mysql grant\uc2e4\ud589\uc2dc access denied \ubc1c\uc0dd\uc2dc \uc870\uce58\ubc29\ubc95 - \uc774\uace4\uc544\uc774","twitter:description":"\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 \uc2e4\ud589\ud558\uba74 access denied \ucc98\ub9ac\ub420\ub54c, \uc694\ub877\uac8c..??? mysql&gt; grant all privileges on *.* to 'root'@'1.2.3.4' identified by '123123' with grant option; ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) perplexity\uc5d0\uc11c \uc0dd\uc131\ud55c AI\uc774\ubbf8\uc9c0 \uad6c\uae00\ub9c1\uacb0\uacfc.. \ub370\uc774\ud130 \uc774\uc804 \uc791\uc5c5 \uc911 \uba3c\uac00","twitter:image":"http:\/\/word.igoni.kr\/wp-content\/uploads\/2026\/01\/cropped-j3fi6eistvc5ixa6lvm3ra-1.jpg"},"aioseo_meta_data":{"post_id":"1477","title":null,"description":null,"keywords":null,"keyphrases":{"focus":[],"additional":[]},"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":"","og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"BlogPosting","isEnabled":true},"graphs":[]},"schema_type":"default","schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":"-1","robots_max_videopreview":"-1","robots_max_imagepreview":"large","priority":null,"frequency":"default","local_seo":null,"breadcrumb_settings":null,"limit_modified_date":false,"ai":{"faqs":[],"keyPoints":[],"schemas":[],"titles":[],"descriptions":[],"socialPosts":{"email":[],"linkedin":[],"twitter":[],"facebook":[],"instagram":[]}},"created":"2026-05-13 14:22:06","updated":"2026-08-07 15:16:39","seo_analyzer_scan_date":null,"focus_keyword":null,"additional_keywords":null,"truseo_locale":null},"aioseo_breadcrumb":"<div class=\"aioseo-breadcrumbs\"><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"http:\/\/www.igoni.kr\" title=\"Home\">Home<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"http:\/\/www.igoni.kr\/?cat=5\" title=\"1. OS\uae30\uc220\ub178\ud2b8\">1. OS\uae30\uc220\ub178\ud2b8<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"http:\/\/www.igoni.kr\/?cat=7\" title=\"Linux \uacf5\ud1b5\">Linux \uacf5\ud1b5<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\tmysql grant\uc2e4\ud589\uc2dc access denied \ubc1c\uc0dd\uc2dc \uc870\uce58\ubc29\ubc95\n\t\t<\/span><\/div>","aioseo_breadcrumb_json":[{"label":"Home","link":"http:\/\/www.igoni.kr"},{"label":"1. OS\uae30\uc220\ub178\ud2b8","link":"http:\/\/www.igoni.kr\/?cat=5"},{"label":"Linux \uacf5\ud1b5","link":"http:\/\/www.igoni.kr\/?cat=7"},{"label":"mysql grant\uc2e4\ud589\uc2dc access denied \ubc1c\uc0dd\uc2dc \uc870\uce58\ubc29\ubc95","link":"http:\/\/www.igoni.kr\/?p=1477"}],"_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}]}}