执行存储过程报错:User does not have access to metadata required to determine stored procedure parameter types
在执行存储过程中,报错详细信息如下:
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.
解决方法:
grant execute on 数据库名称.* to '用户名称'@'%'; grant select on mysql.proc to '用户名称'@'%';