{"id":41,"date":"2007-07-21T17:29:20","date_gmt":"2007-07-21T16:29:20","guid":{"rendered":"http:\/\/www.fredkuo.idv.tw\/wordpress\/?p=41"},"modified":"2007-07-21T17:29:20","modified_gmt":"2007-07-21T16:29:20","slug":"mysql-password-recover","status":"publish","type":"post","link":"https:\/\/fredkuo.idv.tw\/wordpress\/?p=41","title":{"rendered":"mysql password recover"},"content":{"rendered":"<ol>\n<li>Stop the mysqld daemon process.<\/li>\n<li>Start the mysqld daemon process with the <em>&#8211;skip-grant-tables<\/em> option.<\/li>\n<li>Start the <a style=\"text-decoration: underline ! important; position: static\" class=\"kLink\" target=\"_top\" id=\"KonaLink0\" href=\"http:\/\/www.tech-faq.com\/reset-mysql-password.shtml#\"><font color=\"blue\" style=\"color: blue ! important; font-family: Verdana; font-weight: 400; font-size: 11px; position: static\"><span style=\"border-bottom: 1px solid blue; color: blue ! important; font-family: Verdana; font-weight: 400; font-size: 11px; position: static; padding-bottom: 1px; background-color: transparent\" class=\"kLink\">mysql<\/span><\/font><\/a> client with the <em>-u root<\/em> option.<\/li>\n<li>Execute the <em>UPDATE mysql.user SET Password=PASSWORD(&#8216;password&#8217;) WHERE User=&#8217;root&#8217;;<\/em><\/li>\n<li>Execute the <em>FLUSH PRIVILEGES;<\/em> command.<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"<p>Stop the mysqld daemon process. Start the mysqld daemon [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-41","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/fredkuo.idv.tw\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/41"}],"collection":[{"href":"https:\/\/fredkuo.idv.tw\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/fredkuo.idv.tw\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/fredkuo.idv.tw\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/fredkuo.idv.tw\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=41"}],"version-history":[{"count":0,"href":"https:\/\/fredkuo.idv.tw\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/41\/revisions"}],"wp:attachment":[{"href":"https:\/\/fredkuo.idv.tw\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=41"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/fredkuo.idv.tw\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=41"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/fredkuo.idv.tw\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=41"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}