use mysql;
update user set password=old_password("newpasswod") where user="username";
flush privileges;
use mysql;
update user set password=old_password("newpasswod") where user="username";
flush privileges;