java.sql.SQLException: The user specified as a definer (‘root‘@‘%‘) does not exist登陆系统时报系统异常

最新推荐文章于 2023-02-18 07:42:33 发布
最新推荐文章于 2023-02-18 07:42:33 发布
阅读量3.1k 收藏 2
点赞数 1
分类专栏： 工作
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/qq_40756936/article/details/118892058
版权

后端控制台报错：报错是因为访问视图没有权限

[异常信息:com.pty.mad.common.exception.MadException: com.pty.mad.common.exception.MadException: 
### Error querying database.  Cause: java.sql.SQLException: The user specified as a definer ('root'@'%') does not exist
### The error may exist in com/pty/mad/dao/MadAgencyDao.xml
### The error may involve com.pty.mad.dao.MadAgencyDao.selectGlobalCacheInfo-Inline
### The error occurred while setting parameters
### SQL: SELECT         MAD_ID AS "id",         MAD_CODE AS "code",         MAD_NAME AS "name",         PARENT_CODE AS "pcode",         AGY_TYPE_CODE AS "agyTypeCode"         FROM MAD_AGENCY         WHERE FISCAL=?                   order by MAD_CODE
### 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]
[异常堆栈信息:com.pty.mad.common.exception.MadException: com.pty.mad.common.exception.MadException: 
### Error querying database.  Cause: java.sql.SQLException: The user specified as a definer ('root'@'%') does not exist
### The error may exist in com/pty/mad/dao/MadAgencyDao.xml
### The error may involve com.pty.mad.dao.MadAgencyDao.selectGlobalCacheInfo-Inline
### The error occurred while setting parameters
### SQL: SELECT         MAD_ID AS "id",         MAD_CODE AS "code",         MAD_NAME AS "name",         PARENT_CODE AS "pcode",         AGY_TYPE_CODE AS "agyTypeCode"         FROM MAD_AGENCY         WHERE FISCAL=?                   order by MAD_CODE
### 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
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
	at java.util.concurrent.ForkJoinTask.getThrowableException(ForkJoinTask.java:593)
	at java.util.concurrent.ForkJoinTask.reportException(ForkJoinTask.java:677)
	at java.util.concurrent.ForkJoinTask.invoke(ForkJoinTask.java:735)
	at java.util.stream.ForEachOps$ForEachOp.evaluateParallel(ForEachOps.java:160)
	at java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateParallel(ForEachOps.java:174)
	at java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:233)
	at java.util.stream.ReferencePipeline.forEach(ReferencePipeline.java:418)
	at java.util.stream.ReferencePipeline$Head.forEach(ReferencePipeline.java:583)
	at com.pty.mad.service.cache.GlobalInfoService.getGlobalInfo(GlobalInfoService.java:59)
	at com.pty.mad.rest.UserController.globalInfo(UserController.java:52)
	at com.pty.mad.rest.UserController$$FastClassBySpringCGLIB$$1.invoke(<generated>)
	at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:738)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:173)
	at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:673)
	at com.pty.mad.rest.UserController$$EnhancerBySpringCGLIB$$1.globalInfo(<generated>)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)
	at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:133)
	at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:97)
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:827)
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:738)
	at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)
	at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:967)
	at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:901)
	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970)
	at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:861)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:687)
	at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.springframework.web.filter.HttpPutFormContentFilter.doFilterInternal(HttpPutFormContentFilter.java:108)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:81)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:197)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199)
	at org.apache.catalina.core.StandardContextValve.__invoke(StandardContextValve.java:96)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:41002)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:478)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)
	at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:803)
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1459)
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Thread.java:748)
Caused by: com.pty.mad.common.exception.MadException: 
### Error querying database.  Cause: java.sql.SQLException: The user specified as a definer ('root'@'%') does not exist
### The error may exist in com/pty/mad/dao/MadAgencyDao.xml
### The error may involve com.pty.mad.dao.MadAgencyDao.selectGlobalCacheInfo-Inline
### The error occurred while setting parameters
### SQL: SELECT         MAD_ID AS "id",         MAD_CODE AS "code",         MAD_NAME AS "name",         PARENT_CODE AS "pcode",         AGY_TYPE_CODE AS "agyTypeCode"         FROM MAD_AGENCY         WHERE FISCAL=?                   order by MAD_CODE
### 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
	at com.pty.mad.service.cache.GlobalInfoService.lambda$getGlobalInfo$1(GlobalInfoService.java:73)
	at java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:184)
	at java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1382)
	at java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:482)
	at java.util.stream.ForEachOps$ForEachTask.compute(ForEachOps.java:291)
	at java.util.concurrent.CountedCompleter.exec(CountedCompleter.java:731)
	at java.util.concurrent.ForkJoinTask.doExec(ForkJoinTask.java:289)
	at java.util.concurrent.ForkJoinPool$WorkQueue.runTask(ForkJoinPool.java:1056)
	at java.util.concurrent.ForkJoinPool.runWorker(ForkJoinPool.java:1692)
	at java.util.concurrent.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:157)
]

