Where are Stored Procedures stored?

In the proc table in the mysql system database. However, you should not access the tables in the system database directly. Instead, use SHOW CREATE [FUNCTION|PROCEDURE] (see http://dev.mysql.com/doc/mysql/en/show-create-procedure.html) or INFORMATION_SCHEMA (see http://dev.mysql.com/doc/mysql/en/routines-table.html)