File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC 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
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: 31062
    
232

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.


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: MySQLSyntaxErrorException: Access denied