Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
Azure Database for MYSQL - connection failed often
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(131.20000000000002, 94%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELN%3C/text%3E%3C/svg%3E)
Lakshmi Narayanan
71
Reputation points
HI,
I have a Production Database as Azure Database for MYSQL. But its connection failed often. I cant find the issues. Can any one please tell me the reason and how to solve this issues? Its very urgency.
Azure Database for MySQL
{count} votes
-
Martin Cairney 2,266 Reputation points2021-08-11T07:51:55.217+00:00 What connection errors do you get? The error will normally give some help in identifying the cause, otherwise there is no scope to help you
-
Lakshmi Narayanan 71 Reputation points
2021-08-11T08:29:48.547+00:00 I got this error while connecting DB via Workbench.
-
Oury Ba-MSFT 21,126 Reputation points Microsoft Employee Moderator2021-08-11T19:53:04.32+00:00 Hi @Lakshmi Narayanan Thank you for posting your question. Azure Database for MySQL Flexible Server provides two ways to connect to your server: Which one are you using ?
Public access (allowed IP addresses)
Private access (VNet Integration)
When you use public access, access to your server is limited to allowed IP addresses that you add to a firewall rule. This method prevents external applications and tools from connecting to the server and any databases on the server, unless you create a rule to open the firewall for a specific IP address or range. When you use private access (VNet Integration), access to your server is limited to your virtual network.Regards,
Oury -
Lakshmi Narayanan 71 Reputation points
2021-08-12T05:43:45.07+00:00 HI ,
Im using Azure Database for MYSQL server. Not flexible server.
I denied public access of MYSQL server and added firewall rules to allow to access the MYSQL from my local machine as well production servers.But when i try to connect the Azure Database for MYSQL from my local machine as workbench, its thrown errors
ssl connection error: socket layer receive errorMySQL workbench version 6.3
I have disabled SSL setting in Azure Database for MYSQL server
When i try to connect the Azure Database for MYSQL from my linux machine terminal
mysql -h hostname -u uname -p -P 3306
iIts connected.
I can connect to Azure Database for MYSQL through my linux local machine (terminal), whereas i cant connect from my windows local machine (workbench).
Workbench throwing "ssl connection error: socket layer receive error"
-
Oury Ba-MSFT 21,126 Reputation points Microsoft Employee Moderator
2021-08-12T20:34:03.263+00:00 Hi @Lakshmi Narayanan I will suggest to try a different version of Workbench to see if that will help. Please refer to this similar issue posted on StackOverflow.
Regards,
Oury -
Lakshmi Narayanan 71 Reputation points
2021-08-13T02:29:14.117+00:00 Hi,
I have solved my errors. Just i posted my answer on stackoverflow. Pls have a look.
Sign in to comment
Sign in to answer