Yeah, this is totally related to MySQL user permissions. Have you
granted rights to a user?
CREATE DATABASE grporder;
GRANT ALL ON grporder.* TO myuse..ocalhost IDENTIFIED BY "mypass"
e.
On Feb 10, 2005, at 6:51 PM, Joel Trunick wrote:
>
> I realize this may be specific to MySQL, but figured someone here has
> probably seen this. I seem to connect to the database OK (top 3 lines
> below), but on commit, it complains that Access Denied (bottom 2
> lines),
> with a _different_ user.
>
> What causes this?
>
> J
>
>
>
> [junit] Login: joel
> [junit] Password: *******
> [junit] INFO QueryLogger: +++ Connecting: SUCCESS.
> [junit] INFO QueryLogger: LOCK TABLES AUTO_PK_SUPPORT WRITE
> [junit] INFO QueryLogger: UNLOCK TABLES
> [junit] Testsuite: go.test.LogicTest
> [junit] Tests run: 1, Failures: 0, Errors: 1, Time elapsed: 0.711
> sec
>
> [junit] Testcase: testCayenne(go.test.LogicTest): Caused an ERROR
> [junit] [v.1.1 December 6 2004] Commit Exception
>
> ...
>
> [junit] at go.test.LogicTest.testCayenne(LogicTest.java:30)
> [junit] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native
> Method)
> [junit] at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAcces
> sorImpl.java:39)
> [junit] at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMet
> hodAccessorImpl.java:25)
> [junit] Caused by: java.sql.SQLException: General error: Access
> denied for user: ..ocalhost' to database 'grporder'
>
This archive was generated by hypermail 2.0.0 : Thu Feb 10 2005 - 19:10:13 EST