为了账号安全,请及时绑定邮箱和手机立即绑定

Hibernate链接MySQL数据库失败Access denied for user 'hung'@'localhost' (using password: NO)

Hibernate链接MySQL数据库失败Access denied for user 'hung'@'localhost' (using password: NO)

鸿泽 2016-02-21 01:05:48
麻烦大神看一下,这里是我的配置文件:<?xml version='1.0' encoding='UTF-8'?><!DOCTYPE hibernate-configuration PUBLIC    "-//Hibernate/Hibernate Configuration DTD 3.0//EN"    "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd"><hibernate-configuration>    <session-factory>        <property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>        <property name="hibernate.connection.url">jdbc:mysql://localhost:3306/hibernate_test</property>        <property name="hibernate.connection.username">hung</property>        <property name="hibernate.conenction.password">hungpass</property>        <property name="dialect">org.hibernate.dialect.MySQLDialect</property>        <!-- 显示sql语句 -->        <property name="show_sql">true</property>        <property name="format_sql">true</property>        <!-- DDL语句生成策略 -->        <property name="hbm2ddl.auto">create</property>        <mapping resource="com/entity/User.hbm.xml" />    </session-factory></hibernate-configuration>具体错误信息如下:ERROR: HHH000231: Schema export unsuccessfuljava.sql.SQLException: Access denied for user 'hung'@'localhost' (using password: NO)    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:959)    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3870)    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3806)    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:871)    at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1686)    at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1207)    at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2254)    at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2285)    at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2084)    at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:795)    at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:44)    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:422)    at com.mysql.jdbc.Util.handleNewInstance(Util.java:404)    at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:400)    at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:327)    at org.hibernate.service.jdbc.connections.internal.DriverManagerConnectionProviderImpl.getConnection(DriverManagerConnectionProviderImpl.java:204)    at org.hibernate.tool.hbm2ddl.SuppliedConnectionProviderConnectionHelper.prepare(SuppliedConnectionProviderConnectionHelper.java:51)    at org.hibernate.tool.hbm2ddl.DatabaseExporter.<init>(DatabaseExporter.java:52)    at org.hibernate.tool.hbm2ddl.SchemaExport.execute(SchemaExport.java:367)    at org.hibernate.tool.hbm2ddl.SchemaExport.create(SchemaExport.java:304)    at org.hibernate.tool.hbm2ddl.SchemaExport.create(SchemaExport.java:293)    at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:500)    at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1790)    at com.daoImpl.Test.main(Test.java:16)Feb 21, 2016 12:59:12 AM org.hibernate.tool.hbm2ddl.SchemaExport executeINFO: HHH000230: Schema export completeFeb 21, 2016 12:59:12 AM org.hibernate.engine.jdbc.spi.SqlExceptionHelper logExceptionsWARN: SQL Error: 1045, SQLState: 28000Feb 21, 2016 12:59:12 AM org.hibernate.engine.jdbc.spi.SqlExceptionHelper logExceptionsERROR: Access denied for user 'hung'@'localhost' (using password: NO)Exception in thread "main" org.hibernate.exception.GenericJDBCException: Could not open connection    at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:54)    at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:125)    at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:110)    at org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.obtainConnection(LogicalConnectionImpl.java:221)    at org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.getConnection(LogicalConnectionImpl.java:157)    at org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.doBegin(JdbcTransaction.java:67)    at org.hibernate.engine.transaction.spi.AbstractTransactionImpl.begin(AbstractTransactionImpl.java:160)    at org.hibernate.internal.SessionImpl.beginTransaction(SessionImpl.java:1426)    at com.daoImpl.Test.main(Test.java:18)Caused by: java.sql.SQLException: Access denied for user 'hung'@'localhost' (using password: NO)    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:959)    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3870)    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3806)    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:871)    at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1686)    at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1207)    at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2254)    at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2285)    at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2084)    at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:795)    at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:44)    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:422)    at com.mysql.jdbc.Util.handleNewInstance(Util.java:404)    at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:400)    at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:327)    at org.hibernate.service.jdbc.connections.internal.DriverManagerConnectionProviderImpl.getConnection(DriverManagerConnectionProviderImpl.java:204)    at org.hibernate.internal.AbstractSessionImpl$NonContextualJdbcConnectionAccess.obtainConnection(AbstractSessionImpl.java:292)    at org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.obtainConnection(LogicalConnectionImpl.java:214)    ... 5 more请大神看一下,弄了2个小时了,还是不行
查看完整描述

2 回答

?
Leihope丶

TA贡献1条经验 获得超0个赞

你的这个conenction写错啦

查看完整回答
反对 回复 2017-07-11
?
HansonQ

TA贡献223条经验 获得超56个赞

确定看下mysql的数据库服务器启动了


查看完整回答
反对 回复 2016-02-22
  • 2 回答
  • 0 关注
  • 4492 浏览
慕课专栏
更多

添加回答

举报

0/150
提交
取消
意见反馈 帮助中心 APP下载
官方微信