jdbc4.MySQLSyntaxErrorException: SELECT command denied to user '用户名'@'localhost' for table '表名'

谁借莪１个温暖的怀抱￠ 2023-07-10 08:26 125阅读 0赞

jdbc4.MySQLSyntaxErrorException: SELECT command denied to user ‘用户名’@‘localhost’ for table ‘表名’

异常信息如下：

  1. com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: SELECT command denied to user 'admin'@'localhost' for table 'test_table'
  2.     at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
  3.     at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
  4.     at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  5.     at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
  6.     at com.mysql.jdbc.Util.handleNewInstance(Util.java:377)
  7.     at com.mysql.jdbc.Util.getInstance(Util.java:360)
  8.     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:978)
  9.     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887)
  10.     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823)
  11.     at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435)
  12.     at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582)
  13.     at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2530)
  14.     at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1907)
  15.     at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1199)
  16.     at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:3409)
  17.     at com.alibaba.druid.filter.FilterEventAdapter.preparedStatement_execute(FilterEventAdapter.java:440)
  18.     at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:3407)
  19.     at com.alibaba.druid.proxy.jdbc.PreparedStatementProxyImpl.execute(PreparedStatementProxyImpl.java:167)
  20.     at com.alibaba.druid.pool.DruidPooledPreparedStatement.execute(DruidPooledPreparedStatement.java:498)
  21.     at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:56)
  22.     at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:70)
  23.     at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:57)
  24.     at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:259)
  25.     at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:132)
  26.     at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:105)
  27.     at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:81)
  28.     at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:104)
  29.     at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:98)
  30.     at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:62)
  31.     at sun.reflect.GeneratedMethodAccessor203.invoke(Unknown Source)
  32.     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  33.     at java.lang.reflect.Method.invoke(Method.java:498)
  34.     at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:358)
  35.     at com.sun.proxy.$Proxy19.selectOne(Unknown Source)
  36.     at org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:163)
  37.     at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:63)
  38.     at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:43)
  39.     at com.sun.proxy.$Proxy35.getOneBySelective(Unknown Source)
  40.     at com.wallet.framework.base.BaseServiceImpl.getOneBySelective(BaseServiceImpl.java:104)
  41.     at com.wallet.framework.base.BaseServiceImpl$$FastClassBySpringCGLIB$$1e7fd57f.invoke(<generated>)
  42.     at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
  43.     at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:746)
  44.     at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
  45.     at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:294)
  46.     at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:98)
  47.     at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
  48.     at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:688)
  49.     at com.wallet.user.server.impl.ScstMemberServiceImpl$$EnhancerBySpringCGLIB$$184c34c9.getOneBySelective(<generated>)
  50.     at com.alibaba.dubbo.common.bytecode.Wrapper25.invokeMethod(Wrapper25.java)
  51.     at com.alibaba.dubbo.rpc.proxy.javassist.JavassistProxyFactory$1.doInvoke(JavassistProxyFactory.java:45)
  52.     at com.alibaba.dubbo.rpc.proxy.AbstractProxyInvoker.invoke(AbstractProxyInvoker.java:71)
  53.     at com.alibaba.dubbo.config.invoker.DelegateProviderMetaDataInvoker.invoke(DelegateProviderMetaDataInvoker.java:48)
  54.     at com.alibaba.dubbo.rpc.protocol.InvokerWrapper.invoke(InvokerWrapper.java:52)
  55.     at com.alibaba.dubbo.rpc.filter.ExceptionFilter.invoke(ExceptionFilter.java:61)
  56.     at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:68)
  57.     at com.alibaba.dubbo.monitor.support.MonitorFilter.invoke(MonitorFilter.java:64)
  58.     at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:68)
  59.     at com.alibaba.dubbo.rpc.filter.TimeoutFilter.invoke(TimeoutFilter.java:41)
  60.     at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:68)
  61.     at com.alibaba.dubbo.rpc.protocol.dubbo.filter.TraceFilter.invoke(TraceFilter.java:77)
  62.     at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:68)
  63.     at com.alibaba.dubbo.rpc.filter.ContextFilter.invoke(ContextFilter.java:60)
  64.     at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:68)
  65.     at com.alibaba.dubbo.rpc.filter.GenericFilter.invoke(GenericFilter.java:131)
  66.     at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:68)
  67.     at com.alibaba.dubbo.rpc.filter.ClassLoaderFilter.invoke(ClassLoaderFilter.java:37)
  68.     at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:68)
  69.     at com.alibaba.dubbo.rpc.filter.EchoFilter.invoke(EchoFilter.java:37)
  70.     at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:68)
  71.     at com.alibaba.dubbo.rpc.protocol.dubbo.DubboProtocol$1.reply(DubboProtocol.java:95)
  72.     at com.alibaba.dubbo.remoting.exchange.support.header.HeaderExchangeHandler.handleRequest(HeaderExchangeHandler.java:96)
  73.     at com.alibaba.dubbo.remoting.exchange.support.header.HeaderExchangeHandler.received(HeaderExchangeHandler.java:168)
  74.     at com.alibaba.dubbo.remoting.transport.DecodeHandler.received(DecodeHandler.java:50)
  75.     at com.alibaba.dubbo.remoting.transport.dispatcher.ChannelEventRunnable.run(ChannelEventRunnable.java:79)
  76.     at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
  77.     at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
  78.     at java.lang.Thread.run(Thread.java:748)

异常信息虽然很多，但是看重点就够了：

Error querying database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: SELECT command denied to user 'admin'@'localhost' for table 'test_table'

说明：每个人的用户名(我这里是admin)和表名(我这里是test_table)，在实际异常中都可能是不一样的，但是没关系，主要是得看报错信息。
SELECT command denied to 翻译一下，可以知道这是拒绝连接的意思，后面的异常报错信息里面，应该会跟上你的sql语句。
那么，哪些情况下会产生这种问题呢？如下：

  1. 当前用户(admin)没有操作(CRUD)该表(test_table)的权限；解决办法 -> 增加该用户相应的操作权限即可。
  2. sql语句错误，这个语法上的错误就不赘述了，相信大家都懂的啦。我想说的是语法之外的错误，但是异常信息也会报badSqlGrammer，也就是报错sql语法错误。具体原因很多，我这里就说说我自己的情况吧 -> 项目连接的数据库是db1，但是代码sql语句查询的数据库是db2，然后怎么都查不到…因为这块之前是其他同事写的，后面有些变动。排错的时候也没有一个字母一个字母的去看sql语句，语法确实没错，但是查询的数据库错了，反正找了半天，总算解决了…
  3. 其他原因，欢迎大家补充，多多交流，谢谢~

发表评论

表情：
评论列表 （有 0 条评论，125人围观）

还没有评论，来说两句吧...

相关阅读