MySQLSyntaxErrorException: Access denied

[Daniel Prene]

I'm getting a "MySQLSyntaxErrorException: Access denied" although I have repeatidly varified that my username/password combination are in fact correct. I'm trying to use Hibernate+MySQL+Tomcat. I've tried both MySQL5Dialect and MySQLDialect. The following is my log:

11:46:13,721  INFO Environment:514 - Hibernate 3.2.5
11:46:13,794  INFO Environment:547 - hibernate.properties not found
11:46:13,838  INFO Environment:681 - Bytecode provider name : cglib
11:46:13,876  INFO Environment:598 - using JDK 1.4 java.sql.Timestamp handling
11:46:14,198  INFO Configuration:1426 - configuring from resource: /hibernate.cfg.xml
11:46:14,200  INFO Configuration:1403 - Configuration resource: /hibernate.cfg.xml
11:46:14,897  INFO Configuration:553 - Reading mappings from resource : com/octoberdan/twitter/poscc/mapping/user.hbm.xml
11:46:15,527  INFO HbmBinder:300 - Mapping class: com.octoberdan.twitter.poscc.User -> users
11:46:15,671  INFO Configuration:553 - Reading mappings from resource : com/octoberdan/twitter/poscc/mapping/device.hbm.xml
11:46:15,884  INFO HbmBinder:300 - Mapping class: com.octoberdan.twitter.poscc.Device -> devices
11:46:15,891  INFO Configuration:553 - Reading mappings from resource : com/octoberdan/twitter/poscc/mapping/event.hbm.xml
11:46:16,037  INFO HbmBinder:300 - Mapping class: com.octoberdan.twitter.poscc.Event -> events
11:46:16,046  INFO Configuration:553 - Reading mappings from resource : com/octoberdan/twitter/poscc/mapping/friend_relation.hbm.xml
11:46:16,137  INFO HbmBinder:300 - Mapping class: com.octoberdan.twitter.poscc.FriendRelation -> friend_relations
11:46:16,144  INFO Configuration:1541 - Configured SessionFactory: null
11:46:16,750  INFO DriverManagerConnectionProvider:41 - Using Hibernate built-in connection pool (not for production use!)
11:46:16,752  INFO DriverManagerConnectionProvider:42 - Hibernate connection pool size: 20
11:46:16,752  INFO DriverManagerConnectionProvider:45 - autocommit mode: false
11:46:16,832  INFO DriverManagerConnectionProvider:80 - using driver: org.gjt.mm.mysql.Driver at URL: jdbc:mysql:///localhost
11:46:16,833  INFO DriverManagerConnectionProvider:86 - connection properties: {user=twitter, password=****}
11:46:17,644  WARN SettingsFactory:117 - Could not obtain connection metadata
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Access denied for user 'twitter'@'localhost' to database 'localhost'
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2941)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:868)
at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3340)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1238)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:2743)
at com.mysql.jdbc.Connection.<init>(Connection.java:1553)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:154)
at org.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:110)
at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:84)
at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2009)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1292)
at com.octoberdan.twitter.hibernate.HibernateUtil$.<init>(HibernateUtil.scala:12)
at com.octoberdan.twitter.hibernate.HibernateUtil$.<clinit>(HibernateUtil.scala)
at com.octoberdan.twitter.services.DatabaseServices$class.save(DatabaseServices.scala:21)
at com.octoberdan.twitter.services.DeviceService$.save(DeviceService.scala:8)
at com.octoberdan.twitter.services.DeviceService$.saveDevice(DeviceService.scala:19)
at com.octoberdan.twitter.services.DeviceService$$anonfun$1$$anonfun$0.apply(DeviceService.scala:13)
at com.octoberdan.twitter.services.DeviceService$$anonfun$1$$anonfun$0.apply(DeviceService.scala:11)
at scala.actors.Reaction.run(Reaction.scala:55)
at scala.actors.FJTask$Wrap.run(Unknown Source)
at scala.actors.FJTaskRunner.scanWhileIdling(Unknown Source)
at scala.actors.FJTaskRunner.run(Unknown Source)
11:46:17,705  INFO Dialect:152 - Using dialect: org.hibernate.dialect.MySQL5Dialect
11:46:17,722  INFO TransactionFactoryFactory:34 - Transaction strategy: org.hibernate.transaction.JDBCTransactionFactory
11:46:17,730  INFO TransactionManagerLookupFactory:33 - No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
11:46:17,731  INFO SettingsFactory:143 - Automatic flush during beforeCompletion(): disabled
11:46:17,731  INFO SettingsFactory:147 - Automatic session close at end of transaction: disabled
11:46:17,741  INFO SettingsFactory:162 - Scrollable result sets: disabled
11:46:17,742  INFO SettingsFactory:170 - JDBC3 getGeneratedKeys(): disabled
11:46:17,742  INFO SettingsFactory:178 - Connection release mode: auto
11:46:17,744  INFO SettingsFactory:202 - Maximum outer join fetch depth: 2
11:46:17,745  INFO SettingsFactory:205 - Default batch fetch size: 1
11:46:17,745  INFO SettingsFactory:209 - Generate SQL with comments: disabled
11:46:17,746  INFO SettingsFactory:213 - Order SQL updates by primary key: disabled
11:46:17,746  INFO SettingsFactory:217 - Order SQL inserts for batching: disabled
11:46:17,747  INFO SettingsFactory:386 - Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
11:46:17,754  INFO ASTQueryTranslatorFactory:24 - Using ASTQueryTranslatorFactory
11:46:17,755  INFO SettingsFactory:225 - Query language substitutions: {}
11:46:17,756  INFO SettingsFactory:230 - JPA-QL strict compliance: disabled
11:46:17,756  INFO SettingsFactory:235 - Second-level cache: enabled
11:46:17,757  INFO SettingsFactory:239 - Query cache: disabled
11:46:17,757  INFO SettingsFactory:373 - Cache provider: org.hibernate.cache.NoCacheProvider
11:46:17,758  INFO SettingsFactory:254 - Optimize cache for minimal puts: disabled
11:46:17,758  INFO SettingsFactory:263 - Structured second-level cache entries: disabled
11:46:17,767  INFO SettingsFactory:290 - Statistics: disabled
11:46:17,767  INFO SettingsFactory:294 - Deleted entity synthetic identifier rollback: disabled
11:46:17,768  INFO SettingsFactory:309 - Default entity-mode: pojo
11:46:17,768  INFO SettingsFactory:313 - Named query checking : enabled
11:46:17,926  INFO SessionFactoryImpl:161 - building session factory

