jQuery in Action, 3rd edition
The moose likes JDBC and Relational Databases and the fly likes MySQLSyntaxErrorException: Access denied Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Building Microservices this week in the Design forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "MySQLSyntaxErrorException: Access denied" Watch "MySQLSyntaxErrorException: Access denied" New topic
Author

MySQLSyntaxErrorException: Access denied

Daniel Prene
Ranch Hand

Joined: Jul 15, 2005
Posts: 241
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:



The 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
author & internet detective
Marshal

Joined: May 26, 2003
Posts: 32507
    
214

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.


[OCA 8 book] [Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2
 
Have you checked out Aspose?
 
subject: MySQLSyntaxErrorException: Access denied
 
It's not a secret anymore!