UPDATE mysql.user SET Password=PASSWORD(’new-password-here’) WHERE User=’user-name-here’ AND Host=’host-name-here’;

FLUSH privileges;