Issues with DB version Azure Database for MySQL

[skididida]

Hello all,

First of all thanks in advance for any help.
I am a novice Zabbix user and am upgrading my monitoring infrastructure to the Zabbix 6.0 LTS version.
Currently I operate Zabbix version 5.4 in Azure, with the database hosted as an Azure Database for MySQL server.
I noticed before that Zabbix (5.4) did not recognize the DB server version correctly, so I override with the parameter to allow for unsupported versions.
However this does not solve our problem. After upgrading Zabbix to 6.0 LTS the problem still persists and the server wont even start the upgrade.

The Zabbix server logs tell me:
2186:20220428:202144.613 Unsupported DB! MySQL version is 50647 which is smaller than minimum of 50728
2186:20220428:202144.613 Error! Current MySQL database server version is too old (5.06.47)
2186:20220428:202144.613 Must be a least 5.07.28
2186:20220428:202144.673 database could be upgraded to use primary keys in history tables

But interesting enough when I check our Azure Mysql database server version, it says we are running version 8.0.
When I open a MySQL workbench session to the MySQL Server instance and query for the DB version the server returns version 8.0.15
So the version seems to be fine and the DB upgrade should be started.

What am I missing here?

Anyone experienced the same issues?

Again any help is much appreciated.

Kind regards.

[sencersur]

You can use either Single Server or Flexible Server to host a MySQL database in Azure. It's a fully managed database as a service offering that can handle mission-critical workloads with predictable performance and dynamic scalability.

[sencersur]

If the application persistently fails to connect to Azure Database for MySQL, it usually indicates an issue with one of the following: Server firewall configuration: Make sure that the Azure Database for MySQL server firewall is configured to allow connections from your client, including proxy servers and gateways. feedback survey breakfast hours