{"id":1497,"date":"2026-05-13T23:29:10","date_gmt":"2026-05-13T14:29:10","guid":{"rendered":"http:\/\/www.igoni.kr\/?p=1497"},"modified":"2026-05-13T23:31:37","modified_gmt":"2026-05-13T14:31:37","slug":"mysql-root-%ec%82%ac%ec%9a%a9%ec%9e%90-%ed%8c%a8%ec%8a%a4%ec%9b%8c%eb%93%9c-%ec%9e%ac%ec%84%a4%ec%a0%95-%eb%b0%a9%eb%b2%95","status":"publish","type":"post","link":"http:\/\/www.igoni.kr\/?p=1497","title":{"rendered":"Mysql root \uc0ac\uc6a9\uc790 \ud328\uc2a4\uc6cc\ub4dc \uc7ac\uc124\uc815 \ubc29\ubc95"},"content":{"rendered":"<p>\uc548\ub155\ud558\uc138\uc694, \uace0\ub2c8\uc785\ub2c8\ub2e4.<\/p>\n<p>\uc544\uc8fc \uac00\ub054.. mysql\uc6a9 root\u00a0 \ud328\uc2a4\uc6cc\ub4dc \ubd84\uc2e4\ub85c \uc7ac\uc124\uc815\uc774 \ud544\uc694\ud55c \uacbd\uc6b0 \uc808\ucc28\ub97c \uc548\ub0b4\ud574\ub4dc\ub9bd\ub2c8\ub2e4.<\/p>\n<table style=\"border-collapse: collapse;width: 100%\" border=\"1\"><colgroup> <col style=\"width: 100.015%\"><\/colgroup>\n<tbody>\n<tr>\n<td><figure id=\"attachment_mmd_1499\" class=\"wp-block-image alignnone\"><img decoding=\"async\" width=\"840\" height=\"627\" src=\"http:\/\/www.igoni.kr\/wp-content\/uploads\/2026\/05\/d8d6543e-e263-4094-8a8d-280af440ea79.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<ol id=\"bkmrk-mysql-%EC%84%9C%EB%B9%84%EC%8A%A4-%EC%A2%85%EB%A3%8C-%24%3E%C2%A0kill\">\n\n<li>Mysql \uc11c\ube44\uc2a4 \uc885\ub8cc\n<pre><code class=\"language-Python\">$&gt;&nbsp;killall&nbsp;mysqld<\/code><\/pre>\n<\/li>\n\n<li>Mysql \uc635\uc158 \uc801\uc6a9\ud558\uc5ec \uc7ac\uc2dc\uc791\n<pre><code class=\"language-Python\">\/usr\/local\/mysql\/bin\/mysqld_safe&nbsp;~-~-skip-grant-tables&nbsp;&amp;\n<\/code><\/pre>\n<div>\n<div class=\"box\">\n<div class=\"code\"><\/div>\n<\/div>\n<\/div><\/li>\n\n<li>Mysql root \uc0ac\uc6a9\uc790 \ub85c\uadf8\uc778\n<pre><code class=\"language-Python\">$&gt; \/usr\/local\/mysql\/bin\/mysql&nbsp;-u&nbsp;root&nbsp;mysql\n*&nbsp;\uc815\uc0c1\uc801\uc73c\ub85c&nbsp;\uc218\ud589\ub420&nbsp;\uacbd\uc6b0&nbsp;\ucf58\uc194\ud654\uba74\uc774&nbsp;&quot;mysql&gt;&quot;&nbsp;\uc73c\ub85c&nbsp;\ubcc0\uacbd\ub420&nbsp;\uac83\uc785\ub2c8\ub2e4.<\/code><\/pre>\n<\/li>\n\n<li>root \ud328\uc2a4\uc6cc\ub4dc \uc7ac\uc9c0\uc815 (Mysql 5.7\uc774\ud558 \ubc84\uc804\uc5d0\uc11c \uc0ac\uc6a9\ud558\uc138\uc694.)\n<pre><code class=\"language-SQL\">mysql&gt; update&nbsp;user&nbsp;set&nbsp;password=password(&#039;\ubcc0\uacbd\ud560\ud328\uc2a4\uc6cc\ub4dc\uc785\ub825&#039;)&nbsp;where&nbsp;user&nbsp;=&nbsp;&#039;root&#039;;\nmysql&gt; flush&nbsp;privileges;\nmysql&gt; quit;<\/code><\/pre>\n<div><\/div><\/li>\n\n<li>\uc9c0\uc815\ud55c \ud328\uc2a4\uc6cc\ub4dc \uc785\ub825\ud558\uc5ec mysql \ub85c\uadf8\uc778\n<pre><code class=\"language-Python\">\/usr\/local\/mysql\/bin\/mysql&nbsp;-u&nbsp;root&nbsp;-p&nbsp;&nbsp;&nbsp;<\/code><\/pre>\n\u00a0<\/li>\n<\/ol>","protected":false},"excerpt":{"rendered":"<p>\uc548\ub155\ud558\uc138\uc694, \uace0\ub2c8\uc785\ub2c8\ub2e4. \uc544\uc8fc \uac00\ub054.. mysql\uc6a9 root\u00a0 \ud328\uc2a4\uc6cc\ub4dc \ubd84\uc2e4\ub85c \uc7ac\uc124\uc815\uc774 \ud544\uc694\ud55c \uacbd\uc6b0 \uc808\ucc28\ub97c \uc548\ub0b4\ud574\ub4dc\ub9bd\ub2c8\ub2e4. perplexity\uc5d0\uc11c \uc0dd\uc131\ud55c AI\uc774\ubbf8\uc9c0&hellip;<\/p>","protected":false},"author":1,"featured_media":1499,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[379,381],"tags":[427,425],"class_list":["post-1497","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-4-dbms--","category-mysqlmariadb","tag-grant-tables","tag-mysql-root"],"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. \uc544\uc8fc \uac00\ub054.. mysql\uc6a9 root \ud328\uc2a4\uc6cc\ub4dc \ubd84\uc2e4\ub85c \uc7ac\uc124\uc815\uc774 \ud544\uc694\ud55c \uacbd\uc6b0 \uc808\ucc28\ub97c \uc548\ub0b4\ud574\ub4dc\ub9bd\ub2c8\ub2e4. perplexity\uc5d0\uc11c \uc0dd\uc131\ud55c AI\uc774\ubbf8\uc9c0 Mysql \uc11c\ube44\uc2a4 \uc885\ub8cc $&gt; killall mysqld Mysql \uc635\uc158 \uc801\uc6a9\ud558\uc5ec \uc7ac\uc2dc\uc791 \/usr\/local\/mysql\/bin\/mysqld_safe ~-~-skip-grant-tables &amp; Mysql root \uc0ac\uc6a9\uc790 \ub85c\uadf8\uc778 $&gt; \/usr\/local\/mysql\/bin\/mysql -u root mysql * \uc815\uc0c1\uc801\uc73c\ub85c \uc218\ud589\ub420 \uacbd\uc6b0 \ucf58\uc194\ud654\uba74\uc774 &quot;mysql&gt;&quot; \uc73c\ub85c \ubcc0\uacbd\ub420 \uac83\uc785\ub2c8\ub2e4. root \ud328\uc2a4\uc6cc\ub4dc \uc7ac\uc9c0\uc815 (Mysql 5.7\uc774\ud558 \ubc84\uc804\uc5d0\uc11c \uc0ac\uc6a9\ud558\uc138\uc694.) mysql&gt; update user set password=password(&#039;\ubcc0\uacbd\ud560\ud328\uc2a4\uc6cc\ub4dc\uc785\ub825&#039;) where user = &#039;root&#039;; mysql&gt; flush privileges; mysql&gt; quit; \uc9c0\uc815\ud55c \ud328\uc2a4\uc6cc\ub4dc \uc785\ub825\ud558\uc5ec mysql \ub85c\uadf8\uc778 \/usr\/local\/mysql\/bin\/mysql -u root -p\" \/>\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=1497\" \/>\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 root \uc0ac\uc6a9\uc790 \ud328\uc2a4\uc6cc\ub4dc \uc7ac\uc124\uc815 \ubc29\ubc95 - \uc774\uace4\uc544\uc774\" \/>\n\t\t<meta property=\"og:description\" content=\"\uc548\ub155\ud558\uc138\uc694, \uace0\ub2c8\uc785\ub2c8\ub2e4. \uc544\uc8fc \uac00\ub054.. mysql\uc6a9 root \ud328\uc2a4\uc6cc\ub4dc \ubd84\uc2e4\ub85c \uc7ac\uc124\uc815\uc774 \ud544\uc694\ud55c \uacbd\uc6b0 \uc808\ucc28\ub97c \uc548\ub0b4\ud574\ub4dc\ub9bd\ub2c8\ub2e4. perplexity\uc5d0\uc11c \uc0dd\uc131\ud55c AI\uc774\ubbf8\uc9c0 Mysql \uc11c\ube44\uc2a4 \uc885\ub8cc $&gt; killall mysqld Mysql \uc635\uc158 \uc801\uc6a9\ud558\uc5ec \uc7ac\uc2dc\uc791 \/usr\/local\/mysql\/bin\/mysqld_safe ~-~-skip-grant-tables &amp; Mysql root \uc0ac\uc6a9\uc790 \ub85c\uadf8\uc778 $&gt; \/usr\/local\/mysql\/bin\/mysql -u root mysql * \uc815\uc0c1\uc801\uc73c\ub85c \uc218\ud589\ub420 \uacbd\uc6b0 \ucf58\uc194\ud654\uba74\uc774 &quot;mysql&gt;&quot; \uc73c\ub85c \ubcc0\uacbd\ub420 \uac83\uc785\ub2c8\ub2e4. root \ud328\uc2a4\uc6cc\ub4dc \uc7ac\uc9c0\uc815 (Mysql 5.7\uc774\ud558 \ubc84\uc804\uc5d0\uc11c \uc0ac\uc6a9\ud558\uc138\uc694.) mysql&gt; update user set password=password(&#039;\ubcc0\uacbd\ud560\ud328\uc2a4\uc6cc\ub4dc\uc785\ub825&#039;) where user = &#039;root&#039;; mysql&gt; flush privileges; mysql&gt; quit; \uc9c0\uc815\ud55c \ud328\uc2a4\uc6cc\ub4dc \uc785\ub825\ud558\uc5ec mysql \ub85c\uadf8\uc778 \/usr\/local\/mysql\/bin\/mysql -u root -p\" \/>\n\t\t<meta property=\"og:url\" content=\"http:\/\/www.igoni.kr\/?p=1497\" \/>\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:29:10+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2026-05-13T14:31:37+00:00\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n\t\t<meta name=\"twitter:title\" content=\"Mysql root \uc0ac\uc6a9\uc790 \ud328\uc2a4\uc6cc\ub4dc \uc7ac\uc124\uc815 \ubc29\ubc95 - \uc774\uace4\uc544\uc774\" \/>\n\t\t<meta name=\"twitter:description\" content=\"\uc548\ub155\ud558\uc138\uc694, \uace0\ub2c8\uc785\ub2c8\ub2e4. \uc544\uc8fc \uac00\ub054.. mysql\uc6a9 root \ud328\uc2a4\uc6cc\ub4dc \ubd84\uc2e4\ub85c \uc7ac\uc124\uc815\uc774 \ud544\uc694\ud55c \uacbd\uc6b0 \uc808\ucc28\ub97c \uc548\ub0b4\ud574\ub4dc\ub9bd\ub2c8\ub2e4. perplexity\uc5d0\uc11c \uc0dd\uc131\ud55c AI\uc774\ubbf8\uc9c0 Mysql \uc11c\ube44\uc2a4 \uc885\ub8cc $&gt; killall mysqld Mysql \uc635\uc158 \uc801\uc6a9\ud558\uc5ec \uc7ac\uc2dc\uc791 \/usr\/local\/mysql\/bin\/mysqld_safe ~-~-skip-grant-tables &amp; Mysql root \uc0ac\uc6a9\uc790 \ub85c\uadf8\uc778 $&gt; \/usr\/local\/mysql\/bin\/mysql -u root mysql * \uc815\uc0c1\uc801\uc73c\ub85c \uc218\ud589\ub420 \uacbd\uc6b0 \ucf58\uc194\ud654\uba74\uc774 &quot;mysql&gt;&quot; \uc73c\ub85c \ubcc0\uacbd\ub420 \uac83\uc785\ub2c8\ub2e4. root \ud328\uc2a4\uc6cc\ub4dc \uc7ac\uc9c0\uc815 (Mysql 5.7\uc774\ud558 \ubc84\uc804\uc5d0\uc11c \uc0ac\uc6a9\ud558\uc138\uc694.) mysql&gt; update user set password=password(&#039;\ubcc0\uacbd\ud560\ud328\uc2a4\uc6cc\ub4dc\uc785\ub825&#039;) where user = &#039;root&#039;; mysql&gt; flush privileges; mysql&gt; quit; \uc9c0\uc815\ud55c \ud328\uc2a4\uc6cc\ub4dc \uc785\ub825\ud558\uc5ec mysql \ub85c\uadf8\uc778 \/usr\/local\/mysql\/bin\/mysql -u root -p\" \/>\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=1497#blogposting\",\"name\":\"Mysql root \\uc0ac\\uc6a9\\uc790 \\ud328\\uc2a4\\uc6cc\\ub4dc \\uc7ac\\uc124\\uc815 \\ubc29\\ubc95 - \\uc774\\uace4\\uc544\\uc774\",\"headline\":\"Mysql root \\uc0ac\\uc6a9\\uc790 \\ud328\\uc2a4\\uc6cc\\ub4dc \\uc7ac\\uc124\\uc815 \\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\\\/d8d6543e-e263-4094-8a8d-280af440ea79.png\",\"width\":840,\"height\":627},\"datePublished\":\"2026-05-13T23:29:10+09:00\",\"dateModified\":\"2026-05-13T23:31:37+09:00\",\"inLanguage\":\"ko-KR\",\"mainEntityOfPage\":{\"@id\":\"http:\\\/\\\/www.igoni.kr\\\/?p=1497#webpage\"},\"isPartOf\":{\"@id\":\"http:\\\/\\\/www.igoni.kr\\\/?p=1497#webpage\"},\"articleSection\":\"4. DBMS \\uc815\\ubcf4 \\uae30\\ub85d, Mysql&amp;MariaDB, grant-tables, mysql. root\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"http:\\\/\\\/www.igoni.kr\\\/?p=1497#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=379#listItem\",\"name\":\"4. DBMS \\uc815\\ubcf4 \\uae30\\ub85d\"}},{\"@type\":\"ListItem\",\"@id\":\"http:\\\/\\\/www.igoni.kr\\\/?cat=379#listItem\",\"position\":2,\"name\":\"4. DBMS \\uc815\\ubcf4 \\uae30\\ub85d\",\"item\":\"http:\\\/\\\/www.igoni.kr\\\/?cat=379\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"http:\\\/\\\/www.igoni.kr\\\/?cat=381#listItem\",\"name\":\"Mysql&amp;MariaDB\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"http:\\\/\\\/www.igoni.kr#listItem\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"@id\":\"http:\\\/\\\/www.igoni.kr\\\/?cat=381#listItem\",\"position\":3,\"name\":\"Mysql&amp;MariaDB\",\"item\":\"http:\\\/\\\/www.igoni.kr\\\/?cat=381\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"http:\\\/\\\/www.igoni.kr\\\/?p=1497#listItem\",\"name\":\"Mysql root \\uc0ac\\uc6a9\\uc790 \\ud328\\uc2a4\\uc6cc\\ub4dc \\uc7ac\\uc124\\uc815 \\ubc29\\ubc95\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"http:\\\/\\\/www.igoni.kr\\\/?cat=379#listItem\",\"name\":\"4. DBMS \\uc815\\ubcf4 \\uae30\\ub85d\"}},{\"@type\":\"ListItem\",\"@id\":\"http:\\\/\\\/www.igoni.kr\\\/?p=1497#listItem\",\"position\":4,\"name\":\"Mysql root \\uc0ac\\uc6a9\\uc790 \\ud328\\uc2a4\\uc6cc\\ub4dc \\uc7ac\\uc124\\uc815 \\ubc29\\ubc95\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"http:\\\/\\\/www.igoni.kr\\\/?cat=381#listItem\",\"name\":\"Mysql&amp;MariaDB\"}}]},{\"@type\":\"Person\",\"@id\":\"http:\\\/\\\/www.igoni.kr\\\/#person\",\"name\":\"artop0420\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"http:\\\/\\\/www.igoni.kr\\\/?p=1497#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=1497#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=1497#webpage\",\"url\":\"http:\\\/\\\/www.igoni.kr\\\/?p=1497\",\"name\":\"Mysql root \\uc0ac\\uc6a9\\uc790 \\ud328\\uc2a4\\uc6cc\\ub4dc \\uc7ac\\uc124\\uc815 \\ubc29\\ubc95 - \\uc774\\uace4\\uc544\\uc774\",\"description\":\"\\uc548\\ub155\\ud558\\uc138\\uc694, \\uace0\\ub2c8\\uc785\\ub2c8\\ub2e4. \\uc544\\uc8fc \\uac00\\ub054.. mysql\\uc6a9 root \\ud328\\uc2a4\\uc6cc\\ub4dc \\ubd84\\uc2e4\\ub85c \\uc7ac\\uc124\\uc815\\uc774 \\ud544\\uc694\\ud55c \\uacbd\\uc6b0 \\uc808\\ucc28\\ub97c \\uc548\\ub0b4\\ud574\\ub4dc\\ub9bd\\ub2c8\\ub2e4. perplexity\\uc5d0\\uc11c \\uc0dd\\uc131\\ud55c AI\\uc774\\ubbf8\\uc9c0 Mysql \\uc11c\\ube44\\uc2a4 \\uc885\\ub8cc $> killall mysqld Mysql \\uc635\\uc158 \\uc801\\uc6a9\\ud558\\uc5ec \\uc7ac\\uc2dc\\uc791 \\\/usr\\\/local\\\/mysql\\\/bin\\\/mysqld_safe ~-~-skip-grant-tables & Mysql root \\uc0ac\\uc6a9\\uc790 \\ub85c\\uadf8\\uc778 $> \\\/usr\\\/local\\\/mysql\\\/bin\\\/mysql -u root mysql * \\uc815\\uc0c1\\uc801\\uc73c\\ub85c \\uc218\\ud589\\ub420 \\uacbd\\uc6b0 \\ucf58\\uc194\\ud654\\uba74\\uc774 \\\"mysql>\\\" \\uc73c\\ub85c \\ubcc0\\uacbd\\ub420 \\uac83\\uc785\\ub2c8\\ub2e4. root \\ud328\\uc2a4\\uc6cc\\ub4dc \\uc7ac\\uc9c0\\uc815 (Mysql 5.7\\uc774\\ud558 \\ubc84\\uc804\\uc5d0\\uc11c \\uc0ac\\uc6a9\\ud558\\uc138\\uc694.) mysql> update user set password=password('\\ubcc0\\uacbd\\ud560\\ud328\\uc2a4\\uc6cc\\ub4dc\\uc785\\ub825') where user = 'root'; mysql> flush privileges; mysql> quit; \\uc9c0\\uc815\\ud55c \\ud328\\uc2a4\\uc6cc\\ub4dc \\uc785\\ub825\\ud558\\uc5ec mysql \\ub85c\\uadf8\\uc778 \\\/usr\\\/local\\\/mysql\\\/bin\\\/mysql -u root -p\",\"inLanguage\":\"ko-KR\",\"isPartOf\":{\"@id\":\"http:\\\/\\\/www.igoni.kr\\\/#website\"},\"breadcrumb\":{\"@id\":\"http:\\\/\\\/www.igoni.kr\\\/?p=1497#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\\\/d8d6543e-e263-4094-8a8d-280af440ea79.png\",\"@id\":\"http:\\\/\\\/www.igoni.kr\\\/?p=1497\\\/#mainImage\",\"width\":840,\"height\":627},\"primaryImageOfPage\":{\"@id\":\"http:\\\/\\\/www.igoni.kr\\\/?p=1497#mainImage\"},\"datePublished\":\"2026-05-13T23:29:10+09:00\",\"dateModified\":\"2026-05-13T23:31:37+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 root \uc0ac\uc6a9\uc790 \ud328\uc2a4\uc6cc\ub4dc \uc7ac\uc124\uc815 \ubc29\ubc95 - \uc774\uace4\uc544\uc774","description":"\uc548\ub155\ud558\uc138\uc694, \uace0\ub2c8\uc785\ub2c8\ub2e4. \uc544\uc8fc \uac00\ub054.. mysql\uc6a9 root \ud328\uc2a4\uc6cc\ub4dc \ubd84\uc2e4\ub85c \uc7ac\uc124\uc815\uc774 \ud544\uc694\ud55c \uacbd\uc6b0 \uc808\ucc28\ub97c \uc548\ub0b4\ud574\ub4dc\ub9bd\ub2c8\ub2e4. perplexity\uc5d0\uc11c \uc0dd\uc131\ud55c AI\uc774\ubbf8\uc9c0 Mysql \uc11c\ube44\uc2a4 \uc885\ub8cc $> killall mysqld Mysql \uc635\uc158 \uc801\uc6a9\ud558\uc5ec \uc7ac\uc2dc\uc791 \/usr\/local\/mysql\/bin\/mysqld_safe ~-~-skip-grant-tables & Mysql root \uc0ac\uc6a9\uc790 \ub85c\uadf8\uc778 $> \/usr\/local\/mysql\/bin\/mysql -u root mysql * \uc815\uc0c1\uc801\uc73c\ub85c \uc218\ud589\ub420 \uacbd\uc6b0 \ucf58\uc194\ud654\uba74\uc774 \"mysql>\" \uc73c\ub85c \ubcc0\uacbd\ub420 \uac83\uc785\ub2c8\ub2e4. root \ud328\uc2a4\uc6cc\ub4dc \uc7ac\uc9c0\uc815 (Mysql 5.7\uc774\ud558 \ubc84\uc804\uc5d0\uc11c \uc0ac\uc6a9\ud558\uc138\uc694.) mysql> update user set password=password('\ubcc0\uacbd\ud560\ud328\uc2a4\uc6cc\ub4dc\uc785\ub825') where user = 'root'; mysql> flush privileges; mysql> quit; \uc9c0\uc815\ud55c \ud328\uc2a4\uc6cc\ub4dc \uc785\ub825\ud558\uc5ec mysql \ub85c\uadf8\uc778 \/usr\/local\/mysql\/bin\/mysql -u root -p","canonical_url":"http:\/\/www.igoni.kr\/?p=1497","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"BlogPosting","@id":"http:\/\/www.igoni.kr\/?p=1497#blogposting","name":"Mysql root \uc0ac\uc6a9\uc790 \ud328\uc2a4\uc6cc\ub4dc \uc7ac\uc124\uc815 \ubc29\ubc95 - \uc774\uace4\uc544\uc774","headline":"Mysql root \uc0ac\uc6a9\uc790 \ud328\uc2a4\uc6cc\ub4dc \uc7ac\uc124\uc815 \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\/d8d6543e-e263-4094-8a8d-280af440ea79.png","width":840,"height":627},"datePublished":"2026-05-13T23:29:10+09:00","dateModified":"2026-05-13T23:31:37+09:00","inLanguage":"ko-KR","mainEntityOfPage":{"@id":"http:\/\/www.igoni.kr\/?p=1497#webpage"},"isPartOf":{"@id":"http:\/\/www.igoni.kr\/?p=1497#webpage"},"articleSection":"4. DBMS \uc815\ubcf4 \uae30\ub85d, Mysql&amp;MariaDB, grant-tables, mysql. root"},{"@type":"BreadcrumbList","@id":"http:\/\/www.igoni.kr\/?p=1497#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=379#listItem","name":"4. DBMS \uc815\ubcf4 \uae30\ub85d"}},{"@type":"ListItem","@id":"http:\/\/www.igoni.kr\/?cat=379#listItem","position":2,"name":"4. DBMS \uc815\ubcf4 \uae30\ub85d","item":"http:\/\/www.igoni.kr\/?cat=379","nextItem":{"@type":"ListItem","@id":"http:\/\/www.igoni.kr\/?cat=381#listItem","name":"Mysql&amp;MariaDB"},"previousItem":{"@type":"ListItem","@id":"http:\/\/www.igoni.kr#listItem","name":"Home"}},{"@type":"ListItem","@id":"http:\/\/www.igoni.kr\/?cat=381#listItem","position":3,"name":"Mysql&amp;MariaDB","item":"http:\/\/www.igoni.kr\/?cat=381","nextItem":{"@type":"ListItem","@id":"http:\/\/www.igoni.kr\/?p=1497#listItem","name":"Mysql root \uc0ac\uc6a9\uc790 \ud328\uc2a4\uc6cc\ub4dc \uc7ac\uc124\uc815 \ubc29\ubc95"},"previousItem":{"@type":"ListItem","@id":"http:\/\/www.igoni.kr\/?cat=379#listItem","name":"4. DBMS \uc815\ubcf4 \uae30\ub85d"}},{"@type":"ListItem","@id":"http:\/\/www.igoni.kr\/?p=1497#listItem","position":4,"name":"Mysql root \uc0ac\uc6a9\uc790 \ud328\uc2a4\uc6cc\ub4dc \uc7ac\uc124\uc815 \ubc29\ubc95","previousItem":{"@type":"ListItem","@id":"http:\/\/www.igoni.kr\/?cat=381#listItem","name":"Mysql&amp;MariaDB"}}]},{"@type":"Person","@id":"http:\/\/www.igoni.kr\/#person","name":"artop0420","image":{"@type":"ImageObject","@id":"http:\/\/www.igoni.kr\/?p=1497#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=1497#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=1497#webpage","url":"http:\/\/www.igoni.kr\/?p=1497","name":"Mysql root \uc0ac\uc6a9\uc790 \ud328\uc2a4\uc6cc\ub4dc \uc7ac\uc124\uc815 \ubc29\ubc95 - \uc774\uace4\uc544\uc774","description":"\uc548\ub155\ud558\uc138\uc694, \uace0\ub2c8\uc785\ub2c8\ub2e4. \uc544\uc8fc \uac00\ub054.. mysql\uc6a9 root \ud328\uc2a4\uc6cc\ub4dc \ubd84\uc2e4\ub85c \uc7ac\uc124\uc815\uc774 \ud544\uc694\ud55c \uacbd\uc6b0 \uc808\ucc28\ub97c \uc548\ub0b4\ud574\ub4dc\ub9bd\ub2c8\ub2e4. perplexity\uc5d0\uc11c \uc0dd\uc131\ud55c AI\uc774\ubbf8\uc9c0 Mysql \uc11c\ube44\uc2a4 \uc885\ub8cc $> killall mysqld Mysql \uc635\uc158 \uc801\uc6a9\ud558\uc5ec \uc7ac\uc2dc\uc791 \/usr\/local\/mysql\/bin\/mysqld_safe ~-~-skip-grant-tables & Mysql root \uc0ac\uc6a9\uc790 \ub85c\uadf8\uc778 $> \/usr\/local\/mysql\/bin\/mysql -u root mysql * \uc815\uc0c1\uc801\uc73c\ub85c \uc218\ud589\ub420 \uacbd\uc6b0 \ucf58\uc194\ud654\uba74\uc774 \"mysql>\" \uc73c\ub85c \ubcc0\uacbd\ub420 \uac83\uc785\ub2c8\ub2e4. root \ud328\uc2a4\uc6cc\ub4dc \uc7ac\uc9c0\uc815 (Mysql 5.7\uc774\ud558 \ubc84\uc804\uc5d0\uc11c \uc0ac\uc6a9\ud558\uc138\uc694.) mysql> update user set password=password('\ubcc0\uacbd\ud560\ud328\uc2a4\uc6cc\ub4dc\uc785\ub825') where user = 'root'; mysql> flush privileges; mysql> quit; \uc9c0\uc815\ud55c \ud328\uc2a4\uc6cc\ub4dc \uc785\ub825\ud558\uc5ec mysql \ub85c\uadf8\uc778 \/usr\/local\/mysql\/bin\/mysql -u root -p","inLanguage":"ko-KR","isPartOf":{"@id":"http:\/\/www.igoni.kr\/#website"},"breadcrumb":{"@id":"http:\/\/www.igoni.kr\/?p=1497#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\/d8d6543e-e263-4094-8a8d-280af440ea79.png","@id":"http:\/\/www.igoni.kr\/?p=1497\/#mainImage","width":840,"height":627},"primaryImageOfPage":{"@id":"http:\/\/www.igoni.kr\/?p=1497#mainImage"},"datePublished":"2026-05-13T23:29:10+09:00","dateModified":"2026-05-13T23:31:37+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 root \uc0ac\uc6a9\uc790 \ud328\uc2a4\uc6cc\ub4dc \uc7ac\uc124\uc815 \ubc29\ubc95 - \uc774\uace4\uc544\uc774","og:description":"\uc548\ub155\ud558\uc138\uc694, \uace0\ub2c8\uc785\ub2c8\ub2e4. \uc544\uc8fc \uac00\ub054.. mysql\uc6a9 root \ud328\uc2a4\uc6cc\ub4dc \ubd84\uc2e4\ub85c \uc7ac\uc124\uc815\uc774 \ud544\uc694\ud55c \uacbd\uc6b0 \uc808\ucc28\ub97c \uc548\ub0b4\ud574\ub4dc\ub9bd\ub2c8\ub2e4. perplexity\uc5d0\uc11c \uc0dd\uc131\ud55c AI\uc774\ubbf8\uc9c0 Mysql \uc11c\ube44\uc2a4 \uc885\ub8cc $&gt; killall mysqld Mysql \uc635\uc158 \uc801\uc6a9\ud558\uc5ec \uc7ac\uc2dc\uc791 \/usr\/local\/mysql\/bin\/mysqld_safe ~-~-skip-grant-tables &amp; Mysql root \uc0ac\uc6a9\uc790 \ub85c\uadf8\uc778 $&gt; \/usr\/local\/mysql\/bin\/mysql -u root mysql * \uc815\uc0c1\uc801\uc73c\ub85c \uc218\ud589\ub420 \uacbd\uc6b0 \ucf58\uc194\ud654\uba74\uc774 &quot;mysql&gt;&quot; \uc73c\ub85c \ubcc0\uacbd\ub420 \uac83\uc785\ub2c8\ub2e4. root \ud328\uc2a4\uc6cc\ub4dc \uc7ac\uc9c0\uc815 (Mysql 5.7\uc774\ud558 \ubc84\uc804\uc5d0\uc11c \uc0ac\uc6a9\ud558\uc138\uc694.) mysql&gt; update user set password=password('\ubcc0\uacbd\ud560\ud328\uc2a4\uc6cc\ub4dc\uc785\ub825') where user = 'root'; mysql&gt; flush privileges; mysql&gt; quit; \uc9c0\uc815\ud55c \ud328\uc2a4\uc6cc\ub4dc \uc785\ub825\ud558\uc5ec mysql \ub85c\uadf8\uc778 \/usr\/local\/mysql\/bin\/mysql -u root -p","og:url":"http:\/\/www.igoni.kr\/?p=1497","og:image":"http:\/\/word.igoni.kr\/wp-content\/uploads\/2026\/01\/cropped-j3fi6eistvc5ixa6lvm3ra-1.jpg","article:published_time":"2026-05-13T14:29:10+00:00","article:modified_time":"2026-05-13T14:31:37+00:00","twitter:card":"summary_large_image","twitter:title":"Mysql root \uc0ac\uc6a9\uc790 \ud328\uc2a4\uc6cc\ub4dc \uc7ac\uc124\uc815 \ubc29\ubc95 - \uc774\uace4\uc544\uc774","twitter:description":"\uc548\ub155\ud558\uc138\uc694, \uace0\ub2c8\uc785\ub2c8\ub2e4. \uc544\uc8fc \uac00\ub054.. mysql\uc6a9 root \ud328\uc2a4\uc6cc\ub4dc \ubd84\uc2e4\ub85c \uc7ac\uc124\uc815\uc774 \ud544\uc694\ud55c \uacbd\uc6b0 \uc808\ucc28\ub97c \uc548\ub0b4\ud574\ub4dc\ub9bd\ub2c8\ub2e4. perplexity\uc5d0\uc11c \uc0dd\uc131\ud55c AI\uc774\ubbf8\uc9c0 Mysql \uc11c\ube44\uc2a4 \uc885\ub8cc $&gt; killall mysqld Mysql \uc635\uc158 \uc801\uc6a9\ud558\uc5ec \uc7ac\uc2dc\uc791 \/usr\/local\/mysql\/bin\/mysqld_safe ~-~-skip-grant-tables &amp; Mysql root \uc0ac\uc6a9\uc790 \ub85c\uadf8\uc778 $&gt; \/usr\/local\/mysql\/bin\/mysql -u root mysql * \uc815\uc0c1\uc801\uc73c\ub85c \uc218\ud589\ub420 \uacbd\uc6b0 \ucf58\uc194\ud654\uba74\uc774 &quot;mysql&gt;&quot; \uc73c\ub85c \ubcc0\uacbd\ub420 \uac83\uc785\ub2c8\ub2e4. root \ud328\uc2a4\uc6cc\ub4dc \uc7ac\uc9c0\uc815 (Mysql 5.7\uc774\ud558 \ubc84\uc804\uc5d0\uc11c \uc0ac\uc6a9\ud558\uc138\uc694.) mysql&gt; update user set password=password('\ubcc0\uacbd\ud560\ud328\uc2a4\uc6cc\ub4dc\uc785\ub825') where user = 'root'; mysql&gt; flush privileges; mysql&gt; quit; \uc9c0\uc815\ud55c \ud328\uc2a4\uc6cc\ub4dc \uc785\ub825\ud558\uc5ec mysql \ub85c\uadf8\uc778 \/usr\/local\/mysql\/bin\/mysql -u root -p","twitter:image":"http:\/\/word.igoni.kr\/wp-content\/uploads\/2026\/01\/cropped-j3fi6eistvc5ixa6lvm3ra-1.jpg"},"aioseo_meta_data":{"post_id":"1497","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:29:10","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=379\" title=\"4. DBMS \uc815\ubcf4 \uae30\ub85d\">4. DBMS \uc815\ubcf4 \uae30\ub85d<\/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=381\" title=\"Mysql&amp;MariaDB\">Mysql&amp;MariaDB<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\tMysql root \uc0ac\uc6a9\uc790 \ud328\uc2a4\uc6cc\ub4dc \uc7ac\uc124\uc815 \ubc29\ubc95\n\t\t<\/span><\/div>","aioseo_breadcrumb_json":[{"label":"Home","link":"http:\/\/www.igoni.kr"},{"label":"4. DBMS \uc815\ubcf4 \uae30\ub85d","link":"http:\/\/www.igoni.kr\/?cat=379"},{"label":"Mysql&amp;MariaDB","link":"http:\/\/www.igoni.kr\/?cat=381"},{"label":"Mysql root \uc0ac\uc6a9\uc790 \ud328\uc2a4\uc6cc\ub4dc \uc7ac\uc124\uc815 \ubc29\ubc95","link":"http:\/\/www.igoni.kr\/?p=1497"}],"_links":{"self":[{"href":"http:\/\/www.igoni.kr\/index.php?rest_route=\/wp\/v2\/posts\/1497","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=1497"}],"version-history":[{"count":3,"href":"http:\/\/www.igoni.kr\/index.php?rest_route=\/wp\/v2\/posts\/1497\/revisions"}],"predecessor-version":[{"id":1505,"href":"http:\/\/www.igoni.kr\/index.php?rest_route=\/wp\/v2\/posts\/1497\/revisions\/1505"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/www.igoni.kr\/index.php?rest_route=\/wp\/v2\/media\/1499"}],"wp:attachment":[{"href":"http:\/\/www.igoni.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1497"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.igoni.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1497"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.igoni.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1497"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}