Mysql displays a list of user functions in phpmyadmin

Question

How to view a list of user functions in mysql database using phpmyadmin.

The Mysql database has been migrated from one server to another, and user-defined user functions do not work. I need to look at a list of user-defined functions to check if they exist in the database or not.

Fatal error: db::execute() Could not execute: FUNCTION database.xxx does not exist (SQL: SELECT Function(field) FROM users in file.php on line xx 

Answer 1

The following MySQL query will list user routines.

 select * from information_schema.routines; 

Answer 2

This will give you all the information about your user functions / procedures:

 select specific_name, definer from information_schema.routines where definer not like '%mysql%'; 

hope this helps!