change user password on mysql

mysql mysql
SELECT `Host`, `User`, `Password` FROM `user`;
set password for 'auser'@'%' = password('changeme');
flush privileges;