I am trying to get external database access to my FirePOWER Management Center. I can connect to the database just fine with the drivers downloaded from the FMC, but every SELECT query that I issue gives me an error: "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=DEFAULT' at line 1".
This happens regardless of whether I manually specify a limit parameter in the query or not. For example, these two queries both return the same error: select count(first_packet_sec) from connection_log; select first_packet_sec from connection_log limit 10;
It looks like the MySQL version running on the FMC is 5.6.24 (the FMC itself is version 6.0.1 (build 1214)), and the "SET OPTION" command was deprecated and removed in MySQL 5.6. So the question is, where is that coming from and why?
