{"id":365,"date":"2010-08-13T06:08:12","date_gmt":"2010-08-13T12:08:12","guid":{"rendered":"http:\/\/blog.supportpro.com\/2010\/08\/how-to-recover-lost-mysql-password\/"},"modified":"2018-10-04T06:31:48","modified_gmt":"2018-10-04T12:31:48","slug":"how-to-recover-lost-mysql-password","status":"publish","type":"post","link":"https:\/\/www.supportpro.com\/blog\/how-to-recover-lost-mysql-password\/","title":{"rendered":"HOW TO RECOVER LOST MYSQL PASSWORD"},"content":{"rendered":"<p>Steps for recovering mysql password are given below:<br \/>\nStop the mysql service.<br \/>\n#\/etc\/init.d\/mysql stop<br \/>\nOnce, the mysql service completely stopped, run the below.<br \/>\n#\/usr\/bin\/mysqld_safe skip-grant-tables skip-networking &amp;<br \/>\nYou will be now able to login without password.<\/p>\n<p>&nbsp;<\/p>\n<p><!--more--><\/p>\n<p>#mysql -uroot mysql<br \/>\nIssue the below in mysql command line.<br \/>\nmysql&gt;UPDATE user SET password=PASSWORD(your new password) WHERE user=root; FLUSH PRIVILEGES;<br \/>\nmysql&gt;exit<br \/>\nStop mysql.<br \/>\n#\/etc\/init.d\/mysql stop<br \/>\nStart MySQL again<br \/>\n#\/etc\/init.d\/mysql start<br \/>\nThat&#8217;s it! You will be now able to login with your new password.<\/p>\n<p>If you require help, contact SupportPRO Server Admin<\/p>\n<p style=\"text-align: center;\"><!--HubSpot Call-to-Action Code --><span id=\"hs-cta-wrapper-9d590242-d641-4383-94b4-8cfd62f0af6b\" class=\"hs-cta-wrapper\"><span id=\"hs-cta-9d590242-d641-4383-94b4-8cfd62f0af6b\" class=\"hs-cta-node hs-cta-9d590242-d641-4383-94b4-8cfd62f0af6b\"><!-- [if lte IE 8]><\/p>\n\n\n\n\n\n<div id=\"hs-cta-ie-element\"><\/div>\n\n\n<![endif]--><a href=\"https:\/\/cta-redirect.hubspot.com\/cta\/redirect\/2725694\/9d590242-d641-4383-94b4-8cfd62f0af6b\"><img decoding=\"async\" id=\"hs-cta-img-9d590242-d641-4383-94b4-8cfd62f0af6b\" class=\"hs-cta-img\" style=\"border-width: 0px;\" src=\"https:\/\/no-cache.hubspot.com\/cta\/default\/2725694\/9d590242-d641-4383-94b4-8cfd62f0af6b.png\" alt=\"Server not running properly? Get A FREE Server Checkup By Expert Server Admins - $125 Value\" \/><\/a><\/span><script charset=\"utf-8\" src=\"https:\/\/js.hscta.net\/cta\/current.js\"><\/script><script type=\"text\/javascript\"> hbspt.cta.load(2725694, '9d590242-d641-4383-94b4-8cfd62f0af6b', {}); <\/script><\/span><!-- end HubSpot Call-to-Action Code --><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Steps for recovering mysql password are given below: Stop the mysql service. #\/etc\/init.d\/mysql stop Once, the mysql service completely stopped, run the below. #\/usr\/bin\/mysqld_safe skip-grant-tables skip-networking &amp; You will be&hellip;<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_lmt_disableupdate":"","_lmt_disable":"","footnotes":""},"categories":[1],"tags":[],"class_list":["post-365","post","type-post","status-publish","format-standard","hentry","category-miscellaneous"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.supportpro.com\/blog\/wp-json\/wp\/v2\/posts\/365","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.supportpro.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.supportpro.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.supportpro.com\/blog\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.supportpro.com\/blog\/wp-json\/wp\/v2\/comments?post=365"}],"version-history":[{"count":1,"href":"https:\/\/www.supportpro.com\/blog\/wp-json\/wp\/v2\/posts\/365\/revisions"}],"predecessor-version":[{"id":3378,"href":"https:\/\/www.supportpro.com\/blog\/wp-json\/wp\/v2\/posts\/365\/revisions\/3378"}],"wp:attachment":[{"href":"https:\/\/www.supportpro.com\/blog\/wp-json\/wp\/v2\/media?parent=365"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.supportpro.com\/blog\/wp-json\/wp\/v2\/categories?post=365"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.supportpro.com\/blog\/wp-json\/wp\/v2\/tags?post=365"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}