Hi,
I create a MySQL environment (server) with Azure Database for MySQL.
I try to connect to the server with MySQL Workbench on my local computer and i get this error : "lost connection to MySQL server at reading final connect information" system error 2. I can't connect to the database.
One more problem, i have Web App service, which must use the MySQL server, and i can't link two servers.
I change connexion security rules on my MySQL service, but nothing:
- Allow Azure services : yes
- Rules : Allowall with 0.0.0.0 and 255.255.255.255
- SSL : false
Thanks for your help.
解决方案Hi Lorenzon,
Can you please ensure SSL is enabled, and try this again. The firewall rule is okay but should be narrowed down to a specific IP range or specific list of IP addresses. The `Allow Azure services` is for other Azure services to connect without setting additional
firewall rules, such as the Web App service.
In this specific case MySQL Workbench is closing down the connection because there is no SSL present. Please ensure that the simplest of SSL options is enabled.