执行存储过程报错: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 '用户名称'@'%';

 

posted @ 2023-06-18 16:12  yshy  阅读(192)  评论(0编辑  收藏  举报