GRANT EXECUTE ON PROCEDURE yourdbname.sp_yourspname TO theuser@’localhost’;
GRANT EXECUTE ON FUNCTION yourdbname.fn_yourfunctionname TO theuser@’localhost’;
use mysql
GRANT SELECT ON mysql.proc to theuser@’localhost’ IDENTIFIED BY ‘paswd’;
GRANT SELECT ON mysql.func to theuser@’localhost’ IDENTIFIED BY ‘paswd’;
FLUSH PRIVILEGES;
