I will add more when I stumble upon commands I can’t remember the syntax of.
mysql> SHOW PROCEDURE STATUS;
Example output (with cropped dates and times for readable table):
| Db | Name | Type | Definer | Modified | Created | Security_type | Comment |
|---|---|---|---|---|---|---|---|
| mydb | store_user | PROCEDURE | root | 2007-0.. | 2007-0.. | DEFINER | |
| mydb | store_cart | PROCEDURE | root | 2007-0.. | 2007-0.. | DEFINER | |
| mydb | store_settings | PROCEDURE | root | 2007-0.. | 2007-0.. | DEFINER |