question

RohanJones-0800 avatar image
0 Votes"
RohanJones-0800 asked JordanMerson-1438 edited

mysql on version 5.7 but hecking the server status states Server version is 5.6.42.0

8098-azure.jpgWe have a setup for azure mysql on version 5.7 according to the azure portal, however checking the server status states Server version is 5.6.42.0 MySQL Community Server (GPL). See attached.


azure-database-mysqlazure-database-mariadb
azure.jpg (73.6 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Mike-Ubezzi avatar image
1 Vote"
Mike-Ubezzi answered

In the service, a gateway is used to redirect the connections to server instances. After the connection is established, the MySQL client displays the version of MySQL set in the gateway, not the actual version running on your MySQL server instance. To determine the version of your MySQL server instance, use the SELECT VERSION(); command at the MySQL prompt.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

JordanMerson-1438 avatar image
0 Votes"
JordanMerson-1438 answered JordanMerson-1438 edited

@Mike-Ubezzi-MSFT This is an issue if you have an application that checks the DB version before running. If it has a >5.6 requirement, it will not run. The gateway needs to report the actual version of MySQL running on the server it is proxying.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.