{"id":29536,"date":"2022-04-13T05:32:23","date_gmt":"2022-04-13T05:32:23","guid":{"rendered":"https:\/\/www.devopsschool.com\/blog\/?p=29536"},"modified":"2025-12-08T10:03:12","modified_gmt":"2025-12-08T10:03:12","slug":"how-to-reset-or-recover-forgotten-mysql-root-password","status":"publish","type":"post","link":"https:\/\/www.devopsschool.com\/blog\/how-to-reset-or-recover-forgotten-mysql-root-password\/","title":{"rendered":"How to Reset or Recover Forgotten mySql root Password"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\">Recover Forgotten mySql root Password in Linux<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Step 1 &#8211; Locate my.ini or my.cnf in mysql server.<\/li>\n\n\n\n<li>Step 2 &#8211; Edit my.ini or my.cnf and insert &#8216;skip-grant-tables&#8217; below [mysqld]<\/li>\n\n\n\n<li>Step 3 &#8211; Restart MySQL<\/li>\n\n\n\n<li>Step 4 &#8211; Set new password for your root user by running<\/li>\n<\/ul>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-1\" data-shcb-language-name=\"JavaScript\" data-shcb-language-slug=\"javascript\"><span><code class=\"hljs language-javascript\">$ mysql -u root\nmysql&gt; UPDATE mysql.user SET Password=PASSWORD(<span class=\"hljs-string\">'new_password'<\/span>) WHERE User=<span class=\"hljs-string\">'root'<\/span>;\nmysql&gt; UPDATE mysql.user SET Password=PASSWORD(<span class=\"hljs-string\">'new-password-here'<\/span>) WHERE USER=<span class=\"hljs-string\">'root'<\/span> AND Host=<span class=\"hljs-string\">'localhost'<\/span>;\n\n\n<span class=\"hljs-keyword\">in<\/span> phpMyAdmin <span class=\"hljs-keyword\">in<\/span> the mysql database (or just leave it like <span class=\"hljs-keyword\">this<\/span> <span class=\"hljs-keyword\">if<\/span> MySQL cannot be accessed <span class=\"hljs-keyword\">from<\/span> remote hosts)\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-1\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">JavaScript<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">javascript<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<ul class=\"wp-block-list\">\n<li>Step 5 &#8211; Remove the skip-grant-tables in the my.ini or my.cnf file<\/li>\n\n\n\n<li>Step 6 &#8211; Restart MySQL<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">OLD method<\/h2>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-2\" data-shcb-language-name=\"JavaScript\" data-shcb-language-slug=\"javascript\"><span><code class=\"hljs language-javascript\">UPDATE mysql.user \n  SET Password = PASSWORD(<span class=\"hljs-string\">'NewStrongPass123!'<\/span>)\n  WHERE User = <span class=\"hljs-string\">'root'<\/span> AND Host = <span class=\"hljs-string\">'localhost'<\/span>;\nFLUSH PRIVILEGES;<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-2\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">JavaScript<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">javascript<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<h2 class=\"wp-block-heading\">Resetting MySQL Root Password with XAMPP on Localhost<\/h2>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"457\" src=\"https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2022\/04\/image-7-1024x457.png\" alt=\"\" class=\"wp-image-29539\" srcset=\"https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2022\/04\/image-7-1024x457.png 1024w, https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2022\/04\/image-7-300x134.png 300w, https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2022\/04\/image-7-768x343.png 768w, https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2022\/04\/image-7.png 1030w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">How to change a mysql user password?<\/h2>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-3\" data-shcb-language-name=\"JavaScript\" data-shcb-language-slug=\"javascript\"><span><code class=\"hljs language-javascript\">$ mysql -u root -p\nmysql&gt; use mysql;\n\n- The syntax is <span class=\"hljs-keyword\">as<\/span> follows <span class=\"hljs-keyword\">for<\/span> mysql database server version <span class=\"hljs-number\">5.7<\/span><span class=\"hljs-number\">.5<\/span> or older:\nmysql&gt; SET PASSWORD FOR <span class=\"hljs-string\">'user-name-here'<\/span>@<span class=\"hljs-string\">'hostname'<\/span> = PASSWORD(<span class=\"hljs-string\">'new-password'<\/span>);\n\n- For mysql database server version <span class=\"hljs-number\">5.7<\/span><span class=\"hljs-number\">.6<\/span> or newer use the following syntax:\nmysql&gt; ALTER USER <span class=\"hljs-string\">'user'<\/span>@<span class=\"hljs-string\">'hostname'<\/span> IDENTIFIED BY <span class=\"hljs-string\">'newPass'<\/span>;\n\n- You can also use the following sql syntax:\nmysql&gt; UPDATE mysql.user SET Password=PASSWORD(<span class=\"hljs-string\">'new-password-here'<\/span>) WHERE USER=<span class=\"hljs-string\">'user-name-here'<\/span> AND Host=<span class=\"hljs-string\">'host-name-here'<\/span>;\n\nmysql&gt; ALTER USER <span class=\"hljs-string\">'root'<\/span>@<span class=\"hljs-string\">'localhost'<\/span> IDENTIFIED BY <span class=\"hljs-string\">'sjh643#22SLKhaA2%'<\/span>;\nmysql&gt; FLUSH PRIVILEGES;\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-3\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">JavaScript<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">javascript<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Recover Forgotten mySql root Password in Linux OLD method Resetting MySQL Root Password with XAMPP on Localhost How to change a mysql user password?<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_joinchat":[],"footnotes":""},"categories":[2],"tags":[],"class_list":["post-29536","post","type-post","status-publish","format-standard","hentry","category-uncategorised"],"_links":{"self":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts\/29536","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/comments?post=29536"}],"version-history":[{"count":6,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts\/29536\/revisions"}],"predecessor-version":[{"id":54407,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts\/29536\/revisions\/54407"}],"wp:attachment":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/media?parent=29536"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/categories?post=29536"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/tags?post=29536"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}