The problem was I didn’t have the super privilege but if I remove the DEFINER
from the query I don’t need this privilege anymore.
As of MySQL 5.0.3, CREATE PROCEDURE and CREATE FUNCTION require the CREATE
ROUTINE privilege. They might also require the SUPER privilege, depending on
the DEFINER value, as described later in this section. If binary logging is
enabled, CREATE FUNCTION might require the SUPER privilege, as described in
Section 18.6, “Binary Logging of Stored Programs”.
Also had to set the delimiter field under the SQL text box.
Here’s the SQL Query without the DEFINER statement:
;;;; ;;
