{"id":183,"date":"2009-12-27T13:54:00","date_gmt":"2009-12-27T13:54:00","guid":{"rendered":"https:\/\/d-mashina.net\/index.php\/2009\/12\/27\/how-to-recover-lost-mysql-root-password\/"},"modified":"2009-12-27T13:54:00","modified_gmt":"2009-12-27T13:54:00","slug":"how-to-recover-lost-mysql-root-password","status":"publish","type":"post","link":"https:\/\/d-mashina.net\/index.php\/2009\/12\/27\/how-to-recover-lost-mysql-root-password\/","title":{"rendered":"How to recover lost mysql root password?"},"content":{"rendered":"<p>1: Stop the MySQL server process.<br \/>\n2: Start the MySQL server\/daemon process with the &#8211;skip-grant-tables option <br \/>\n3: Connect to mysql server as the root user.<br \/>\n4: Setup new mysql root account password.<br \/>\n5: Exit and restart the MySQL server.<\/p>\n<p>CLI on Linux:<\/p>\n<blockquote><p>\/etc\/init.d\/mysql stop<br \/>\nmysqld_safe &#8211;skip-grant-tables &amp;<br \/>\nmysql -u root<br \/>\nuse mysql;<br \/>\nupdate user set password=PASSWORD(&#8220;NEW-ROOT-PASSWORD&#8221;) where User=&#8217;root&#8217;;<br \/>\nflush privileges;<br \/>\nquit<br \/>\n\/etc\/init.d\/mysql stop<br \/>\n\/etc\/init.d\/mysql start<br \/>\nmysql -u root -p\n<\/p><\/blockquote>\n","protected":false},"excerpt":{"rendered":"<p>1: Stop the MySQL server process. 2: Start the MySQL server\/daemon process with the &#8211;skip-grant-tables option 3: Connect to mysql server as the root user. 4: Setup new [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-183","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/d-mashina.net\/index.php\/wp-json\/wp\/v2\/posts\/183","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/d-mashina.net\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/d-mashina.net\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/d-mashina.net\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/d-mashina.net\/index.php\/wp-json\/wp\/v2\/comments?post=183"}],"version-history":[{"count":0,"href":"https:\/\/d-mashina.net\/index.php\/wp-json\/wp\/v2\/posts\/183\/revisions"}],"wp:attachment":[{"href":"https:\/\/d-mashina.net\/index.php\/wp-json\/wp\/v2\/media?parent=183"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/d-mashina.net\/index.php\/wp-json\/wp\/v2\/categories?post=183"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/d-mashina.net\/index.php\/wp-json\/wp\/v2\/tags?post=183"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}