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 that occur when you use Workbench 6.3.5 to connect to MySQL Database on Azure

By default, Workbench 6.3.5 selects an 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:

  1. Download the certificate.
  2. 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:

    Workbench 6.3.5SSL connection methods

You can also select versions earlier than 6.3.5, which do not have this problem.

Connection problems that occur when you use SQLyog to connect to MySQL Database on Azure

If the user name is longer than 16 characters, the client automatically truncates it to the first 16 characters. This truncation causes connection issues. Use the latest version of the SQLyog client or a different MySQL management client, such as MySQL Workbench.