Error querying database. Cause: java.sql.SQLException: The user specified as a definer ('root'@'%')

Dear 丶 2024-04-19 12:07 48阅读 0赞

今天在将一个导入的项目成功跑起来后，报如下错误：

2019-09-18 09:21:07.767 ERROR 16164 --- [nio-8181-exec-4] c.j.pds.utils.RRExceptionHandler         : 
    ### Error querying database.  Cause: java.sql.SQLException: The user specified as a definer ('root'@'%') does not exist
    ### The error may exist in file [D:\个人项目\pds\target\classes\mapper\AccountManagerRankDao.xml]
    ### The error may involve defaultParameterMap
    ### The error occurred while setting parameters
    ### SQL: select * from view_account_manager_rank                           order by rank ASC                                     limit ?, ?
    ### Cause: java.sql.SQLException: The user specified as a definer ('root'@'%') does not exist
    ; uncategorized SQLException for SQL []; SQL state [HY000]; error code [1449]; The user specified as a definer ('root'@'%') does not exist; nested exception is java.sql.SQLException: The user specified as a definer ('root'@'%') does not exist

查了一下之后，是因为视图的安全性是`definer`  
![在这里插入图片描述][20190918100451521.png]

*  DEFINER 表示按定义者拥有的权限来执行
 *  INVOKER 表示用调用者的权限来执行。
 *  默认情况下，系统指定为DEFINER

修改之后，解决问题  
![在这里插入图片描述][20190918100750974.png]

[20190918100451521.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/18/65d902bab4a449349a725846e9708607.png
[20190918100750974.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/18/07c8d3242efd46439832f473c32bda49.png