调用存储过程或函数报错 The user specified as a definer (‘pt‘@‘ %‘) does not exist

错误信息

Error querying database. Cause: java.sqI.SQL .Exception: The user specified as a definer (‘pt’@’ %’) does

not exist ### The error may exist in URL [jar:file:/data/cj_ tzkz/server/cj_ tzkz prod.jar!/BOOT-
hiT
INF/classes!/mapper/contractChapter/ContractChapterMapper.xm] ### The error may involve
defaultParameterMap ### The error occurred while setting parameters # sol·call.
prc_ contract_ chapter_ tmp(?,@rs); ### Cause: java.sql.SQL Exception The user specified as a definer
(‘pt’@’%’) does not exist ; uncategorized SQL _Éxception; SQL state [HYUUU]; error code [1449j, Thе user
specified as a definer (‘pt’@’ %’) does not exist; nested exception is java.sqÍ.SQL .Exception: The user
specified as a definer (‘pt’@ ‘%’) does not exist

出错原因

出错原因：创建该流程的账号不存在或者没权限，这个存储过程和函数是我从开发库，迁移到生产库上，生产库上没有这个账号，所以执行这个存储过程就报错了。

解决办法

把这个改成相应有权限的账号就行