SET @newpass = PASSWORD('whateverpasswordiwant');
UPDATE mysql.user SET PASSWORD = @newpass WHERE user='replication_user';