MySQL zeigt alle gespeicherten Prozeduren an

SELECT `name` FROM mysql.proc where db = 'your_db_name' and `type` = 'PROCEDURE'
 
show procedure status;