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.
mysql on version 5.7 but hecking the server status states Server version is 5.6.42.0
Rohan Jones
291
Reputation points
We 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.
Accepted answer
1 additional answer
Sort by: Most helpful
-
Jordan Merson 1 Reputation point
2021-01-29T16:28:00.623+00:00 @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.