执行存储过程报错:User does not have access to metadata required to determine stored procedure parameter types

发布时间 2023-06-18 16:21:11作者: yshy

在执行存储过程中,报错详细信息如下:

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 '用户名称'@'%';