Query other database's INFORMATION_SCHEMA tables
I think this does what you need:

CREATE
    DEFINER = root
    PROCEDURE ...
    SECURITY INVOKER   -- This limits what the proc can do to what the user is GRANTed
    BEGIN ... END


See http://dev.mysql.com/doc/refman/5.6/en/create-procedure.html