这个情况是视图有问题，我们去数据库中打开相关视图

 

 

TomorrowOkk
关注
  • 1
    点赞
  • 踩
  • 2
    收藏
    觉得还不错? 一键收藏
  • 1
    评论
专栏目录
The user specified as a definer (‘root‘@‘%‘) does not exist(已解决)
【CSDN】
04-06 4121
The user specified as a definer ('root'@'%') does not exist 此种报错主要是针对访问视图文件引起的（没有权限） 按照下图进行操作 1.先看下mysql是否设置了环境变量，如果没设置，就需要切换到mysql的bin目录下执行命令（我的已经设置） mysql -hlocalhost -uroot -p123456 2.给root用户添加权限 grant all privileges on *.* to root@"%" identifi.
Mysql:The user specified as a definer (‘xxx@’%’) does not exist的解决方案
12-15
今天项目优化过程中，mysql有个问题The user specified as a definer (‘wx_root’@’%’) does not exist 查了一下，意思是执行sql无权限。  看了下数据库用户是quoters 而sql没有所属权。那就找原因了。发现sql执行过程中，调用了一个存储过程 而这个存储过程的创建者是wx_root 。 所以在执行的时候，quoters没有权限 解决方案和操作： 1、查看存储过程的所属对象：  右键存储过程函数——>选择对象属性——>查看函数创建和所属是不是当前登录的用户 2、如果不是，备份原有的存储过程函数，复制存储过程函数里面所有内容，新建
Error querying database. Cause: java.sql.SQLException: The user specified as a definer (''@'') doe
fire_in_java的专栏
02-15 7476
mysql函数调用报错： ### Error querying database. Cause: java.sql.SQLException: The user specified as a definer (''@'') does not exist
The user specified as a definer ('root'@'%') does not exist
Ai卿的博客
09-23 683
Error querying database. Cause: java.sql.SQLException: The user specified as a definer ('root'@'%') does not exist 在调用存储过程时，报错定义用户不存在。 sql语句修改： UPDATE mysql.proc SET DEFINER='root@localhost' W...
Error querying database. Cause: java.sql.SQLException: The user specified as a definer ('root'@'%')
Be Like
09-18 3175
今天在将一个导入的项目成功跑起来后，报如下错误： 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 spec...
Mysql报错 Error querying database. Cause java.sql.SQLSyntaxErrorException
m0_67393619的博客
06-08 9379
今天写一个查询功能的时候，出现了一个错误，当我写好后端接口，准备去前端掉用的时候出现了如下错误：###Errorqueryingdatabase.Cause:java.sql.SQLSyntaxErrorException:YouhaveanerrorinyourSQLsyntax;checkthemanualthatcorrespondstoyourMySQLserverversionfortherightsyntaxtousenear’LIMIT10’atline31###Theerrormayexis
java.sql.SQLException: 内部错误: Unable to construct a Datum from the specified input
01-21
Q: I am working with ... I am using updateBinaryStream method of resultset to update the BLOB field but it is failing after giving following exception java.sql.SQLException: Internal Error: Unable to
记录因为yml而产生的坑：java.sql.SQLException: Access denied for user ‘root’@’localhost’ (using password: YES)
01-19
java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES) 提示的是用户访问被拒绝，原因是密码不正确，但是我们明明配置的是正确的密码，原因就在yml中： spring: datasource: ...
java.sql.SQLException: null,  message from server: “Host ‘%’ is not allowed to connect to
12-14
java.sql.SQLException: null, message from server: “Host ‘223.72.41.7’ is not allowed to connect to this MySQL server” 客户端访问时报错： 解决方法： 1，登陆服务器 mysql> use mysql; //用mysql ...
Error querying database. Cause: java.sql.SQLException:
qq_40818905的博客
08-30 4834
记录Mybatis学习过程中遇到的问题 2、由于需要将MySQL数据库配置信息写到一个properties文件中，方便以后修改。在连接的时候发生以下错误： Error querying database. Cause: java.sql.SQLException: The server time zone value ‘�й���׼ʱ��’ is unrecognized or represents more than one time zone. You must configure either t
Cause: java.sql.SQLException: The user specified as a definer ('test'@'%') does not exist 存储过程报错
我的成长之路！
07-05 7359
由于存储过程设置的安全性为definer，而当时的那个数据库存在test这个用户且用的test用户创建的存储过程。 所以解决方法主要有以下两种： 保持definer安全性 1）在navicat上进行修改 将定义者从test改为在该服务器存在的用户（一般每个服务器都有root@localhost） 2）通过sql语句修改 1 mysql>update mysql.proc...
The user specified as a definer (‘root‘@‘%‘) does not exist 问题解决
qq_49306973的博客
12-21 6507
Caused by: java.sql.SQLException: The user specified as a definer ('root'@'%') does not exist 解决办法
SQL BUG - java.sql.SQLSyntaxErrorException -已解决
qq_43786840的博客
08-05 9913
SQL BUG - java.sql.SQLSyntaxErrorException -已解决
Error querying database. Cause: java.sql.SQLSyntaxErrorException: You have an error in your SQL syn
H-rosy的博客
11-30 4928
Error querying database. Cause: java.sql.SQLSyntaxErrorException: You have an error in your踩坑日记。数据库提示错误的查询语句。但我看了和数据库表中的字段名是一模一样的，经过我的反复排查，后知后觉的发现原来desc是数据库的关键字呀。desc是mysql中的降序关键字，只要把desc换一个名字就好了。最开始反复提示near“desc xxxx”,提示在desc附近，没往这边想。然后其他的就好好对照看是不是自己写错了。
mysql 执行报错：Error querying database. Cause: java.sql.SQLSyntaxErrorException:which is not functionall
weixin_36332085的博客
11-23 8104
mysql 执行报错：Error querying database. Cause: java.sql.SQLSyntaxErrorException:which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by 1.这个错误发生在mysql 5.7 版本及以上版本会出现的问题： mysql 5.7版本默认的sql配置是:s
记一次 Cause: java.sql.SQLException: The user specified as a definer (‘XXX‘@‘%‘) does not exist的解决办法
qq_42213516的博客
07-16 887
在 使用 navicat 拉取了线上数据库到本地,然后在调试的时候,其他表的数据都可以正常查询,只有在查询视图的数据时报了这个错误,把这个错误记录下来 , 我的解决方式是 1 在 navicat 中,右击视图,选择设计视图,把视图的sql语句复制保存下来,然后删除掉此视图(视图中不存数据,所以删除我觉的没影响), 2 然后使用保存的sql新建一个视图即可, 因为是在本地,也没去找其他方法,记录一下,不过慎用这种暴力的方法,在本地没啥,在线上生产环境得三思咯 ...
Error querying database. Cause: java.sql.SQLSyntaxErrorException: You have an error in your SQL
weixin_45614626的博客
10-28 3059
在写Mapper文件中的SQL语句时，写完单元测试报了如下错误Error querying database. Cause: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use**** 查了许久没发现问题，最后终于发现了。 @Selec
MySql8.0版本 The user specified as a definer (‘root‘@‘%‘) does not exist已解决
weixin_44081211的博客
02-03 1075
查询资料后，发现是版本的问题，8.0.11版本之后移除了grant 语句添加用户的功能，也就是说grant…只能适用于已存在的账户，不能通过 grant…新版本数据库语句和老版本数据库语句会有差别，个人学习还是推荐使用老版本，出现各种问题方便找到办法。链接：https://www.jianshu.com/p/8bd666d68545。商业转载请联系作者获得授权，非商业转载请注明出处。网上查了下相关问题的处理方法，基本都是这句。mysql8.0 以后这句的用法不一样了。
多种方法解决Error querying database. Cause: java.sql.SQLException: No value specified for parameter 1
念兮为美
02-18 9312
多种方法解决Error querying database. Cause: java.sql.SQLException: No value specified for parameter 1
Cause: java.sql.SQLException: The user specified as a definer ('root'@'%') does not exist
最新发布
09-17
这个错误是由于在数据库中指定的用户不存在所引起的。当你尝试使用一个不存在的用户时，会出现"java.sql.SQLException: The user specified as a definer ('root'@'%') does not exist"的错误。 为了解决这个问题，你可以按照以下步骤进行操作： 1. 确认你使用的用户名和密码是正确的。检查的代码或配置文件中的数据库连接信息，确保用户名和密码是正确的2. 如果你确定用户名和密码是正确的，那么可能是因为你没有创建该用户。在数据库中创建一个新的用户，并确保在你的代码或配置文件中使用正确的用户名和密码。 3. 如果你已经创建了用户但仍然遇到问题，那么可能是因为你的用户没有适当的权限。授予该用户所需的权限，以便他可以执行所需的操作。 4. 如果你使用的是外部工具或框架进行数据库操作，例如Navicat，请确保你正确地配置了该工具或框架，并且指定了正确的用户名和密码。
评论 1
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值