SQL

SQL Reset Password of User

mysql -u root -p

SQL

SET PASSWORD FOR 'user'@'host' = PASSWORD('newpass');

or

UPDATE mysql.user SET Password=PASSWORD('newpass') WHERE User='user' AND Host='host';

then

FLUSH PRIVILEGES;
exit