Add functions in phpMyAdmin
just add it in the SQL box but beware of the delimiter
Any DELIMITER command in the query box does not work. Instead, set the delimiter "$$" in the form field below the SQL statement box. Then you can create any function:
$$
CREATE ....
END $$
A little more detailled in this explanation.