{"id":1,"date":"2024-12-18T11:55:19","date_gmt":"2024-12-18T11:55:19","guid":{"rendered":"https:\/\/www.24x7serverguard.com\/blog\/?p=1"},"modified":"2025-03-19T09:04:45","modified_gmt":"2025-03-19T09:04:45","slug":"hello-world","status":"publish","type":"post","link":"https:\/\/www.24x7serverguard.com\/blog\/mysql\/hello-world\/","title":{"rendered":"Reset MySQL root Password"},"content":{"rendered":"\n<p><strong>If you have forget the mysql root password and you are not able to access your mysql service then you need to reset the password of mysql root user by using following steps<\/strong><br><br>1)root@server [~]<code>\u00a0\/etc\/init.d\/mysqld stop<\/code><br>2)<strong>\u00a0Start to MySQL server without password:<\/strong><br>root@server [~]\u00a0<strong><code>mysqld_safe --skip-grant-tables &amp;<\/code><\/strong><br>3) root@server [~] mysql<br>After that you can get the mysql prompt then run the following command<br>4)\u00a0<code>mysql >use mysql;<\/code><br>5)\u00a0<code>mysql >update user set password=PASSWORD(\"NEWPASSWORD\") where User='root';<\/code><br>6)\u00a0<code>mysql > quit<\/code><br>7) root@server [~]\u00a0<code>\/etc\/init.d\/mysqld stop<\/code><br>8) root@server [~]\u00a0<code>\/etc\/init.d\/mysqld start<\/code><br>Now you can access your mysql service by using<br>[root@server ~]#\u00a0<code>mysql -u root -p<\/code><br>Done<\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>If you have forget the mysql root password and you are not able to access your mysql service then you need to reset the password of mysql root user by using following steps 1)root@server [~]\u00a0\/etc\/init.d\/mysqld stop2)\u00a0Start to MySQL server without password:root@server [~]\u00a0mysqld_safe &#8211;skip-grant-tables &amp;3) root@server [~] mysqlAfter that you can get the mysql prompt then [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-1","post","type-post","status-publish","format-standard","hentry","category-mysql"],"_links":{"self":[{"href":"https:\/\/www.24x7serverguard.com\/blog\/wp-json\/wp\/v2\/posts\/1","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.24x7serverguard.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.24x7serverguard.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.24x7serverguard.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.24x7serverguard.com\/blog\/wp-json\/wp\/v2\/comments?post=1"}],"version-history":[{"count":1,"href":"https:\/\/www.24x7serverguard.com\/blog\/wp-json\/wp\/v2\/posts\/1\/revisions"}],"predecessor-version":[{"id":8,"href":"https:\/\/www.24x7serverguard.com\/blog\/wp-json\/wp\/v2\/posts\/1\/revisions\/8"}],"wp:attachment":[{"href":"https:\/\/www.24x7serverguard.com\/blog\/wp-json\/wp\/v2\/media?parent=1"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.24x7serverguard.com\/blog\/wp-json\/wp\/v2\/categories?post=1"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.24x7serverguard.com\/blog\/wp-json\/wp\/v2\/tags?post=1"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}