适用于MySQL的Azure数据库 [英] Azure Database for MySQL

问题描述

我使用Azure数据库为MySQL创建一个MySQL环境（服务器）。

我尝试连接到在我的本地计算机上使用MySQL Workbench的服务器，我收到此错误："在读取最终连接信息时丢失了与MySQL服务器的连接"系统错误2.我无法连接到数据库。

还有一个问题，我有Web App服务，必须使用MySQL服务器，我无法链接两台服务器。

我更改了我的MySQL服务上的连接安全规则，但没有：

- 允许Azure服务：是

- 规则：允许使用0.0.0.0和255.255.255.255

- SSL：false

感谢您的帮助。

解决方案

嗨Lorenzon，

请确保启用SSL，然后再试一次。防火墙规则没问题，但应缩小到特定的IP范围或特定的IP地址列表。 "允许Azure服务"用于连接其他Azure服务，而无需设置额外的
防火墙规则，例如Web App服务。

在此特定情况下，MySQL Workbench正在关闭连接，因为没有SSL存在。请确保启用最简单的SSL选项。 

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. 

这篇关于适用于MySQL的Azure数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！