Page 1 of 1

mySQL 5.6.7 "show databases" results in syntax error.

PostPosted: Wed Oct 24, 2012 7:50 pm
by owllf
Hi,

I recently upgraded to mySQL 5.6.7 and now executing queries like

show databases ; or show variables like '%version%'; have this error:

[1064] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'OPTION SQL_SELECT_LIMIT=200' at line 1

Is there any way to work around this problem?

The select queries work fine with mySQL 5.6.7

Thank you,
Larisa

Re: mySQL 5.6.7 "show databases" results in syntax error.

PostPosted: Wed Oct 24, 2012 8:41 pm
by owllf
Solved my own problem :)
Download new Connector/J from http://dev.mysql.com/downloads/connector/j/
and used this driver instead of the default one.

Larisa

Re: mySQL 5.6.7 "show databases" results in syntax error.

PostPosted: Thu Oct 25, 2012 9:32 am
by Serge
Thanks for the information!

I think we should update MySQL driver (Connector/J) in mysql extension in future stable release version.