Client compatibility issues
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 may encounter compatibility issues with some versions of some clients. These issues are summarized below.
Connection problems when you 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 on Azure and Workbench 6.3.5. As a workaround, please configure the SSL certificate for use. See SSL secure access to MySQL Database on Azure. You must also specify AES256-SHA in SSL_Cipher, as shown in the picture below. Alternatively, choose a version earlier than 6.3.5.
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 the user name 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.