Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
JavaRanch.com/granny.jsp
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


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
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
internet detective
Marshal

Joined: May 26, 2003
Posts: 30130
    
150

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
 
wood burning stoves
 
subject: MySQLSyntaxErrorException: Access denied
 
Similar Threads
Hibernate DB2
[HIBERNATE] Not binding factory to JNDI, no JNDI name configured
Hibernate Exception [Unknown entity com. businessobjects. UserDataBO]
Error reading resource: hbm.xml file
How to create a dynamic web project using eclipse IDE?