[aharasymiw]

This may not be the right forum, however you have all been so helpful I am hoping you might be able to help me. When I deploy my SimpleBean application I get the error listed below:

ould not create connection; – nested throwable: (java.sql.SQLException: Invalid authorization specification, message from server: “Access denied for user: ‘supadmin@localhost.localdomain’ (Using password: YES)”)

I have ensured that supadmin has all privileges in mysql dabase and I have tried to connect manually successfully. The login information is in the mysql-ds.xml file in the deploy directory for the default server. Is there anything else that I need to do?

Thank you in advance

[aharasymiw]

After much searching the problem turned out to be my upgrade to mysql 4.0. I had to go into the tables for mysql and grant privileges to myuser@localhost.localdomain before anythingelse worked

[Scott Anderson]

We’re glad to hear that you figured it out and want to thank you very much for posting the follow-up here so that our other users can benefit from what you found.

[Author]

Posts