MySQL\uc5d0\uc11c \uc0ac\uc6a9\ud558\ub294 root \ud328\uc2a4\uc6cc\ub4dc\ub97c \ubd84\uc2e4\ud588\uc744\ub54c, \ub2e4\uc74c\uacfc \uac19\uc740 \ubc29\ubc95\uc73c\ub85c \ubc14\uafc0 \uc218 \uc788\ub2e4.<\/p>\n
1. MySQL \ub370\ubaac\uc744 \uc911\uc9c0 \uc2dc\ud0a8\ub2e4.<\/p>\n
[root@localhost mysql]# killall mysqld (\ub610\ub294 pkill -9 mysqld)<\/p>\n
2. –skip-grant \uc635\uc158\uc744 \uc8fc\uc5b4\uc11c mysql \ub370\ubaac\uc740 \ub2e4\uc2dc \uc2e4\ud589\uc2dc\ud0a8\ub2e4.<\/p>\n
[root@localhost mysql]# \/usr\/local\/mysql\/bin\/safe_mysqld –skip-grant &
\nStarting mysqld daemon with databases from \/usr\/local\/mysql\/var<\/p>\n
3. \ud328\uc2a4\uc6cc\ub4dc \uc5c6\uc774 root \uacc4\uc815\uc73c\ub85c mysql\uc5d0 \uc811\uc18d\ud55c\ub2e4.mysql%ed%8c%a8%ec%8a%a4%ec%9b%8c%eb%93%9c-%eb%b3%80%ea%b2%bd-1<\/p>\n
[root@localhost mysql]# .\/bin\/mysql -u root mysql<\/p>\n
Reading table information for completion of table and column names
\nYou can turn off this feature to get a quicker startup with -A<\/p>\n
Welcome to the MySQL monitor.\u00a0\u00a0Commands end with ; or g.
\nYour MySQL connection id is 970 to server version: 3.22.32<\/p>\n
Type ‘help’ for help.<\/p>\n
mysql><\/p>\n
4. mysql> \ud504\ub86c\ud504\ud2b8\uc5d0\uc11c update \ucffc\ub9ac\ubb38\uc73c\ub85c \ud328\uc2a4\uc6cc\ub4dc\ub97c \uc7ac\uc124\uc815 \ud55c\ub2e4.<\/p>\n
mysql> UPDATE user SET Password=PASSWORD(‘newpasswd’) WHERE user=’root’;<\/p>\n
Query OK,\u00a0\u00a01\u00a0\u00a0row affected (0.01 sec)
\nRow matched:2\u00a0\u00a0 Changed:\u00a0\u00a01\u00a0\u00a0Warnungs:\u00a0\u00a00<\/p>\n
5. \ubcc0\uacbd\uc0ac\ud56d\uc744\u00a0\uc801\uc6a9\uc2dc\ud0a8\ub2e4.<\/p>\n
mysql> FLUSH PRIVILEGES;<\/p>\n
Query OK, 0 rows affected (0.05 sec)<\/p>\n
6. mysql> \ud504\ub86c\ud504\ud2b8\uc5d0\uc11c \ube60\uc838 \ub098\uc628\ub2e4.<\/p>\n
mysql> quit<\/p>\n
Bye<\/p>\n
7. mysql \ub370\ubaac\uc744 \uc7ac\uc2dc\uc791 \ud55c\ub2e4.<\/p>\n
[root@localhost mysql]# killall mysqld (\ub610\ub294 pkill -9 mysqld)
\n[root@localhost mysql]# \/usr\/local\/mysql\/bin\/safe_mysqld &
\n[1] 10008
\n[root@localhost mysql]# Starting mysqld daemon with databases from \/usr\/local\/mysql\/data<\/p>\n
8. \uc5c5\ub370\uc774\ud2b8\ud55c \ud328\uc2a4\uc6cc\ub4dc\ub85c mysql\uc5d0 \uc811\uc18d\ud55c\ub2e4.<\/p>\n
[root@localhost mysql]# \/usr\/local\/mysql\/bin\/mysql -u root -p
\nEnter password: ******
\nReading table information for completion of table and column names
\nYou can turn off this feature to get a quicker startup with -A<\/p>\n
Welcome to the MySQL monitor.\u00a0\u00a0Commands end with ; or g.
\nYour MySQL connection id is 1 to server version: 3.22.32<\/p>\n
Type ‘help’ for help.<\/p>\n
mysql><\/p>\n
<\/p>\n
====================================================
\n#!\/bin\/sh
\necho “mysql \ub370\ubaac\uc744 \uc911\uc9c0 \ud569\ub2c8\ub2e4”
\npkill mysqld
\nsleep 4
\necho “mysql \ub370\ubaac\uc744 \uc2dc\uc791 \ud569\ub2c8\ub2e4”
\n\/usr\/local\/mysql\/bin\/mysqld_safe –skip-grant &
\nsleep 4
\necho ” ”
\necho “mysql \ud328\uc2a4\uc6cc\ub4dc\ub97c \ubcc0\uacbd\ud569\ub2c8\ub2e4.”
\necho ” ”
\necho “\ubcc0\uacbd\ud560 mysql root \ud328\uc2a4\uc6cc\ub4dc\ub97c \uc785\ub825\ud558\uc2dc\uc624”
\nread newpassword
\necho “use mysql;
\nupdate user set password=password(‘$newpassword’) where user=’root’;
\nflush privileges;” > insert_query
\necho ” ”
\n\/usr\/local\/mysql\/bin\/mysql -u root < insert_query
\nrm -rf insert_query
\necho “mysql \ub370\ubaac\uc744 \uc911\uc9c0 \ud569\ub2c8\ub2e4”
\npkill mysqld
\nsleep 4
\necho “mysql \ub370\ubaac\uc744 \uc2dc\uc791 \ud569\ub2c8\ub2e4”
\n\/usr\/local\/mysql\/bin\/mysqld_safe &
\nsleep 4
\necho ” ”
\necho “mysql \ud328\uc2a4\uc6cc\ub4dc\uac00 $newpassword\ub85c \ubcc0\uacbd\ub418\uc5c8\uc2b5\ub2c8\ub2e4”
\necho ” ”<\/p>\n
====================================================<\/p>\n
====================================================
\n#!\/bin\/sh
\necho ” ”
\necho “\ud604\uc7ac\uc758 mysql root \ud328\uc2a4\uc6cc\ub4dc\ub97c \uc785\ub825\ud558\uc2dc\uc624”
\necho ” ”
\necho “mysql root \ud328\uc2a4\uc6cc\ub4dc\uac00 \uc124\uc815\ub418\uc5b4 \uc788\uc9c0 \uc54a\uc73c\uba74 \uadf8\ub0e5 enter\ub97c \uc785\ub825”
\nread oldpassword
\necho ” ”
\necho “\ubcc0\uacbd\ud560 mysql root \ud328\uc2a4\uc6cc\ub4dc\ub97c \uc785\ub825\ud558\uc2dc\uc624”
\nread newpassword
\necho “use mysql;
\nupdate user set password=password(‘$newpassword’) where user=’root’;
\nflush privileges;” > insert_query
\necho ” ”
\nsleep 1
\necho “mysql root \ud328\uc2a4\uc6cc\ub4dc\ub97c \ubcc0\uacbd\ud569\ub2c8\ub2e4.”
\necho ” ”
\nsleep 1
\necho “\ud328\uc2a4\uc6cc\ub4dc\ub97c \ubb3b\ub294 \ucc3d\uc774 \ub730 \uacbd\uc6b0\ub294 \ud604\uc7ac\uc758 mysql \ud328\uc2a4\uc6cc\ub4dc\ub97c \uc785\ub825\ud558\uc138\uc694.”
\nif \/usr\/local\/mysql\/bin\/mysql -u root -p$oldpassword < insert_query; then
\necho ” ”
\nsleep 1
\necho “mysql root \ud328\uc2a4\uc6cc\ub4dc\uac00 $newpassword\ub85c \ubcc0\uacbd\ub418\uc5c8\uc2b5\ub2c8\ub2e4”
\necho ” ”
\nelse
\necho ” ”
\necho “\ud328\uc2a4\uc6cc\ub4dc\uac00 \ub9de\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4. \ub2e4\uc2dc \uc2dc\ub3c4\ud558\uc2dc\uc624”
\necho ” ”
\nfi
\nrm -rf insert_query
\n====================================================<\/p>\n
====================================================
\n#!\/bin\/sh
\necho ” ”
\necho “\ubcc0\uacbd\ud560 mysql root \ud328\uc2a4\uc6cc\ub4dc\ub97c \uc785\ub825\ud558\uc2dc\uc624”
\nread password
\necho ” ”
\necho “mysql root \ud328\uc2a4\uc6cc\ub4dc\ub97c \ubcc0\uacbd\ud569\ub2c8\ub2e4. \ud604\uc7ac\uc758 mysql root \ud328\uc2a4\uc6cc\ub4dc\ub97c \uc785\ub825\ud558\uc138\uc694.”
\necho ” ”
\nif \/usr\/local\/mysql\/bin\/mysqladmin -u root -p password “$password”; then
\necho ” ”
\necho “mysql root \ud328\uc2a4\uc6cc\ub4dc\uac00 \ubcc0\uacbd\ub418\uc5c8\uc2b5\ub2c8\ub2e4”
\necho ” ”
\nelse
\necho ” ”
\necho “\ud328\uc2a4\uc6cc\ub4dc\uac00 \ub9de\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4. \ub2e4\uc2dc \uc2dc\ub3c4\ud558\uc2dc\uc624”
\necho ” ”
\nfi
\n====================================================<\/p>\n","protected":false},"excerpt":{"rendered":"
MySQL\uc5d0\uc11c \uc0ac\uc6a9\ud558\ub294 root \ud328\uc2a4\uc6cc\ub4dc\ub97c \ubd84\uc2e4\ud588\uc744\ub54c, \ub2e4\uc74c\uacfc \uac19\uc740 \ubc29\ubc95\uc73c\ub85c \ubc14\uafc0 \uc218 \uc788\ub2e4. 1. MySQL \ub370\ubaac\uc744 \uc911\uc9c0 \uc2dc\ud0a8\ub2e4. [root@localhost mysql]# killall mysqld<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5,6],"tags":[],"_links":{"self":[{"href":"http:\/\/jook.pe.kr\/index.php?rest_route=\/wp\/v2\/posts\/67"}],"collection":[{"href":"http:\/\/jook.pe.kr\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/jook.pe.kr\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/jook.pe.kr\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/jook.pe.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=67"}],"version-history":[{"count":0,"href":"http:\/\/jook.pe.kr\/index.php?rest_route=\/wp\/v2\/posts\/67\/revisions"}],"wp:attachment":[{"href":"http:\/\/jook.pe.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=67"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/jook.pe.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=67"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/jook.pe.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=67"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}