mysql服务已经开了,但是项目一直连接不到本地服务器,求助

ktyu10 2013-04-24 09:37:02
四月 24, 2013 9:33:52 上午 org.apache.catalina.core.ApplicationContext log
INFO: HTMLManager: list: Listing contexts for virtual host 'localhost'

错误提示如下:
2013-04-24 09:35:34,115 [http-8080-4] INFO com.serp.dao.xt.CompanyDao - 执行查询语句: SELECT * FROM XT_COMPANY_T limit 1 offset 0
2013-04-24 09:35:34,116 [http-8080-4] INFO com.serp.dao.xt.CompanyDao - 当前查询的字段名为:COMPANY_NAME,COMP_SHORT_NAME,COMP_LOGO,COMP_PHONE,COMP_FAX,COMP_MAIL,COMP_ADDR,COMP_CONT_NAME,
2013-04-24 09:35:34,116 [http-8080-4] INFO com.serp.dao.xt.CompanyDao - 查询历时(获取连接、查询结果、转换对象、关闭连接):0.001秒.
2013-04-24 09:35:34,117 [http-8080-4] INFO com.serp.dao.xt.ModuleDao - 执行查询语句: SELECT * FROM XT_MODULE_T WHERE (MODU_STAT=2 or MODU_STAT=1) ORDER BY MODULE_NAME
2013-04-24 09:35:34,117 [http-8080-4] INFO com.serp.dao.xt.ModuleDao - 当前查询的字段名为:MODU_NO,MODULE_NAME,MODU_LEVE_NO,MODU_ROAD,MODULE_PRIV_FLAG,MODULE_LOG_FLAG,MODULE_TOP_LEVEL,MODU_SEQ,MODU_STAT,MODU_FORM,MODU_JSP,
2013-04-24 09:35:34,119 [http-8080-4] INFO com.serp.dao.xt.ModuleDao - 查询历时(获取连接、查询结果、转换对象、关闭连接):0.003秒.
2013-04-24 09:35:34,120 [http-8080-4] INFO com.serp.dao.xt.InitDao - 执行预编译查询语句: SELECT INIT_ID,INIT_PWD,INVOICE_NUM FROM XT_INIT_T WHERE INIT_ID= 1 limit 1 offset 0
2013-04-24 09:35:34,120 [http-8080-4] INFO com.serp.dao.xt.InitDao - 当前查询的字段名为:INIT_ID,INIT_PWD,INVOICE_NUM,
2013-04-24 09:35:34,122 [http-8080-4] INFO com.serp.dao.xt.InitDao - 查询历时(获取连接、查询结果、转换对象、关闭连接):0.003秒.
2013-04-24 09:35:34,123 [http-8080-4] INFO com.serp.dao.xt.OperateDao - 执行查询语句: SELECT OPERATE_NO,OPERATE_NAME,IF_DEFAULT,GET_DICT_DESC('XT_OPERATE_T','IF_DEFAULT',IF_DEFAULT) STR_IF_DEFAULT FROM XT_OPERATE_T WHERE 1=1 ORDER BY OPERATE_NO DESC
2013-04-24 09:35:34,123 [http-8080-4] ERROR com.serp.dao.xt.OperateDao - 查询出错: The user specified as a definer ('root'@'%') does not exist
2013-04-24 09:35:34,124 [http-8080-4] ERROR org.springframework.jdbc.datasource.DataSourceUtils - Could not close JDBC Connection
java.sql.SQLException: Connection is closed.
at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.checkOpen(PoolingDataSource.java:174)
at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.close(PoolingDataSource.java:179)
at org.springframework.jdbc.datasource.DataSourceUtils.doReleaseConnection(DataSourceUtils.java:286)
at org.springframework.jdbc.datasource.DataSourceUtils.releaseConnection(DataSourceUtils.java:247)
at org.tulip.Dao.closeConnection(Dao.java:125)
at org.tulip.RootDao.queryNormalList(RootDao.java:187)
at org.tulip.RootDao.queryList(RootDao.java:53)
at com.serp.dao.xt.OperateDao.getOperateColl(OperateDao.java:124)
at com.serp.SystemInit.sysInit(SystemInit.java:109)
at com.serp.act.xt.LoginAct.execute(LoginAct.java:47)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:419)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:224)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1194)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.extremecomponents.table.filter.AbstractExportFilter.doFilter(AbstractExportFilter.java:49)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at com.serp.util.CharsetEncodingFilter.doFilter(CharsetEncodingFilter.java:39)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:291)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:602)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Unknown Source)
2013-04-24 09:35:34,124 [http-8080-4] ERROR com.serp.SystemInit - 系统初始化信息出错:查询出错!
The user specified as a definer ('root'@'%') does not exist
org.tulip.DaoException: 查询出错!
The user specified as a definer ('root'@'%') does not exist
at org.tulip.RootDao.queryNormalList(RootDao.java:183)
at org.tulip.RootDao.queryList(RootDao.java:53)
at com.serp.dao.xt.OperateDao.getOperateColl(OperateDao.java:124)
at com.serp.SystemInit.sysInit(SystemInit.java:109)
at com.serp.act.xt.LoginAct.execute(LoginAct.java:47)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:419)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:224)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1194)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.extremecomponents.table.filter.AbstractExportFilter.doFilter(AbstractExportFilter.java:49)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at com.serp.util.CharsetEncodingFilter.doFilter(CharsetEncodingFilter.java:39)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:291)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:602)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Unknown Source)
...全文
251 4 打赏 收藏 转发到动态 举报
写回复
用AI写文章
4 条回复
切换为时间正序
请发表友善的回复…
发表回复
ACMAIN_CHM 2013-04-24
  • 打赏
  • 举报
回复
MYSQL中的用户账号比较特别。 它是由 username@hostname组成。 所以说 root 并不是一个账号,仅是个用户名而已。 root 在不同主机去登录MYSQL的身份是不同的,MYSQL一般只默认给 root @localhost权限,而 root@% 的权限很小。
ktyu10 2013-04-24
  • 打赏
  • 举报
回复
已自行解决- -# root用户没有权限的问题。。。
ktyu10 2013-04-24
  • 打赏
  • 举报
回复
里面有一句这个The user specified as a definer ('root'@'%') does not exist 但是我登陆自己的数据库就是用的root的账号啊。。。凌乱中,求各路大神相助
ktyu10 2013-04-24
  • 打赏
  • 举报
回复
引用 3 楼 ACMAIN_CHM 的回复:
MYSQL中的用户账号比较特别。 它是由 username@hostname组成。 所以说 root 并不是一个账号,仅是个用户名而已。 root 在不同主机去登录MYSQL的身份是不同的,MYSQL一般只默认给 root @localhost权限,而 root@% 的权限很小。
谢啦~散分咯~

56,677

社区成员

发帖
与我相关
我的任务
社区描述
MySQL相关内容讨论专区
社区管理员
  • MySQL
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