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'
}