Posts

Showing posts from 2017

Halal Food in Hanoi, Sapa, Halong Bay, Vietnam

Okay, I seldom wrote on my travel a.k.a vacation on blog. However, since there is very little information I gather for halal / muslim food available for Hanoi, I decided to share some so you don't have worry about your meal while been there.  Hanoi is a little be outside of typical destination. You can find less place for halal food.  1. Hanoi Old Quarter Boutique Hotel : Located on old quarter, offer some experience of Malaysian in 70's or early 80's. Closest halal restaurant is Zainab Restaurant. The restaurant may hv 2-3 table for 4 pax. So it's small time business for Muslim there.  Located just beside the An Noor mosque, you must enter the most main gate to see the small entrance of the restaurant. An order of "nasi daging kebab" of 70k VND is enough for medium sized Malaysia eating for lunch/dinner. Zainab Restaurant - An Noor Mosque Hanoi 2. Van Hung Sapa Hotel :  Located in Sa Pa, facing the  church of sapa town.  N...

Reset MYSQL password in Centos 7

1. Stop mysql : systemctl stop mysqld 2. Set the mySQL environment option systemctl set-environment MYSQLD_OPTS = "--skip-grant-tables" 3. Start mysql usig the options you just set systemctl start mysqld 4. Login as root mysql - u root 5. Update the root user password with these mysql commands mysql > UPDATE mysql . user SET authentication_string = PASSWORD ( 'MyNewPassword' ) -> WHERE User = 'root' AND Host = 'localhost' ; mysql > FLUSH PRIVILEGES ; mysql > quit 6. Stop mysql systemctl stop mysqld 7. Unset the mySQL envitroment option so it starts normally next time systemctl unset-environment MYSQLD_OPTS 8. Start mysql normally : systemctl start mysqld Try to login using your new password : 7. mysql - u root - p   Credit to: https://stackoverflow.com/questions/33510184/change-mysql-root-password-on-centos7