To change password of any user use foolowing command

Alter user username
identified by password

kuckoo