主题 : 数据库连接报错 |
级别: 白丁
|
1# 发表于:2017-08-03 10:40:06 IP:183.140.*.*
|
||||
---|---|---|---|---|---|
级别: 总版主
|
4# 发表于:2017-08-03 10:50:41 IP:106.240.*.*
你tomcat的完整错误信息发下 |
||
---|---|---|---|
级别: 版主
|
5# 发表于:2017-08-03 10:50:45 IP:106.240.*.*
打开MySQL目录下的my.ini文件,在文件的最后添加一行“skip-grant-tables”,保存并关闭文件。(WIN7默认安装,my.ini在C:\ProgramData\MySQL\MySQL Server 5.6)
重启MySQL服务。 通过命令行进入MySQL的BIN目录,输入“mysql -u root -p”(不输入密码),回车即可进入数据库。(WIN7默认安装,BIN目录为:C:\Program Files\MySQL\MySQL Server 5.6\bin) 执行“use mysql;”,使用mysql数据库。 执行“update user set password=PASSWORD("123456") where user='root';”(修改root的密码) 打开MySQL目录下的my.ini文件,删除最后一行的“skip-grant-tables”,保存并关闭文件。 重启MySQL服务。 在命令行中输入“mysql -u root -p 123456”,即可成功连接数据库。 |
||
---|---|---|---|
级别: 白丁
|
6# 发表于:2017-08-03 10:52:24 IP:183.140.*.*
回复第4楼
2017-8-3 10:50:23 org.apache.catalina.core.AprLifecycleListener init 信息: The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: C:\Users\Administrator\AppData\Local\MyEclipse Professional\binary\com.sun.java.jdk.win32.x86_64_1.6.0.u43\bin;D:\Tomcat7.0*\apache-tomcat-7.0*\bin 2017-8-3 10:50:25 org.apache.coyote.AbstractProtocol init 信息: Initializing ProtocolHandler ["http-bio-8080"] 2017-8-3 10:50:25 org.apache.coyote.AbstractProtocol init 信息: Initializing ProtocolHandler ["ajp-bio-8009"] 2017-8-3 10:50:25 org.apache.catalina.startup.Catalina load 信息: Initialization processed in 2114 ms 2017-8-3 10:50:25 org.apache.catalina.core.StandardService startInternal 信息: Starting service Catalina 2017-8-3 10:50:25 org.apache.catalina.core.StandardEngine startInternal 信息: Starting Servlet Engine: Apache Tomcat/7.0* 2017-8-3 10:50:25 org.apache.catalina.startup.HostConfig deployDirectory 信息: Deploying web application directory D:\Tomcat7.0*\apache-tomcat-7.0*\webapps\docs 2017-8-3 10:50:26 org.apache.tomcat.websocket.server.WsSci onStartup 信息: JSR 356 WebSocket (Java WebSocket 1.0) support is not available when running on Java 6. To suppress this message, run Tomcat on Java 7, remove the WebSocket JARs from $CATALINA_HOME/lib or add the WebSocket JARs to the tomcat.util.scan.DefaultJarScanner.jarsToSkip property in $CATALINA_BASE/conf/catalina.properties. Note that the deprecated Tomcat 7 WebSocket API will be available. 2017-8-3 10:50:26 org.apache.catalina.startup.HostConfig deployDirectory 信息: Deployment of web application directory D:\Tomcat7.0*\apache-tomcat-7.0*\webapps\docs has finished in 1,175 ms 2017-8-3 10:50:26 org.apache.catalina.startup.HostConfig deployDirectory 信息: Deploying web application directory D:\Tomcat7.0*\apache-tomcat-7.0*\webapps\examples 2017-8-3 10:50:27 org.apache.catalina.core.ApplicationContext log 信息: ContextListener: contextInitialized() 2017-8-3 10:50:27 org.apache.catalina.core.ApplicationContext log 信息: SessionListener: contextInitialized() 2017-8-3 10:50:27 org.apache.catalina.core.ApplicationContext log 信息: ContextListener: attributeAdded('org.apache.jasper.compiler.TldLocationsCache', 'org.apache.jasper.compiler.TldLocationsCache@629ca1fb') 2017-8-3 10:50:27 org.apache.catalina.startup.HostConfig deployDirectory 信息: Deployment of web application directory D:\Tomcat7.0*\apache-tomcat-7.0*\webapps\examples has finished in 830 ms 2017-8-3 10:50:27 org.apache.catalina.startup.HostConfig deployDirectory 信息: Deploying web application directory D:\Tomcat7.0*\apache-tomcat-7.0*\webapps\firstservlet 2017-8-3 10:50:27 org.apache.catalina.startup.HostConfig deployDirectory 信息: Deployment of web application directory D:\Tomcat7.0*\apache-tomcat-7.0*\webapps\firstservlet has finished in 162 ms 2017-8-3 10:50:27 org.apache.catalina.startup.HostConfig deployDirectory 信息: Deploying web application directory D:\Tomcat7.0*\apache-tomcat-7.0*\webapps\host-manager 2017-8-3 10:50:27 org.apache.catalina.startup.HostConfig deployDirectory 信息: Deployment of web application directory D:\Tomcat7.0*\apache-tomcat-7.0*\webapps\host-manager has finished in 85 ms 2017-8-3 10:50:27 org.apache.catalina.startup.HostConfig deployDirectory 信息: Deploying web application directory D:\Tomcat7.0*\apache-tomcat-7.0*\webapps\manager 2017-8-3 10:50:28 org.apache.catalina.startup.HostConfig deployDirectory 信息: Deployment of web application directory D:\Tomcat7.0*\apache-tomcat-7.0*\webapps\manager has finished in 110 ms 2017-8-3 10:50:28 org.apache.catalina.startup.HostConfig deployDirectory 信息: Deploying web application directory D:\Tomcat7.0*\apache-tomcat-7.0*\webapps\ROOT 2017-8-3 10:50:28 org.apache.catalina.loader.WebappClassLoader validateJarFile 信息: validateJarFile(D:\Tomcat7.0*\apache-tomcat-7.0*\webapps\ROOT\WEB-INF\lib\servlet-api.jar) - jar not loaded. See Servlet Spec 3.0, section 10.7.2. Offending class: javax/servlet/Servlet.class 2017-8-3 10:50:49 org.apache.catalina.core.ApplicationContext log 信息: Initializing Spring root WebApplicationContext 10:51:05.060 ERROR org.hibernate.util.JDBCExceptionReporter - Access denied for user 'root'@'localhost' (using password: YES) 2017-8-3 10:51:12 org.apache.catalina.core.ApplicationContext log 信息: Initializing Spring FrameworkServlet 'JspGouAdmin' 2017-8-3 10:51:24 org.apache.catalina.core.ApplicationContext log 信息: Initializing Spring FrameworkServlet 'JspGouFront' java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3536) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3468) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:917) at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3974) at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1282) at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2142) at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:773) at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46) at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) at java.lang.reflect.Constructor.newInstance(Constructor.java:513) at com.mysql.jdbc.Util.handleNewInstance(Util.java:406) at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:352) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:282) at java.sql.DriverManager.getConnection(DriverManager.java:582) at java.sql.DriverManager.getConnection(DriverManager.java:207) at com.jspgou.common.update.UpdateServlet.getConn(UpdateServlet.java:71) at com.jspgou.common.update.UpdateServlet.createTable(UpdateServlet.java:59) at com.jspgou.common.update.UpdateServlet.Install(UpdateServlet.java:47) at com.jspgou.common.update.UpdateServlet.init(UpdateServlet.java:27) at javax.servlet.GenericServlet.init(GenericServlet.java:158) at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1284) at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1197) at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1087) at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:5229) at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5516) at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:649) at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1247) at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1898) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:439) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) at java.util.concurrent.FutureTask.run(FutureTask.java:138) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918) at java.lang.Thread.run(Thread.java:662) 2017-8-3 10:51:56 org.apache.catalina.startup.HostConfig deployDirectory 信息: Deployment of web application directory D:\Tomcat7.0*\apache-tomcat-7.0*\webapps\ROOT has finished in 88,365 ms 2017-8-3 10:51:56 org.apache.catalina.startup.HostConfig deployDirectory 信息: Deploying web application directory D:\Tomcat7.0*\apache-tomcat-7.0*\webapps\smgou 2017-8-3 10:51:56 org.apache.catalina.loader.WebappClassLoader validateJarFile 信息: validateJarFile(D:\Tomcat7.0*\apache-tomcat-7.0*\webapps\smgou\WEB-INF\lib\servlet-api.jar) - jar not loaded. See Servlet Spec 3.0, section 10.7.2. Offending class: javax/servlet/Servlet.class 10:51:56.741 ERROR org.hibernate.util.JDBCExceptionReporter - Access denied for user 'root'@'localhost' (using password: YES) 10:51:56.745 ERROR org.hibernate.util.JDBCExceptionReporter - Access denied for user 'root'@'localhost' (using password: YES) 2017-8-3 10:52:00 org.apache.catalina.core.ApplicationContext log 信息: Initializing Spring root WebApplicationContext 2017-8-3 10:52:13 org.apache.catalina.core.ApplicationContext log 信息: Initializing Spring FrameworkServlet 'JspGouAdmin' 2017-8-3 10:52:14 org.apache.catalina.core.ApplicationContext log 信息: Initializing Spring FrameworkServlet 'JspGouFront' 2017-8-3 10:52:16 org.apache.catalina.startup.HostConfig deployDirectory 信息: Deployment of web application directory D:\Tomcat7.0*\apache-tomcat-7.0*\webapps\smgou has finished in 20,009 ms 2017-8-3 10:52:16 org.apache.coyote.AbstractProtocol start 信息: Starting ProtocolHandler ["http-bio-8080"] 2017-8-3 10:52:16 org.apache.coyote.AbstractProtocol start 信息: Starting ProtocolHandler ["ajp-bio-8009"] 2017-8-3 10:52:16 org.apache.catalina.startup.Catalina start 信息: Server startup in 110998 ms Exception in thread "Timer-0" org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session for transaction; nested exception is org.hibernate.exception.GenericJDBCException: Cannot open connection at org.springframework.orm.hibernate3.HibernateTransactionManager.doBegin(HibernateTransactionManager.java:596) at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:371) at org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:335) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:105) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202) at com.sun.proxy.$Proxy12.findById(Unknown Source) at com.jspgou.cms.manager.impl.UpdateMngImpl$PlainTimerTask.run(UpdateMngImpl.java:114) at java.util.TimerThread.mainLoop(Timer.java:512) at java.util.TimerThread.run(Timer.java:462) Caused by: org.hibernate.exception.GenericJDBCException: Cannot open connection at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:140) at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:128) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:52) at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:449) at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:167) at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:160) at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:81) at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1473) at org.springframework.orm.hibernate3.HibernateTransactionManager.doBegin(HibernateTransactionManager.java:555) ... 9 more Caused by: java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3536) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3468) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:917) at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3974) at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1282) at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2142) at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:773) at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46) at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) at java.lang.reflect.Constructor.newInstance(Constructor.java:513) at com.mysql.jdbc.Util.handleNewInstance(Util.java:406) at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:352) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:282) at java.sql.DriverManager.getConnection(DriverManager.java:582) at java.sql.DriverManager.getConnection(DriverManager.java:154) at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriverManager(DriverManagerDataSource.java:173) at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriver(DriverManagerDataSource.java:164) at org.springframework.jdbc.datasource.AbstractDriverBasedDataSource.getConnectionFromDriver(AbstractDriverBasedDataSource.java:149) at org.springframework.jdbc.datasource.AbstractDriverBasedDataSource.getConnection(AbstractDriverBasedDataSource.java:119) at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:81) at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:446) ... 14 more |
||
---|---|---|---|
级别: 版主
|
7# 发表于:2017-08-03 10:53:42 IP:106.240.*.*
打开MySQL目录下的my.ini文件,在文件的最后添加一行“skip-grant-tables”,保存并关闭文件。(WIN7默认安装,my.ini在C:\ProgramData\MySQL\MySQL Server 5.6)
重启MySQL服务。 通过命令行进入MySQL的BIN目录,输入“mysql -u root -p”(不输入密码),回车即可进入数据库。(WIN7默认安装,BIN目录为:C:\Program Files\MySQL\MySQL Server 5.6\bin) 执行“use mysql;”,使用mysql数据库。 执行“update user set password=PASSWORD("123456") where user='root';”(修改root的密码) 打开MySQL目录下的my.ini文件,删除最后一行的“skip-grant-tables”,保存并关闭文件。 重启MySQL服务。 在命令行中输入“mysql -u root -p 123456”,即可成功连接数据库。 |
||
---|---|---|---|
级别: 白丁
|
8# 发表于:2017-08-03 10:53:45 IP:183.140.*.*
回复第5楼
这种方法是重设密码可以,也试过了,tomcat一发布还是报错。 |
||
---|---|---|---|
级别: 白丁
|
10# 发表于:2017-08-03 10:56:28 IP:183.140.*.*
在另外写了一个类来测试,是可以正常连接的应该,不知为什么在那里配置后不行。
|
||
---|---|---|---|