Client compatibility problems
MySQL Database on Azure uses MySQL Community Edition and is compatible with common MySQL management tools. During the actual operation and maintenance of MySQL Database on Azure, you might encounter compatibility issues with some versions of some clients. These issues are summarized below:
Connection problems occur when I use Workbench 6.3.5 to connect to MySQL Database on Azure.
By default, Workbench 6.3.5 selects SSL connection and uses “TLS-DHE-RSA-WITH-AES-256-CBC-SHA” for encryption. However, our proxy server does not currently support identification, which causes connectivity problems between MySQL Databse on Azure and Workbench 6.3.5. As a workaround, configure the use of SSL certificates by doing the following:
- Download the certificate.
- In workbench 6.3.5, under “SSL CA File,” locate the certificate, and then enter AES256-SHA in the “SSL Cipher,” box as shown in the following figure:
You can also select versions earlier than 6.3.5, which do not have this problem.
Connection problems when you use SQLyog to connect to MySQL Database on Azure
If the user name is longer than 16 characters, this client automatically truncates it to the first 16 characters. This causes connection issues. Use the latest version of the SQLyog client or a different MySQL management client, such as MySQL Workbench.