{"id":448,"date":"2010-02-18T16:31:16","date_gmt":"2010-02-18T15:31:16","guid":{"rendered":"http:\/\/blog.spanger.org\/?p=448"},"modified":"2011-03-16T12:55:26","modified_gmt":"2011-03-16T11:55:26","slug":"reset-mysql-password","status":"publish","type":"post","link":"https:\/\/blog.spanger.org\/?p=448","title":{"rendered":"Reset MYSQL password"},"content":{"rendered":"<p>How to Reset a MySQL Password:<\/p>\n<ol>\n<li>Stop the mysqld daemon process,<\/li>\n<pre><code>[root@host ~]# \/etc\/init.d\/mysqld stop\r\nStopping MySQL:               [  OK  ]<\/code><\/pre>\n<li>Start the mysqld daemon process with the &#8211;skip-grant-tables option,<\/li>\n<pre><code>[root@host ~]# \/etc\/init.d\/mysqld start --skip-grant-tables\r\nStarting MySQL:                               [  OK  ]<\/code><\/pre>\n<li>Start the mysql client with the -u root option,<\/li>\n<pre><code>[root@host ~]# mysql -u root -p\r\nEnter password:<\/code><\/pre>\n<p>&lt;&#8212; enter current root password<\/p>\n<li>Change password to no password at all.\u00a0 Execute the UPDATE mysql.user SET Password=PASSWORD(&#8216;password&#8217;) WHERE User=&#8217;root&#8217;;<\/li>\n<pre><code>mysql&gt; UPDATE mysql.user SET Password=PASSWORD('') WHERE User='root';<\/code><\/pre>\n<li>Execute the FLUSH PRIVILEGES;\u00a0 command.<\/li>\n<pre><code>mysql&gt; FLUSH PRIVILEGES;<\/code><\/pre>\n<\/ol>\n<p>Found somewhere on the internet and helps me a lot.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>How to Reset a MySQL Password: Stop the mysqld daemon process, [root@host ~]# \/etc\/init.d\/mysqld stop Stopping MySQL: [ OK ] Start the mysqld daemon process with the &#8211;skip-grant-tables option, [root@host ~]# \/etc\/init.d\/mysqld start &#8211;skip-grant-tables Starting MySQL: [ OK ] Start the mysql client with the -u root option, [root@host ~]# mysql -u root -p Enter [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6],"tags":[22],"class_list":["post-448","post","type-post","status-publish","format-standard","hentry","category-linux-stuff","tag-mysql"],"_links":{"self":[{"href":"https:\/\/blog.spanger.org\/index.php?rest_route=\/wp\/v2\/posts\/448","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.spanger.org\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.spanger.org\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.spanger.org\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.spanger.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=448"}],"version-history":[{"count":9,"href":"https:\/\/blog.spanger.org\/index.php?rest_route=\/wp\/v2\/posts\/448\/revisions"}],"predecessor-version":[{"id":451,"href":"https:\/\/blog.spanger.org\/index.php?rest_route=\/wp\/v2\/posts\/448\/revisions\/451"}],"wp:attachment":[{"href":"https:\/\/blog.spanger.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=448"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.spanger.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=448"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.spanger.org\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=448"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}