On Sat, Mar 31, 2012 at 4:33 PM, Lee <[email protected]> wrote: > Hi Matt, > > Also having the same response from the server with this statement: >
I think we're kind of off in the weeds now. Can you do *anything* with the user in question? The example you're providing here is multiple statements in one query which *won't* work without enabling multiple queries in the datasource connection. But that's a separate issue. I just did some testing with a root MySQL user locally (used root just to make sure I would not run into permissions on the MySQL side) and I can create a table fine, so I have to believe it's something up with the user's permissions on the database side. Try something simpler, like just creating or dropping a table (and keep it to a single statement, not multiple statements in on query block), just to see if you can do anything beyond basic selects with that user. -- Matthew Woodward [email protected] http://blog.mattwoodward.com identi.ca / Twitter: @mpwoodward Please do not send me proprietary file formats such as Word, PowerPoint, etc. as attachments. http://www.gnu.org/philosophy/no-word-attachments.html -- online documentation: http://openbd.org/manual/ google+ hints/tips: https://plus.google.com/115990347459711259462 http://groups.google.com/group/openbd?hl=en
