mysql>updatemysql.userSETPassword=OLD_PASSWORD('newpwd')

->whereHost='some_host'ANDUser='some_user';

mysql>FLUSHPRIVILEGES;