question

RohanJones-0800 avatar image
0 Votes"
RohanJones-0800 asked ·

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)
10 |1000 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.

1 Answer

Mike-Ubezzi-MSFT avatar image
1 Vote"
Mike-Ubezzi-MSFT 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.

· Share
10 |1000 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.