Example of Set Password Mysql Statement:

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 root@localhost=PASSWORD('newpass');

Example of Mysql Set Password

SET PASSWORD [FOR user]
{
PASSWORD('some password')
| OLD_PASSWORD('some password')
| 'encrypted password'
}