MySQL permissions error restore w/ FUNCTION `civicrm_strip_non_numeric`

[CiviTeacher.com]

After a failed upgrade I deleted the database, re-created it, assigned the 'master' user to it (that has all permissions) and imported the .sql backup file.  I got this error:

Code: [Select]

ERROR 1227 (42000) Access denied; you need (at least one of) the SUPER privilege(s) for this operation
When I removed this code from the bottom of the .sql the import went fine.

Code: [Select]

CREATE DEFINER=`mymasteruser`@`localhost` FUNCTION `civicrm_strip_non_numeric`(input VARCHAR(255) CHARACTER SET utf8) RETURNS varchar(255) CHARSET utf8
    NO SQL
    DETERMINISTIC
BEGIN
      DECLARE output   VARCHAR(255) CHARACTER SET utf8 DEFAULT '';
      DECLARE iterator INT          DEFAULT 1;
      WHILE iterator < (LENGTH(input) + 1) DO
        IF SUBSTRING(input, iterator, 1) IN ('0', '1', '2', '3', '4', '5', '6', '7', '8', '9') THEN
          SET output = CONCAT(output, SUBSTRING(input, iterator, 1));
        END IF;
        SET iterator = iterator + 1;
      END WHILE;
      RETURN output;
    END
Any thoughts on what permission I am missing or why this is happening?

[Coleman Watts]

I think in older versions of mysql you needed SUPER privileges to create functions. Might want to look it up in mysql docs.