DISCLAIMER: I'm a veteran programmer but brand new to this environment.

Short Version:
After upgrading to a new Mac and transferring everything with Time Machine, my Hibernate(/Spring/Tomcat/Eclipse) gets an "access denied" error when trying to connect to mySQL.

Long Version:
I have a server app built in Eclipse with Hibernate and Spring. Starting from SVN source, I was painstakingly able to get it working on an old Macbook. This week, I upgraded machines and transferred everything over with Time Machine. Now when I start the Tomcat server (running in Eclipse), I get this error:



As I understand it, the credentials for mySQL log-in are configured in hibernate.properties. On the original machine, I set user and password properties, and it has no problem.

Things I have done to isolate this issue:
I checked that mySQL is okay by running ./mysql from the command line with the same username and password.

I changed the username and password in hibernate.properties. The error message still had user 'john'.

I also notice that the message doesn't say (using password: YES) which I would have expected.

I am wondering if I missed some other place where I need to configure this login info? Or did Hibernate build some login record on the old machine and needs to be forced to regenerate it? I apologize if these questions are naive, but I've searched documentationa and help forums without luck. Thank you for any advice.

John

no nothing is stored elsewhere, it's all in your configuration. You might whish to check that you're actually using your properties file and not another way to configure Hibernate (like the xml, programmatic approach, persistence.xml)
I didn't understand is 'john' as a username is totally wrong.

Also check to have correct authorization relating to the domain name you're using to connect to MySQL. MySQL is very picky about it: you might have authorization connecting to "localhost" but get denied access when connecting to "yourmachinename".

Thank you. After my post yesterday, I narrowed it down to something like you described. I dumped and recreated the user "john" for "localhost" and "%" and the connection is working.

Now I am on to the next error. :)

Regards,
John