{"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\">\n<colgroup>\n<col style=\"width: 100.015%;\" \/><\/colgroup>\n<tbody>\n<tr>\n<td><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1499\" src=\"http:\/\/www.igoni.kr\/wp-content\/uploads\/2026\/05\/d8d6543e-e263-4094-8a8d-280af440ea79.png\" alt=\"\" width=\"840\" height=\"627\" srcset=\"http:\/\/www.igoni.kr\/wp-content\/uploads\/2026\/05\/d8d6543e-e263-4094-8a8d-280af440ea79.png 840w, http:\/\/www.igoni.kr\/wp-content\/uploads\/2026\/05\/d8d6543e-e263-4094-8a8d-280af440ea79-300x224.png 300w, http:\/\/www.igoni.kr\/wp-content\/uploads\/2026\/05\/d8d6543e-e263-4094-8a8d-280af440ea79-768x573.png 768w\" sizes=\"auto, (max-width: 840px) 100vw, 840px\" \/><\/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<li>Mysql \uc11c\ube44\uc2a4 \uc885\ub8cc\n<pre><code class=\"language-Python\">$&gt;\u00a0killall\u00a0mysqld<\/code><\/pre>\n<\/li>\n<li>Mysql \uc635\uc158 \uc801\uc6a9\ud558\uc5ec \uc7ac\uc2dc\uc791\n<pre><code class=\"language-Python\">\/usr\/local\/mysql\/bin\/mysqld_safe\u00a0~-~-skip-grant-tables\u00a0&amp;\r\n<\/code><\/pre>\n<div>\n<div class=\"box\">\n<div class=\"code\"><\/div>\n<\/div>\n<\/div>\n<\/li>\n<li>Mysql root \uc0ac\uc6a9\uc790 \ub85c\uadf8\uc778\n<pre><code class=\"language-Python\">$&gt; \/usr\/local\/mysql\/bin\/mysql\u00a0-u\u00a0root\u00a0mysql\r\n*\u00a0\uc815\uc0c1\uc801\uc73c\ub85c\u00a0\uc218\ud589\ub420\u00a0\uacbd\uc6b0\u00a0\ucf58\uc194\ud654\uba74\uc774\u00a0\"mysql&gt;\"\u00a0\uc73c\ub85c\u00a0\ubcc0\uacbd\ub420\u00a0\uac83\uc785\ub2c8\ub2e4.<\/code><\/pre>\n<\/li>\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\u00a0user\u00a0set\u00a0password=password('\ubcc0\uacbd\ud560\ud328\uc2a4\uc6cc\ub4dc\uc785\ub825')\u00a0where\u00a0user\u00a0=\u00a0'root';\r\nmysql&gt; flush\u00a0privileges;\r\nmysql&gt; quit;<\/code><\/pre>\n<div><\/div>\n<\/li>\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\u00a0-u\u00a0root\u00a0-p\u00a0\u00a0\u00a0<\/code><\/pre>\n<p>&nbsp;<\/li>\n<\/ol>\n","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>\n","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":[],"_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}]}}