mySQL 5.6.7 "show databases" results in syntax error.

Note: please leave bug reports and feature requests on

mySQL 5.6.7 "show databases" results in syntax error.

Postby owllf » Wed Oct 24, 2012 7:50 pm

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
owllf
 
Posts: 2
Joined: Wed Oct 24, 2012 7:25 pm

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

Postby owllf » Wed Oct 24, 2012 8:41 pm

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
owllf
 
Posts: 2
Joined: Wed Oct 24, 2012 7:25 pm

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

Postby Serge » Thu Oct 25, 2012 9:32 am

Thanks for the information!

I think we should update MySQL driver (Connector/J) in mysql extension in future stable release version.
Serge
 
Posts: 1526
Joined: Sat Feb 26, 2011 8:24 pm
Location: SPb


Return to Support



Who is online

Users browsing this forum: Google [Bot] and 5 guests