The configuration:

<?xml version="1.0" ?>
<!DOCTYPE hibernate-configuration PUBLIC 
"-//Hibernate/Hibernate Configuration DTD//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd" >
 
<!-- This will be replaced by the hibernate ant tasks soon -->
<hibernate-configuration>
    <session-factory>
        <!--MySQL JDBC Driver connection -->
        <property name="connection.driver_class">org.gjt.mm.mysql.Driver</property>
        <property name="connection.url">jdbc:mysql:///localhost</property>
        <property name="connection.username">twitter</property>
        <property name="connection.password">twitterpass</property>
        <property name="dialect">org.hibernate.dialect.MySQLDialect</property>
        <property name="transaction.factory_class">
         org.hibernate.transaction.JDBCTransactionFactory
        </property>

        <!-- Mapping files -->
        <mapping resource="com/octoberdan/twitter/poscc/mapping/user.hbm.xml"/>
        <mapping resource="com/octoberdan/twitter/poscc/mapping/device.hbm.xml"/>
        <mapping resource="com/octoberdan/twitter/poscc/mapping/event.hbm.xml"/>
        <mapping resource="com/octoberdan/twitter/poscc/mapping/friend_relation.hbm.xml"/>        
    </session-factory>
</hibernate-configuration>

Any and all help will be greatly appreciated! Thank you for at least reading this :-)
[ November 03, 2007: Message edited by: Daniel Prene ]

[Jeanne Boyarsky]

Daniel,
What is your MySQL database name? Where is it specified in the code/configuration?

Usually a URL looks something like this: (I don't remember which format mySql uses off the top of my head.)
jdbc:mysql://localhost/db
jdbc:mysql://localhost@db

Localhost is the name of the machine. Db is the name of the database on the machine.