{"id":323,"date":"2016-08-03T23:11:43","date_gmt":"2016-08-03T16:11:43","guid":{"rendered":"http:\/\/www.st.ac.th\/krubuncha\/?p=323"},"modified":"2016-11-21T08:46:20","modified_gmt":"2016-11-21T01:46:20","slug":"mysql-5-7-reset-root-password","status":"publish","type":"post","link":"https:\/\/www.st.ac.th\/krubuncha\/mysql-5-7-reset-root-password\/","title":{"rendered":"Mysql 5.7 reset root password"},"content":{"rendered":"
\/usr\/local\/etc\/rc.d\/mysql-server stop\r\n\r\nmysqld_safe --skip-grant-tables &\r\n\r\nmysql -u root\r\n\r\nuse mysql\r\n\r\nupdate user set password=PASSWORD('desiredpassword') where user='root';\r\n\r\nflush privileges;\r\n\r\nquit\r\n\r\nservice mysql-server restart<\/pre>\n
==============================================<\/pre>\n
1.<\/span> Stop mysql<\/span>:<\/span>\r\nsystemctl stop mysqld\r\n\r\n<\/span>2.<\/span> Set<\/span> the mySQL environment <\/span>option<\/span> \r\nsystemctl set-environment MYSQLD_OPTS<\/span>=<\/span>\"--skip-grant-tables\"<\/span>\r\n\r\n3.<\/span> Start<\/span> mysql usig the options you just <\/span>set<\/span>\r\nsystemctl <\/span>start<\/span> mysqld\r\n\r\n<\/span>4.<\/span> Login <\/span>as<\/span> root\r\nmysql <\/span>-<\/span>u root\r\n\r\n<\/span>5.<\/span> Update<\/span> the root <\/span>user<\/span> password <\/span>with<\/span> these mysql commands\r\nmysql<\/span>><\/span> UPDATE<\/span> mysql<\/span>.<\/span>user<\/span> SET<\/span> authentication_string <\/span>=<\/span> PASSWORD<\/span>(<\/span>'MyNewPassword'<\/span>)<\/span>\r\n    -><\/span> WHERE<\/span> User<\/span> =<\/span> 'root'<\/span> AND<\/span> Host <\/span>=<\/span> 'localhost'<\/span>;<\/span>\r\nmysql<\/span>><\/span> FLUSH PRIVILEGES<\/span>;<\/span>\r\nmysql<\/span>><\/span> quit\r\n\r\n<\/span>6.<\/span> Stop mysql\r\nsystemctl stop mysqld\r\n\r\n<\/span>7.<\/span> Unset the mySQL envitroment <\/span>option<\/span> so it starts normally next time\r\nsystemctl unset-environment MYSQLD_OPTS\r\n\r\n<\/span>8.<\/span> Start<\/span> mysql normally<\/span>:<\/span>\r\nsystemctl <\/span>start<\/span> mysqld\r\n\r\nTry <\/span>to<\/span> login <\/span>using<\/span> your new password<\/span>:<\/span>\r\n7.<\/span> mysql <\/span>-<\/span>u root <\/span>-<\/span>p<\/span><\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"
\/usr\/local\/etc\/rc.d\/mysql-server stop mysqld_safe –skip-grant-tables & mysql -u root use mysql update user set password=PASSWORD(‘desiredpassword’) where user=’root’; flush privileges; quit service mysql-server restart ============================================== 1. Stop [\u0e2d\u0e48\u0e32\u0e19\u0e15\u0e48\u0e2d]<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":334,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"footnotes":""},"categories":[1],"tags":[],"class_list":["post-323","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-1"],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/www.st.ac.th\/krubuncha\/wp-content\/uploads\/sites\/19\/2016\/08\/mysql_reset.png?fit=300%2C257&ssl=1","blog_post_layout_featured_media_urls":{"thumbnail":["https:\/\/i0.wp.com\/www.st.ac.th\/krubuncha\/wp-content\/uploads\/sites\/19\/2016\/08\/mysql_reset.png?resize=150%2C150&ssl=1",150,150,true],"full":["https:\/\/i0.wp.com\/www.st.ac.th\/krubuncha\/wp-content\/uploads\/sites\/19\/2016\/08\/mysql_reset.png?fit=300%2C257&ssl=1",300,257,false]},"categories_names":{"1":{"name":"\u0e1a\u0e17\u0e04\u0e27\u0e32\u0e21\u0e04\u0e2d\u0e21\u0e1e\u0e34\u0e27\u0e40\u0e15\u0e2d\u0e2d\u0e23\u0e4c","link":"https:\/\/www.st.ac.th\/krubuncha\/category\/%e0%b8%9a%e0%b8%97%e0%b8%84%e0%b8%a7%e0%b8%b2%e0%b8%a1%e0%b8%84%e0%b8%ad%e0%b8%a1%e0%b8%9e%e0%b8%b4%e0%b8%a7%e0%b9%80%e0%b8%95%e0%b8%ad%e0%b8%ad%e0%b8%a3%e0%b9%8c\/"}},"tags_names":[],"comments_number":0,"wpmagazine_modules_lite_featured_media_urls":{"thumbnail":["https:\/\/i0.wp.com\/www.st.ac.th\/krubuncha\/wp-content\/uploads\/sites\/19\/2016\/08\/mysql_reset.png?resize=150%2C150&ssl=1",150,150,true],"cvmm-medium":["https:\/\/i0.wp.com\/www.st.ac.th\/krubuncha\/wp-content\/uploads\/sites\/19\/2016\/08\/mysql_reset.png?resize=300%2C257&ssl=1",300,257,true],"cvmm-medium-plus":["https:\/\/i0.wp.com\/www.st.ac.th\/krubuncha\/wp-content\/uploads\/sites\/19\/2016\/08\/mysql_reset.png?resize=300%2C207&ssl=1",300,207,true],"cvmm-portrait":["https:\/\/i0.wp.com\/www.st.ac.th\/krubuncha\/wp-content\/uploads\/sites\/19\/2016\/08\/mysql_reset.png?resize=300%2C257&ssl=1",300,257,true],"cvmm-medium-square":["https:\/\/i0.wp.com\/www.st.ac.th\/krubuncha\/wp-content\/uploads\/sites\/19\/2016\/08\/mysql_reset.png?resize=300%2C257&ssl=1",300,257,true],"cvmm-large":["https:\/\/i0.wp.com\/www.st.ac.th\/krubuncha\/wp-content\/uploads\/sites\/19\/2016\/08\/mysql_reset.png?resize=300%2C257&ssl=1",300,257,true],"cvmm-small":["https:\/\/i0.wp.com\/www.st.ac.th\/krubuncha\/wp-content\/uploads\/sites\/19\/2016\/08\/mysql_reset.png?resize=130%2C95&ssl=1",130,95,true],"full":["https:\/\/i0.wp.com\/www.st.ac.th\/krubuncha\/wp-content\/uploads\/sites\/19\/2016\/08\/mysql_reset.png?fit=300%2C257&ssl=1",300,257,false]},"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p5Mvvj-5d","jetpack-related-posts":[],"_links":{"self":[{"href":"https:\/\/www.st.ac.th\/krubuncha\/wp-json\/wp\/v2\/posts\/323","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.st.ac.th\/krubuncha\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.st.ac.th\/krubuncha\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.st.ac.th\/krubuncha\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.st.ac.th\/krubuncha\/wp-json\/wp\/v2\/comments?post=323"}],"version-history":[{"count":1,"href":"https:\/\/www.st.ac.th\/krubuncha\/wp-json\/wp\/v2\/posts\/323\/revisions"}],"predecessor-version":[{"id":324,"href":"https:\/\/www.st.ac.th\/krubuncha\/wp-json\/wp\/v2\/posts\/323\/revisions\/324"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.st.ac.th\/krubuncha\/wp-json\/wp\/v2\/media\/334"}],"wp:attachment":[{"href":"https:\/\/www.st.ac.th\/krubuncha\/wp-json\/wp\/v2\/media?parent=323"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.st.ac.th\/krubuncha\/wp-json\/wp\/v2\/categories?post=323"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.st.ac.th\/krubuncha\/wp-json\/wp\/v2\/tags?post=323"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}