{"id":266,"date":"2016-02-02T11:41:48","date_gmt":"2016-02-02T02:41:48","guid":{"rendered":"http:\/\/www.onepage.co.kr\/wordpress\/?p=266"},"modified":"2016-04-01T00:51:47","modified_gmt":"2016-03-31T15:51:47","slug":"lost-windows-mysql-root-password","status":"publish","type":"post","link":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/2016\/02\/02\/lost-windows-mysql-root-password\/","title":{"rendered":"lost windows mysql root password"},"content":{"rendered":"

\u200b<\/a><\/p>\n

Windows MySQL root \ud328\uc2a4\uc6cc\ub4dc \ubd84\uc2e4\uc2dc<\/div>\n
<\/div>\n
1. MySQL \ud504\ub85c\uc138\uc2a4 \uc885\ub8cc<\/div>\n
[\uc2dc\uc791] – [\uc2e4\ud589] – ‘services.msc’ \uc785\ub825 \ud6c4 \uc5d4\ud130<\/div>\n
> mysql \uad00\ub828 \ud504\ub85c\uadf8\ub7a8\uc744 \uc885\ub8cc\ud569\ub2c8\ub2e4.<\/div>\n
<\/div>\n
2.\uc778\uc99d\uc81c\uc678\ud55c MySQL \ub370\ubaac \uc2e4\ud589<\/div>\n
# cd “C:Program FilesMySQLMySQL Server 5.5bin”<\/div>\n
<\/div>\n
3. \ube44\ubc88\uc5c6\uc774 \uc811\uc18d\ud6c4 mysql DB\uc758 user \ud14c\uc774\ube14\uc5d0\uc11c root \ud328\uc2a4\uc6cc\ub4dc \ubcc0\uacbd<\/div>\n
# mysqld –skip-grant<\/div>\n
\uc774\ud6c4 \uc544\ubb34\ub7f0 \ud0a4\uac00 \uba39\uc9c0 \uc54a\uc73c\uba70 \ucc3d\uc774 \uba48\ucd98\uac83\ucc98\ub7fc \ubcf4\uc785\ub2c8\ub2e4.<\/div>\n
\ub2e4\ub978 \uba85\ub839\ud504\ub86c\ud504\ud2b8 \ucc3d\uc744 \ub744\uc6cc mysql\uc5d0 \ub85c\uadf8\uc778\ud569\ub2c8\ub2e4.<\/div>\n
# mysql -u root -p<\/div>\n
mysql> use mysql;<\/div>\n
mysql> update user set password=password(‘new password’) where user=’root’;<\/div>\n
mysql> flush privileges;<\/div>\n
mysql> quit<\/div>\n
<\/div>\n
4. \uc815\uc0c1\uc801\uc778 MySQL \ud504\ub85c\uadf8\ub7a8 \uc2e4\ud589<\/div>\n
\uc5f4\ub824\uc9c4 \uba85\ub839\ud504\ub86c\ud504\ud2b8\ub97c \ub2e4 \uc885\ub8cc\ud558\uace0 services.msc \uc758 MySQL \uad00\ub828 \ud504\ub85c\uadf8\ub7a8\uc744 \uc2dc\uc791\ud569\ub2c8\ub2e4.<\/div>\n
<\/div>\n
\\<\/div>\n
<\/div>\n
<\/div>\n
\ub9c8\ub9ac\uc544 \ub370\uc774\ud0c0 \ud30c\uc77c\ub85c \ubcf5\uad6c\ud558\uae30<\/div>\n
<\/div>\n
Mariadb 5.5.37 \uc744 \uc801\ub2f9\ud55c \uc704\uce58\uc5d0 \uc124\uce58\ud55c\ub2e4. (heidisql \ub3c4 \uc124\uce58)<\/div>\n
<\/div>\n
services.msc — mariadb \uc11c\ube44\uc2a4\ub97c \uc911\uc9c0\uc2dc\ud0a8\ub2e4.<\/div>\n
<\/div>\n
\uc124\uce58\ub41c data \ud3f4\ub354\uc5d0 ibdata1 \ud30c\uc77c, mysql, performance_schema, mypoll data base \ud3f4\ub354\ub97c \ub36e\uc5b4\uc4f4\ub2e4.<\/div>\n
<\/div>\n
\ud544\uc694\uc2dc \uba3c\uc800 \uc124\uce58\ub41c \ub274 mysql \ud3f4\ub354\ub0b4\uc758 user \uad00\ub828\ud30c\uc77c\uc744 \ubc31\uc5c5 \ud6c4 mysql \ud3f4\ub354\uc5d0 \ub2e4\uc2dc \ub36e\uc5b4\uc4f4\ub2e4.<\/div>\n
<\/div>\n
mariadb \uc11c\ube44\uc2a4\ub97c \uc7ac\uc2dc\uc791\ud55c\ub2e4.<\/div>\n
<\/div>\n
<\/div>\n
Microsoft Visual C++ 2010 Redistributable Package (x86) \uc744 \uc124\uce58 \ud6c4 (\uc124\uce58 \uc548\ud558\uba74 \uc624\ub958\ub0a8)<\/div>\n
<\/div>\n
mysql odbc driver 5.2.7\uc744 \uc124\uce58\ud55c\ub2e4.<\/div>\n
<\/div>\n
\uc7ac\ubd80\ud305\uc740 \ud544\uc694\uc5c6\uc74c.<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
\ud504\ub85c\uc2dc\uc838\ub098 \ud391\uc158 \uc911 \uc815\uc758\uc790\uac00 ‘ root@% ‘ \uc778 \uacbd\uc6b0\ub294 root anywhere \uc0ac\uc6a9\uc790\ub97c \ucd94\uac00\ud55c\ub2e4. \ub610\ub294 ‘mypoll@%’\ub85c \ubcc0\uacbd\ud55c\ub2e4.<\/div>\n","protected":false},"excerpt":{"rendered":"

\u200b Windows MySQL root \ud328\uc2a4\uc6cc\ub4dc \ubd84\uc2e4\uc2dc 1. MySQL \ud504\ub85c\uc138\uc2a4 \uc885\ub8cc [\uc2dc\uc791] – [\uc2e4\ud589] – ‘services.msc’ \uc785\ub825 \ud6c4 \uc5d4\ud130 > mysql \uad00\ub828 \ud504\ub85c\uadf8\ub7a8\uc744 \uc885\ub8cc\ud569\ub2c8\ub2e4. 2.\uc778\uc99d\uc81c\uc678\ud55c MySQL \ub370\ubaac \uc2e4\ud589 # cd “C:Program FilesMySQLMySQL Server 5.5bin” 3. \ube44\ubc88\uc5c6\uc774 \uc811\uc18d\ud6c4 mysql DB\uc758 user \ud14c\uc774\ube14\uc5d0\uc11c root \ud328\uc2a4\uc6cc\ub4dc \ubcc0\uacbd # mysqld –skip-grant \uc774\ud6c4 \uc544\ubb34\ub7f0 \ud0a4\uac00 \uba39\uc9c0 \uc54a\uc73c\uba70 \ucc3d\uc774 \uba48\ucd98\uac83\ucc98\ub7fc \ubcf4\uc785\ub2c8\ub2e4. \ub2e4\ub978 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9,3],"tags":[],"class_list":["post-266","post","type-post","status-publish","format-standard","hentry","category-general","category-mariadb-mysql"],"_links":{"self":[{"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/posts\/266","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/comments?post=266"}],"version-history":[{"count":1,"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/posts\/266\/revisions"}],"predecessor-version":[{"id":267,"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/posts\/266\/revisions\/267"}],"wp:attachment":[{"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/media?parent=266"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/categories?post=266"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/tags?post=266"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}