In other words, if you would like to connect to v5.7 gateway client, you should use your fully qualified server name and port 3308 to connect to your server from client application. In Azure Database for MySQL service, gateway nodes listens on port 3308 for v5.7 clients and port 3309 for v8.0 clients. However, if your application has a requirement to connect to specific major version say v5.7 or v8.0, you can do so by changing the port in your server connection string. Review Connectivity architecture to learn more about gateways in Azure Database for MySQL service architecture.Īs Azure Database for MySQL supports major version v5.7 and v8.0, the default port 3306 to connect to Azure Database for MySQL runs MySQL client version 5.6 (least common denominator) to support connections to servers of all 2 supported major versions. To determine the version of your MySQL server instance, use the SELECT VERSION() command at the MySQL prompt. 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. In the Single Server deployment option, a gateway is used to redirect the connections to server instances. Connect to a gateway node that is running a specific MySQL version For more information about the scheme, see the MySQL documentation. MySQL uses the X.Y.Z naming scheme where X is the major version, Y is the minor version, and Z is the bug fix release. The service supports all the current major version supported by the community namely MySQL 5.7 and 8.0. Azure Database for MySQL has been developed from MySQL Community Edition, using the InnoDB storage engine.
0 kommentar(er)
