ref : http://www.cnblogs.com/jyginger/archive/2011/04/27/2030017.html
1.>> update user set password=PASSWORD("rootadmin") where user='root';
2.>> mysqladmin -u root -p password newpassword
