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

Rohan Jones 291 Reputation points
2020-05-14T02:08:30.073+00:00

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 for MariaDB
Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
713 questions
0 comments
Accepted answer
  1. Mike Ubezzi 2,776 Reputation points
    2020-05-16T17:45:00.067+00:00

    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.

    1 person found this answer helpful.

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. 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.

    0 comments