Listing Stored Procedures from Databases in the MySQL Server

To show all stored procedures of a particular database, you use the following query: 

SELECT routine_name FROM information_schema.routines WHERE routine_type = 'PROCEDURE' AND routine_schema = '<database_name>';