{"id":28,"date":"2013-10-17T11:50:57","date_gmt":"2013-10-17T11:50:57","guid":{"rendered":"http:\/\/linux.mycustomcycle.com\/?p=28"},"modified":"2015-02-19T19:35:29","modified_gmt":"2015-02-19T19:35:29","slug":"mysql-change-password","status":"publish","type":"post","link":"http:\/\/linux.suriyasuneel.com\/?p=28","title":{"rendered":"mysql change password"},"content":{"rendered":"<p>There are a couple of ways to change a user password including root for the mysql databases.<\/p>\n<p>one is using mysqladmin(which i&#8217;m not that fluent with)<\/p>\n<p>the other is directly go into mysql and change the password.<\/p>\n<pre>$mysql -u root - p\r\n\r\nNow enter password (your old password for root)\r\n\r\nmysql &gt; use mysql;\r\n\r\nmysql&gt; update user set password=PASSWORD(\"new_password\") where User='root';\r\n\r\nmysql&gt; flush privileges;\r\n\r\nmysql&gt; quit;<\/pre>\n<p>You can login again to check whether the password change took effect<\/p>\n","protected":false},"excerpt":{"rendered":"<p>There are a couple of ways to change a user password including root for the mysql databases. one is using mysqladmin(which i&#8217;m not that fluent with) the other is directly go into mysql and change the password. $mysql -u root &#8211; p Now enter password (your old password for root) mysql &gt; use mysql; mysql&gt; [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[],"_links":{"self":[{"href":"http:\/\/linux.suriyasuneel.com\/index.php?rest_route=\/wp\/v2\/posts\/28"}],"collection":[{"href":"http:\/\/linux.suriyasuneel.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/linux.suriyasuneel.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/linux.suriyasuneel.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/linux.suriyasuneel.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=28"}],"version-history":[{"count":1,"href":"http:\/\/linux.suriyasuneel.com\/index.php?rest_route=\/wp\/v2\/posts\/28\/revisions"}],"predecessor-version":[{"id":29,"href":"http:\/\/linux.suriyasuneel.com\/index.php?rest_route=\/wp\/v2\/posts\/28\/revisions\/29"}],"wp:attachment":[{"href":"http:\/\/linux.suriyasuneel.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=28"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/linux.suriyasuneel.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=28"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/linux.suriyasuneel.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=28"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}