DBeaver Forum

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

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

Thanks for the information!

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