Connection to MySQL Database Fails with 'You have an error in your SQL syntax' Error

Still need help?

The Atlassian Community is here for you.

Ask the community


While trying to migrate to MySQL database, upon clicking on the "Test Connection" button, the following error is reported on screen:

Couldn't connect to database: 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 'where variable_name = 'collation_database'' at line 1. See logs for details.



Fisheye is being run with an unsupported version of MySQL - in this case 4.1.20.


Refer to the supported platforms guide and upgrade MySQL to a supported version.

Last modified on Nov 2, 2018

Was this helpful?

Provide feedback about this article
Powered by Confluence and Scroll Viewport.