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

[Gavin You]

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

[Brant Schroeder]

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.

[Gavin You]

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?

[Ziad Qadora]

@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