com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: SELECT command denied to user 'xxxx'@''
来源:互联网 发布:装修房子设计软件 编辑:程序博客网 时间:2024/06/05 20:26
这两天项目一直在报这个错误消息:
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: SELECT command denied to user 'xxxxx'@'xxx.xxx.xxx.xxx' for table 'xxxxxx'
at sun.reflect.GeneratedConstructorAccessor54.newInstance(Unknown Source)at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
at com.mysql.jdbc.Util.getInstance(Util.java:386)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3597)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3529)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1990)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2151)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2625)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2119)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2283)
at dao.UserDao.getNum(UserDao.java:236)
at dao.UserDao.addUser(UserDao.java:43)
at dao.UserDao.registUser(UserDao.java:160)
at com.unicom.vac.bossagent.soap.SyncNotifySPSoapBindingImp l.orderRelationUpdateNotify(SyncNotifySPSoapBindingImpl.java:31)
at com.unicom.vac.bossagent.soap.SyncNotifySPSoapBindingSke leton.orderRelationUpdateNotify(SyncNotifySPSoapBindingSkeleton.java:59)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.apache.axis.providers.java.RPCProvider.invokeMethod(RPCProvider.java:397)
at org.apache.axis.providers.java.RPCProvider.processMessage(RPCProvider.java:186)
在windows 上测试没有问题,可是一移植到到linux上就报这个错了,
解决方案:
将黄色标记的那个账户权限改为全局或是将黄色标记的账户的权限可以select 表(黄色部分标记的表)
- com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: SELECT command denied to user 'xxxx'@''
- com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: SELECT command denied to user’
- com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown database 'user'
- com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown database 'user'
- com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Access denied for user: 'user@pas' to database
- com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException
- 异常:com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException
- com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException
- Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: FUNCTION xxxx.$ does not exist
- com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'itcastoa.user' doesn't exist
- com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'hibernate1.user' doesn't exist
- Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'zhongfucheng.user' does
- com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'password' in
- com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column
- com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException报错解决方法
- com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException解决方式
- com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown database 'smvch'
- Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 解决方案
- C语言中的序列点和副作用
- Head First设计模式学习之一《策略模式》
- 10大优秀的移动Web开发框架
- 量子加密欲应用到智能手机 让黑客泪流满面
- 飞鸽传书 补好了才可以还
- com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: SELECT command denied to user 'xxxx'@''
- android证书制作
- Web Dynpro for ABAP:URL of a Web Dynpro Application
- Hadoop 资源监控
- 使用最新的log4cplus(1.1.1)输出多个自定义日志文件,隔离不同的 log 文件输出
- 支付宝银联博弈升级 增建“民联”呼声再起
- 用java中的Math.random()函数产生一个简单的随机字符串
- 【代码】Android中的进程与多线程的讲解(Handler和AsyncTask)
- static class 静态类(Java)