wonder sonic, Your first problem, I think, is that you have not flushed the tables to make the new user permissions take effect. Check out the docs for the mysqladmin tool.
As for the second, try the SQL statement from the command line to see where it is malformed. This might help you debug the problem. >From the partial SQL statement, it looks as if a comma is needed between the CONSTRAINT clause and the PRIMARY KEY clause. Good luck, - Mike Hewitt [EMAIL PROTECTED] -----Original Message----- From: wonder sonic [mailto:[EMAIL PROTECTED]] Sent: Friday, June 07, 2002 5:27 AM To: [EMAIL PROTECTED] Subject: [JBoss-user] MySQL strange behaviour Hi, I've done it (mysql and jboss 3.0 communication) but... -1- I can't connect with the user/password I want though I've added the user/password in mysql.user and granted all on my db for this user. The only user who have access is 'root' (without password). -2- After JBoss created the first SQL table (for the 1st CMP entity bean deployment), I get the following error: <snip> _______________________________________________________________ Don't miss the 2002 Sprint PCS Application Developer's Conference August 25-28 in Las Vegas -- http://devcon.sprintpcs.com/adp/index.cfm _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user