{"id":78,"date":"2012-08-06T15:59:55","date_gmt":"2012-08-06T06:59:55","guid":{"rendered":"http:\/\/auctionpro.co.kr\/WPress\/?p=78"},"modified":"2012-08-27T22:30:50","modified_gmt":"2012-08-27T13:30:50","slug":"mysql-root-recover","status":"publish","type":"post","link":"https:\/\/www.auctionpro.co.kr\/?p=78","title":{"rendered":"mysql root recover"},"content":{"rendered":"<p>Step # 1 : Stop mysql service<br \/>\n# \/etc\/init.d\/mysqld stop<\/p>\n<p>Output:<br \/>\nStopping MySQL database server: mysqld.\/<\/p>\n<p>Step # 2: Start to MySQL server w\/o password:<br \/>\n# mysqld_safe &#8211;skip-grant-tables &amp;<\/p>\n<p>Output:<br \/>\n[1] 5988<br \/>\nStarting mysqld daemon with databases from \/var\/lib\/mysql<br \/>\nmysqld_safe[6025]: started<\/p>\n<p>Step # 3: Connect to mysql server using mysql client:<br \/>\n# mysql -u root<\/p>\n<p>Output:<br \/>\nWelcome to the MySQL monitor. Commands end with ; or \\g.<br \/>\nYour MySQL connection id is 1 to server version: 4.1.15-Debian_1-log<br \/>\nType &#8216;help;&#8217; or &#8216;\\h&#8217; for help. Type &#8216;\\c&#8217; to clear the buffer.<br \/>\nmysql&gt;<\/p>\n<p>Step # 4: Setup new MySQL root user password (\ud2b9\uc218\ubb38\uc790 \ubd88\uac00 !@#$%^&amp;*)<br \/>\nmysql&gt; use mysql;<br \/>\nmysql&gt; update user set password=PASSWORD(&#8220;NEW-ROOT-PASSWORD&#8221;) where User=&#8217;root&#8217;;<br \/>\nmysql&gt; flush privileges;<br \/>\nmysql&gt; quit<\/p>\n<p><span style=\"color: #ff0000;\">\ucd94\uac00<\/span><br \/>\n<span style=\"color: #ff0000;\"> Step # 5<\/span><br \/>\n<span style=\"color: #ff0000;\"> \uc2e4\ud589\uc911\uc778 mysql \ub2e4\uc2dc \uc885\ub8cc(* \uc911\uc694 : \uad8c\ud55c \ud14c\uc774\ube14\uc744 \uc0ac\uc6a9\ud558\uc9c0 \uc54a\ub294 \ub370\ubaac\uc744 \uc885\ub8cc) \ud558\uc9c0 \uc54a\uc73c\uba74 mysql \ud558\uba74 \ubc14\ub85c \ub4e4\uc5b4\uac10<\/span><\/p>\n<p><span style=\"color: #ff0000;\"># ps -ef | grep mysqld<\/span><br \/>\nroot 12084 11558 0 20:10 pts\/2 00:00:00 sh .\/mysqld_safe &#8211;skip-grant-ta<br \/>\nroot 12090 12084 0 20:10 pts\/2 00:00:00 \/usr\/local\/mysql\/libexec\/mysqld<br \/>\nroot 12092 12090 0 20:10 pts\/2 00:00:00 \/usr\/local\/mysql\/libexec\/mysqld<br \/>\nroot 12093 12092 0 20:10 pts\/2 00:00:00 \/usr\/local\/mysql\/libexec\/mysqld<br \/>\n#<br \/>\n<span style=\"color: #ff0000;\"># killall mysqld<\/span><br \/>\nmysqld daemon ended<br \/>\n[1]+ Done .\/mysqld_safe &#8211;skip-grant-tables<br \/>\n#<\/p>\n<p>Step # 6<br \/>\nMysql \ub370\ubaac \uc7ac \uc2e4\ud589 \ud6c4 \uac31\uc2e0\ub41c \ud328\uc2a4\uc6cc\ub4dc\ub85c \ub85c\uadf8\uc778<\/p>\n<p>* Test<br \/>\n: Start MySQL server and test it<br \/>\n# \/etc\/init.d\/mysqld start<br \/>\n# mysql -u root -p<\/p>\n<p>\uc2e4\uc218\ub85c \uacc4\uc815 \uc0ad\uc81c\uc2dc :<\/p>\n<pre><em>chown: `mysql:mysql': invalid user<\/em><\/pre>\n<pre># yum --enablerepo=\\* --disablerepo=c5-media groupinfo 'MySQL Database'<\/pre>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<div class=\"mh-excerpt\"><p>Step # 1 : Stop mysql service # \/etc\/init.d\/mysqld stop Output: Stopping MySQL database server: mysqld.\/ Step # 2: Start to MySQL server w\/o password: <a class=\"mh-excerpt-more\" href=\"https:\/\/www.auctionpro.co.kr\/?p=78\" title=\"mysql root recover\">[&#8230;]<\/a><\/p>\n<\/div>","protected":false},"author":6,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[11],"tags":[],"class_list":["post-78","post","type-post","status-publish","format-standard","hentry","category-centos"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/78","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=78"}],"version-history":[{"count":0,"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/78\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=78"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=78"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=78"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}