Granting Users to see the Definition of Stored Procedure created by Super User

Problem:

The Users in MySQL could not able to view definition of the store Procedures that are created by super users…

Cause:

You have to grant your "application user" select permissions on mysql.proc otherwise the connector can't see the sproc you're trying to call through it.

Solution:

Login as super user and grant the following select privilege to user who want to see the definition of stored procedure..

grant select on mysql.proc to user@localhost;