wood burning stoves
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
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "MySQLSyntaxErrorException: Access denied" Watch "MySQLSyntaxErrorException: Access denied" New topic

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

Joined: May 26, 2003
Posts: 33124

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.)

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
I agree. Here's the link: http://aspose.com/file-tools
subject: MySQLSyntaxErrorException: Access denied
It's not a secret anymore!