{"id":1944,"date":"2026-04-17T23:33:32","date_gmt":"2026-04-17T23:33:32","guid":{"rendered":"http:\/\/jcduo.kr\/?p=1944"},"modified":"2026-04-17T23:33:32","modified_gmt":"2026-04-17T23:33:32","slug":"mysql-password-%ec%b4%88%ea%b8%b0%ed%99%94-%eb%b0%a9%eb%b2%95","status":"publish","type":"post","link":"https:\/\/jcduo.kr\/?p=1944","title":{"rendered":"mysql password \ucd08\uae30\ud654 \ubc29\ubc95"},"content":{"rendered":"\n<pre class=\"wp-block-preformatted\">mysql \uc744 workbench \ub85c \uc608\uc804\uc5d0 \uc0ac\uc6a9\ud558\ub2e4\uac00 supabase\ub97c \uc0ac\uc6a9\ud558\uac8c \ub418\uba74\uc11c mysql \uc744 \uc0ac\uc6a9 \uc548\ud55c\uc9c0 \uc5c4\uccad \uc624\ub79c \uc2dc\uac04\uc774 \uc9c0\ub0ac\uc2b5\ub2c8\ub2e4.\nmysql \uc744 \uc0ac\uc6a9\ud55c \ud504\ub85c\uc81d\ud2b8\ub97c \ud558\ub098 \uc2dc\uc791\ud558\uac8c \ub420 \uc77c\uc774 \uc788\uc5b4 \ub2e4\uc2dc \ud0a4\ub824\uace0 \ud558\ub294 \uc21c\uac04...! \uc81c\uac00 \uc0dd\uac01\ud588\ub358 \ube44\ubc00\ubc88\ud638\uac00 \uc544\ub2c8\ub354\ub77c\uad6c\uc694.. \uc5b4\uca54 \uc218 \uc5c6\uc774 \ube44\ubc00\ubc88\ud638 \uc790\uccb4\ub97c \uc7ac\uc124\uc815\ud574\uc57c \ud558\ub294 \uacbd\uc6b0\uac00 \uc0dd\uaca8, \uc81c \uacbd\ud5d8\uc744 \uacf5\uc720\ub4dc\ub9ac\ub824\uace0 \ud569\ub2c8\ub2e4 (macbook \uae30\uc900)\n&nbsp;\n<code> mysql -u root -p<\/code>\n&nbsp;\n\uc774 \ucf54\ub4dc\ub85c mysql \uc744 \uc0ac\uc6a9\ud558\ub824\uace0 \ud560 \ub54c\uc5d0 \ube44\ubc88\uc744 \uae4c\uba39\uc5b4\uc11c \uc7ac\uc124\uc815\ud558\ub294 \ub0b4\uc6a9\uc785\ub2c8\ub2e4\n&nbsp;\n\uc77c\ub2e8 \uc544\ub798\uc758 \uba85\ub839\uc5b4\ub97c \uc2e4\ud589\ud574 mysql \uad00\ub828 \ud504\ub85c\uc138\uc2a4\ub97c \uc885\ub8cc\ud574\uc90d\ub2c8\ub2e4\n<code>sudo killall -9 mysqld_safe\nsudo killall -9 mysqld<\/code>\n&nbsp;\n\uadf8\ub7f0 \ub2e4\uc74c, \uc544\ub798\uc758 \uba85\ub839\uc5b4\ub97c \uc2e4\ud589\ud574 mysqld_safe \uc758 \uacbd\ub85c\ub97c \ud655\uc778\ud569\ub2c8\ub2e4\n<code>find \/usr\/local -name \"mysqld_safe\"<\/code>\n&nbsp;\n<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/blog.kakaocdn.net\/dna\/b85sWr\/btsPahxD5uS\/AAAAAAAAAAAAAAAAAAAAAAb16rzs6oCVR7PBCKDPm8hxCEVWcwlNt7SQDvdMFIM1\/img.png?credential=yqXZFxpELC7KVnFOS48ylbz2pIh7yKj8&amp;expires=1777561199&amp;allow_ip=&amp;allow_referer=&amp;signature=Ct7LC3CcWNgIuy%2BkjuPeNJR4IG4%3D\" srcset=\"https:\/\/img1.daumcdn.net\/thumb\/R1280x0\/?scode=mtistory2&amp;fname=https%3A%2F%2Fblog.kakaocdn.net%2Fdna%2Fb85sWr%2FbtsPahxD5uS%2FAAAAAAAAAAAAAAAAAAAAAAb16rzs6oCVR7PBCKDPm8hxCEVWcwlNt7SQDvdMFIM1%2Fimg.png%3Fcredential%3DyqXZFxpELC7KVnFOS48ylbz2pIh7yKj8%26expires%3D1777561199%26allow_ip%3D%26allow_referer%3D%26signature%3DCt7LC3CcWNgIuy%252BkjuPeNJR4IG4%253D\" width=\"998\" height=\"141\">\n\n&nbsp;\n\uc704 \uc0ac\uc9c4\uacfc \uac19\uc740 \uacb0\uacfc\uac00 \ub098\uc654\uc744 \ub54c\uc5d0 \ub9e8 \ucc98\uc74c\uc5d0 \/usr\/local\/mysql-9.0.1-macos14-arm64... \uc774 \ubd80\ubd84\uc744 \uadf8\ub300\ub85c \ubcf5\uc0ac\ud574\uc11c&nbsp;\n<code>sudo \/usr\/local\/mysql-9.0.1-macos14-arm64\/bin\/mysqld_safe --skip-grant-tables &gt; \/tmp\/mysql.log 2&gt;&amp;1 &amp;<\/code>\n\uc704\uc640 \uac19\uc774 \uba85\ub839\uc5b4\ub97c \uc2e4\ud589\ud569\ub2c8\ub2e4.\n&nbsp;\n\uba85\ub839\uc5b4 \uc804\uccb4 \uc5ed\ud560\n\n\n\n\uad00\ub9ac\uc790 \uad8c\ud55c\uc73c\ub85c MySQL \uc11c\ubc84\ub97c \uc778\uc99d \uc5c6\uc774 \uc2e4\ud589\uc2dc\ud0a4\uace0, \uc11c\ubc84 \ucd9c\ub825 \ub85c\uadf8\ub97c \ud30c\uc77c\uc5d0 \uae30\ub85d\ud558\uba74\uc11c \ubc31\uadf8\ub77c\uc6b4\ub4dc\uc5d0\uc11c \uc2e4\ud589\n\n\n\n&nbsp;\n\uc774 \ucf54\ub4dc\ub85c \uad8c\ud55c \uac80\uc0ac \uc5c6\uc774 \ubc14\ub85c \uc2dc\uc791\ud560 \uc218 \uc788\ub3c4\ub85d \ud569\ub2c8\ub2e4.\n<strong>\uc774 \uc124\uc815\uc740 \ubcf4\uc548\uc744 \uc791\uc0b4\ub0b4\ub294 \uc124\uc815\uc774\ubbc0\ub85c, \ube44\ubc00\ubc88\ud638 \uc7ac\uc124\uc815 \ud6c4\uc5d0 \ubc18\ub4dc\uc2dc \uc885\ub8cc\ud574\uc57c\ud569\ub2c8\ub2e4!! \ub4a4\uc5d0 \ub2e4\uc2dc \ub2e4\ub8f0\uac8c\uc694<\/strong>\n&nbsp;\n\uc774\ud6c4\uc5d0 mysql \uc744 \uc2e4\ud589\ud574 \ubd05\ub2c8\ub2e4.\n<code>mysql -u root<\/code>\n&nbsp;\n\uc774\ub807\uac8c \ud558\uba74 \uc11c\ubc84\uac00 \uc778\uc99d \uc694\uad6c\ub97c \ud558\uc9c0 \uc54a\uc73c\ub2c8, \ube44\ubc00\ubc88\ud638\ub97c \uae4c\uba39\uc5b4\ub3c4 \ubc14\ub85c \uc811\uc18d\uc744 \ud558\uac8c \ub418\ub294 \uac83\uc785\ub2c8\ub2e4.\n&nbsp;\nmysql \uc774 \uc2e4\ud589\ub418\uba74 \uc811\uc18d\uc744 \ud588\uc73c\ub2c8 \ucf58\uc194\uc774 \uc774\ub807\uac8c \ubc14\ub00c\uac8c \ub420 \uac83\uc785\ub2c8\ub2e4\n[mysql&gt;&nbsp;<br><br>\uc5ec\uae30\uc5d0&nbsp;\n<code>FLUSH PRIVILEGES;<\/code>\n\ud574\ub2f9 \uba85\ub839\uc5b4\ub85c \uc9c0\uae08 \uc788\ub358 \ube44\ubc88 \uc124\uc815\uc744 \ubc84\ub9ac\uace0\n&nbsp;\n<code>ALTER USER 'root'@'localhost' IDENTIFIED By \ub0b4\uac00\uc124\uc815\ud558\uace0\uc2f6\uc740\ube44\ubc00\ubc88\ud638;<\/code>\n&nbsp;\n\uc5ec\uae30\uc11c \ub0b4\uac00\uc124\uc815\ud558\uace0\uc2f6\uc740\ube44\ubc00\ubc88\ud638 \ubd80\ubd84\uc5d0 'password-1234' \uc774\ub7f0 \uc2dd\uc73c\ub85c '' \ub85c \ubb36\uc5b4\uc57c \ub429\ub2c8\ub2e4\n&nbsp;\n\uc774\ub807\uac8c \ud55c \ud6c4 mysql \uc11c\ubc84\uc5d0\uc11c&nbsp;\nexit \uc744 \uc785\ub825\ud574 \ub098\uc628 \ud6c4&nbsp;\n&nbsp;\n<code>mysql -u root -p<\/code>\n\ub97c \uc785\ub825\ud558\uace0 \ubc29\uae08 \uc124\uc815\ud55c \ube44\ubc00\ubc88\ud638\ub97c \uc785\ub825\ud569\ub2c8\ub2e4.\n&nbsp;\n&nbsp;\n\uc774\ub7ec\uba74 \ub098\ub294 \ube44\ubc00\ubc88\ud638\ub97c \uae4c\uba39\uc5b4\ub3c4 \uc7ac\uc124\uc815\uc744 \ud588\uc2b5\ub2c8\ub2e4.\n\ud558\uc9c0\ub9cc \uc544\uae4c&nbsp;\n<code>sudo \/usr\/local\/mysql-9.0.1-macos14-arm64\/bin\/mysqld_safe --skip-grant-tables &gt; \/tmp\/mysql.log 2&gt;&amp;1 &amp;<\/code>\n&nbsp;\n\uc774 \uba85\ub839\uc5b4\ub85c \ubcf4\uc548\uc124\uc815\uc744 \uc791\uc0b4\ub0c8\uc8e0, \uc774\uc81c \uc815\uc0c1\ubaa8\ub4dc\ub85c \ubcf5\uad6c\ub97c \ud574\uc57c \ud569\ub2c8\ub2e4\n&nbsp;\n<strong>1\ub2e8\uacc4: skip-grant \ubaa8\ub4dc \uc885\ub8cc<\/strong>\n<code>mysqladmin -u root -p shutdown<\/code>\n&nbsp;\n<strong>2\ub2e8\uacc4: MySQL \uc11c\ubc84\ub97c \uc815\uc0c1 \ubaa8\ub4dc\ub85c \ub2e4\uc2dc \uc2dc\uc791<\/strong>\n<code>sudo \/usr\/local\/mysql-9.0.1-macos14-arm64\/support-files\/mysql.server start<\/code>\n&nbsp;\n<strong>3\ub2e8\uacc4: \uc811\uc18d \ud655\uc778<\/strong>\n<code>mysql -u root -p<\/code>\n&nbsp;\n&nbsp;\n\ubc14\uafe8\ub358 \ube44\ubc88\uc744 \uc785\ub825\ud574\uc11c \uc811\uc18d \ub418\ub294\uc9c0 \ud655\uc778\ud558\uba74 \ub05d!<\/pre>\n\n\n\n<p>\ucd9c\ucc98: <a href=\"https:\/\/kyurasi.tistory.com\/entry\/MYSQL-%EB%B9%84%EB%B0%80%EB%B2%88%ED%98%B8-%EA%B9%8C%EB%A8%B9%EC%97%88%EC%9D%84-%EB%95%8C-%EC%9E%AC%EC%84%A4%EC%A0%95%ED%95%98%EA%B8%B0-%EB%B3%80%EA%B2%BD%ED%95%98%EA%B8%B0\">https:\/\/kyurasi.tistory.com\/entry\/MYSQL-\ube44\ubc00\ubc88\ud638-\uae4c\uba39\uc5c8\uc744-\ub54c-\uc7ac\uc124\uc815\ud558\uae30-\ubcc0\uacbd\ud558\uae30<\/a> [Junmannn\uc758 Archive:\ud2f0\uc2a4\ud1a0\ub9ac]<\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>mysql \uc744 workbench \ub85c \uc608\uc804\uc5d0 \uc0ac\uc6a9\ud558\ub2e4\uac00 supabase\ub97c \uc0ac\uc6a9\ud558\uac8c \ub418\uba74\uc11c mysql \uc744 \uc0ac\uc6a9 \uc548\ud55c\uc9c0 \uc5c4\uccad \uc624\ub79c \uc2dc\uac04\uc774 \uc9c0\ub0ac\uc2b5\ub2c8\ub2e4. mysql \uc744 \uc0ac\uc6a9\ud55c \ud504\ub85c\uc81d\ud2b8\ub97c \ud558\ub098 \uc2dc\uc791\ud558\uac8c \ub420 \uc77c\uc774 \uc788\uc5b4 \ub2e4\uc2dc \ud0a4\ub824\uace0 \ud558\ub294 \uc21c\uac04&#8230;! \uc81c\uac00 \uc0dd\uac01\ud588\ub358 \ube44\ubc00\ubc88\ud638\uac00 \uc544\ub2c8\ub354\ub77c\uad6c\uc694.. \uc5b4\uca54 \uc218 \uc5c6\uc774 \ube44\ubc00\ubc88\ud638 \uc790\uccb4\ub97c \uc7ac\uc124\uc815\ud574\uc57c \ud558\ub294 \uacbd\uc6b0\uac00 \uc0dd\uaca8, \uc81c \uacbd\ud5d8\uc744 \uacf5\uc720\ub4dc\ub9ac\ub824\uace0 \ud569\ub2c8\ub2e4 (macbook \uae30\uc900) &nbsp; mysql -u root -p &nbsp; &hellip; <a href=\"https:\/\/jcduo.kr\/?p=1944\" class=\"more-link\"><span class=\"screen-reader-text\">mysql password \ucd08\uae30\ud654 \ubc29\ubc95<\/span> \ub354\ubcf4\uae30<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-1944","post","type-post","status-publish","format-standard","hentry","category-daily_routine"],"_links":{"self":[{"href":"https:\/\/jcduo.kr\/index.php?rest_route=\/wp\/v2\/posts\/1944","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jcduo.kr\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jcduo.kr\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jcduo.kr\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jcduo.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1944"}],"version-history":[{"count":1,"href":"https:\/\/jcduo.kr\/index.php?rest_route=\/wp\/v2\/posts\/1944\/revisions"}],"predecessor-version":[{"id":1945,"href":"https:\/\/jcduo.kr\/index.php?rest_route=\/wp\/v2\/posts\/1944\/revisions\/1945"}],"wp:attachment":[{"href":"https:\/\/jcduo.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1944"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jcduo.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1944"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jcduo.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1944"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}