MySQL 5.6 database is not compatible with MySQL 5.7 database type. Consider changing it to MySQL 5.6

Question

I'm getting this error with Azure Database for MySQL (5.7.29), please help!

Ziad Qadora · Answer

@Gavin You , this a know issue with Azure per their documentation Limitations in Azure Database for MySQL

Current known issues

* MySQL server instance displays the wrong server version after connection is established. To get the correct server instance engine version, use the select version(); command.

We faced the same issue, and we switched to managed DB instead of Azure MySQL.

Regards,

Ziad

Gavin You · Answer

I followed the steps and set all parameters, still no luck. I tried MySQL 8 on Azure as well, it showed: "MySQL 8 was selected but underlying database reports a different version." I guess we can't use any Azure Database for MySQL for Jira application?

Brant Schroeder · Answer

Gavin - Make sure that you follow all of the steps here: https://confluence.atlassian.com/adminjiraserver/connecting-jira-applications-to-mysql-5-7-966063305.html  and make sure everything is setup to connect to a MySQL 5.7 DB.