I have written few stored procedures and executed in my server that is having php myadmin now while calling this stored procedure from my application it is showing following exception
SQLException1 java.sql.SQLException: User does not have access to metadata required to determine stored procedure parameter types. If rights can not be granted, configure connection with "noAccessToProcedureBodies=true" to have driver generate parameters that represent INOUT strings irregardless of actual parameter types.
While searching i find following query to resolve this exception:
GRANT SELECT,INSERT,UPDATE ON mysql.proc TO 'user'@'localhost';
my problem is that while running this query i am getting following error
#1142 - SELECT,INSERT,UP command denied to user 'qqq'@'localhost' for table 'proc'
but i have given all permission to user
GRANT ALL ON *.* TO 'qqq'@'localhost';
So how to access stored procedure from my application I am using shared hosting server .