{"id":554,"date":"2019-04-09T01:10:58","date_gmt":"2019-04-09T01:10:58","guid":{"rendered":"http:\/\/www.asianux.org.vn\/?p=554"},"modified":"2019-04-09T01:10:59","modified_gmt":"2019-04-09T01:10:59","slug":"reset-mysql-5-7-root-password","status":"publish","type":"post","link":"https:\/\/www.asianux.org.vn\/index.php\/2019\/04\/09\/reset-mysql-5-7-root-password\/","title":{"rendered":"Reset MySQL 5.7 root password"},"content":{"rendered":"\n<pre class=\"wp-block-preformatted\">sudo mysqld_safe --skip-grant-tables &amp;<br> <br>Then when paste this and hit [ENTER]<br>mysql -uroot<br>use mysql;<br>update user set authentication_string=password('YOURSUPERSECRETPASSWORD') where user='root';<br>flush privileges;<br>quit<br>Restart MySQL<br>Login Mysql and change pass<br>set password=password('Admin321*'); <br><br><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>sudo mysqld_safe &#8211;skip-grant-tables &amp; Then when paste this and hit [ENTER]mysql -urootuse mysql;update user set authentication_string=password(&#8216;YOURSUPERSECRETPASSWORD&#8217;) where user=&#8217;root&#8217;;flush privileges;quitRestart MySQLLogin Mysql and change passset password=password(&#8216;Admin321*&#8217;);<\/p>\n","protected":false},"author":1,"featured_media":555,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-554","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database"],"_links":{"self":[{"href":"https:\/\/www.asianux.org.vn\/index.php\/wp-json\/wp\/v2\/posts\/554","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.asianux.org.vn\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.asianux.org.vn\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.asianux.org.vn\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.asianux.org.vn\/index.php\/wp-json\/wp\/v2\/comments?post=554"}],"version-history":[{"count":1,"href":"https:\/\/www.asianux.org.vn\/index.php\/wp-json\/wp\/v2\/posts\/554\/revisions"}],"predecessor-version":[{"id":556,"href":"https:\/\/www.asianux.org.vn\/index.php\/wp-json\/wp\/v2\/posts\/554\/revisions\/556"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.asianux.org.vn\/index.php\/wp-json\/wp\/v2\/media\/555"}],"wp:attachment":[{"href":"https:\/\/www.asianux.org.vn\/index.php\/wp-json\/wp\/v2\/media?parent=554"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.asianux.org.vn\/index.php\/wp-json\/wp\/v2\/categories?post=554"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.asianux.org.vn\/index.php\/wp-json\/wp\/v2\/tags?post=554"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}