Display all the UDFs installed on a MySQL server?

Solution 1:

All procedures are stored in the mysql db. I usually use this query when I'm looking for something.

select db,name,definer,modified from mysql.proc;

Solution 2:

UDF are stored in FUNC table of mysql DB.

Try this:

 select * from mysql.func;

Solution 3:

According to the docs it looks like you can't do this without debugging enabled in the build.

See: (This page is for functions as well as procs)

http://dev.mysql.com/doc/refman/5.0/en/show-procedure-code.html