SET PASSWORD FOR 'user'@'hostname' = PASSWORD('passwordhere');
UPDATE user SET password=PASSWORD("NEWPASSWORD") WHERE User='vivek';
UPDATE user SET password=PASSWORD('newpassword') WHERE user='ramesh';
SET PASSWORD FOR [email protected]=PASSWORD('newpass');