// API callback
av({"version":"1.0","encoding":"UTF-8","entry":{"xmlns":"http://www.w3.org/2005/Atom","xmlns$blogger":"http://schemas.google.com/blogger/2008","xmlns$georss":"http://www.georss.org/georss","xmlns$gd":"http://schemas.google.com/g/2005","xmlns$thr":"http://purl.org/syndication/thread/1.0","id":{"$t":"tag:blogger.com,1999:blog-875899154744260851.post-213877412971521603"},"published":{"$t":"2022-01-13T18:44:00.000-08:00"},"updated":{"$t":"2022-01-13T18:44:02.037-08:00"},"category":[{"scheme":"http://www.blogger.com/atom/ns#","term":"System Administrator"}],"title":{"type":"text","$t":"Cara Mudah Reset Password  root  Mysql di linux Centos"},"content":{"type":"html","$t":"\u003Cp\u003E\u0026nbsp;\u003C\/p\u003E\u003Cp\u003E\u003Cbr \/\u003E\u003C\/p\u003E\u003Cp\u003E\u003Cbr \/\u003E\u003C\/p\u003E\u003Cp style=\"text-align: justify;\"\u003EMozunote.com- Kebtulan kemarin ada temen kontek saya cara reset password user mysql ny ahilang dan dia berencana mau instal ulang mysql nya ,namu saya bilang jangan dulu karena itu bisa direset dengan mudah selama kita masih punya akun user sudo atau root di linux nya caranya juga sangat simple dan mudah;\u003C\/p\u003E\u003Cdiv class=\"separator\" style=\"clear: both; text-align: center;\"\u003E\u003Ca href=\"https:\/\/blogger.googleusercontent.com\/img\/a\/AVvXsEjTyJaCyxmS1crL1wdywKRKFZO841kcyaRR3qgn95GEVjPk8RulaATVrmDmS0IRidDQCR1DSYeLKFPnCGDhR-TVp8bE9tI8g7HFFnoYGidyodEKzlyXwVPxBzr-ncLd0JHdUsov0VCLoiEOZq8FbiIr0E9_dctCMryTLMPYdCqZ-I6gepwAUoOVqt6ysg=s1090\" imageanchor=\"1\" style=\"margin-left: 1em; margin-right: 1em;\"\u003E\u003Cimg border=\"0\" data-original-height=\"566\" data-original-width=\"1090\" height=\"208\" src=\"https:\/\/blogger.googleusercontent.com\/img\/a\/AVvXsEjTyJaCyxmS1crL1wdywKRKFZO841kcyaRR3qgn95GEVjPk8RulaATVrmDmS0IRidDQCR1DSYeLKFPnCGDhR-TVp8bE9tI8g7HFFnoYGidyodEKzlyXwVPxBzr-ncLd0JHdUsov0VCLoiEOZq8FbiIr0E9_dctCMryTLMPYdCqZ-I6gepwAUoOVqt6ysg=w400-h208\" width=\"400\" \/\u003E\u003C\/a\u003E\u003C\/div\u003E\u003Cbr \/\u003E\u003Cp\u003E\u003Cbr \/\u003E\u003C\/p\u003E\u003Cp\u003E1. masuk linux pake ssh kemudia matikan dulu sql nya;\u003C\/p\u003E\u003Cp\u003E\u003Cspan style=\"font-family: courier;\"\u003Esystemctl stop mysqld\u003C\/span\u003E\u003C\/p\u003E\u003Cp\u003E\u003Cbr \/\u003E\u003C\/p\u003E\u003Cp\u003E2. masuk ke safemod nya kemudia nyalakan lagi myaql nya\u003C\/p\u003E\u003Cp\u003E\u003Cspan style=\"font-family: courier;\"\u003Esystemctl set-environment MYSQLD_OPTS=\"--skip-grant-tables\"\u003C\/span\u003E\u003C\/p\u003E\u003Cp\u003E\u003Cspan style=\"font-family: courier;\"\u003Esystemctl start mysqld\u003C\/span\u003E\u003C\/p\u003E\u003Cp\u003E\u003Cbr \/\u003E\u003C\/p\u003E\u003Cp\u003E3. masuk akun root tanpa password\u003C\/p\u003E\u003Cp\u003E\u003Cspan style=\"font-family: courier;\"\u003Emysql -u root\u003C\/span\u003E\u003C\/p\u003E\u003Cp\u003E\u003C\/p\u003E\u003Cdiv class=\"separator\" style=\"clear: both; text-align: center;\"\u003E\u003Ca href=\"https:\/\/lh3.googleusercontent.com\/-7-b8wlOnHPs\/YeDhHYXVOeI\/AAAAAAAAC5s\/2K1QMgFNVgkT_tW2dHfjc_Dd15R1zGkdwCNcBGAsYHQ\/image.png\" style=\"margin-left: 1em; margin-right: 1em;\"\u003E\u003Cimg data-original-height=\"178\" data-original-width=\"631\" height=\"113\" src=\"https:\/\/lh3.googleusercontent.com\/-7-b8wlOnHPs\/YeDhHYXVOeI\/AAAAAAAAC5s\/2K1QMgFNVgkT_tW2dHfjc_Dd15R1zGkdwCNcBGAsYHQ\/w400-h113\/image.png\" width=\"400\" \/\u003E\u003C\/a\u003E\u003C\/div\u003E\u003Cbr \/\u003E\u003Cbr \/\u003E\u003Cp\u003E\u003C\/p\u003E\u003Cp\u003E\u003Cbr \/\u003E\u003C\/p\u003E\u003Cp\u003E\u003Cspan style=\"font-family: courier;\"\u003Eflush privileges;\u003C\/span\u003E\u003C\/p\u003E\u003Cp\u003E\u003Cbr \/\u003E\u003C\/p\u003E\u003Cp\u003E4. terakhir masukan password baru mu dengan perintah\u0026nbsp;\u003C\/p\u003E\u003Cp\u003E\u003Cspan style=\"font-family: courier;\"\u003EALTER USER 'root'@'localhost' IDENTIFIED BY 'passwordbarumu';\u003C\/span\u003E\u003C\/p\u003E\u003Cp\u003Esetelah selesai jangan lupa flush \u003Cspan style=\"font-family: courier;\"\u003Eprivileges;\u003C\/span\u003E lagi\u0026nbsp;\u003C\/p\u003E\u003Cp\u003E\u003Cbr \/\u003E\u003C\/p\u003E\u003Cp\u003E5. terakhir \u003Cspan style=\"font-family: courier;\"\u003Equit\u003C\/span\u003E dan \u003Cspan style=\"font-family: courier;\"\u003Ereboot\u003C\/span\u003E\u003C\/p\u003E\u003Cp\u003E\u003Cbr \/\u003E\u003C\/p\u003E\u003Cp\u003ESelesai sudah reset password akun root mysql mu sangat mudah dan simple bukan, lain kali jangan sampai lupa lagi ya, semoga membantu\u003C\/p\u003E\u003Cp\u003E\u003Cbr \/\u003E\u003C\/p\u003E\u003Cp\u003E\u003Cbr \/\u003E\u003C\/p\u003E\u003Cp\u003E\u003Cbr \/\u003E\u003C\/p\u003E\u003Cp\u003E\u003Cbr \/\u003E\u003C\/p\u003E\u003Cp\u003E\u003Cbr \/\u003E\u003C\/p\u003E\u003Cp\u003E\u003Cbr \/\u003E\u003C\/p\u003E"},"link":[{"rel":"replies","type":"application/atom+xml","href":"https:\/\/www.mozunote.com\/feeds\/213877412971521603\/comments\/default","title":"Post Comments"},{"rel":"replies","type":"text/html","href":"https:\/\/www.mozunote.com\/2022\/01\/cara-mudah-reset-password-root-mysql-di.html#comment-form","title":"0 Comments"},{"rel":"edit","type":"application/atom+xml","href":"https:\/\/www.blogger.com\/feeds\/875899154744260851\/posts\/default\/213877412971521603"},{"rel":"self","type":"application/atom+xml","href":"https:\/\/www.blogger.com\/feeds\/875899154744260851\/posts\/default\/213877412971521603"},{"rel":"alternate","type":"text/html","href":"https:\/\/www.mozunote.com\/2022\/01\/cara-mudah-reset-password-root-mysql-di.html","title":"Cara Mudah Reset Password  root  Mysql di linux Centos"}],"author":[{"name":{"$t":"Mozu"},"uri":{"$t":"http:\/\/www.blogger.com\/profile\/15656279653354976812"},"email":{"$t":"noreply@blogger.com"},"gd$image":{"rel":"http://schemas.google.com/g/2005#thumbnail","width":"16","height":"16","src":"https:\/\/img1.blogblog.com\/img\/b16-rounded.gif"}}],"media$thumbnail":{"xmlns$media":"http://search.yahoo.com/mrss/","url":"https:\/\/blogger.googleusercontent.com\/img\/a\/AVvXsEjTyJaCyxmS1crL1wdywKRKFZO841kcyaRR3qgn95GEVjPk8RulaATVrmDmS0IRidDQCR1DSYeLKFPnCGDhR-TVp8bE9tI8g7HFFnoYGidyodEKzlyXwVPxBzr-ncLd0JHdUsov0VCLoiEOZq8FbiIr0E9_dctCMryTLMPYdCqZ-I6gepwAUoOVqt6ysg=s72-w400-h208-c","height":"72","width":"72"},"thr$total":{"$t":"0"}}});