Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
986 questions
Cannot connect to MySQLServer Azure database from MySQL Workbench
![](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(300.8, 99%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EG1%3C/text%3E%3C/svg%3E)
GkM-1383
0
Reputation points
Hello all, I have created an Azure database for MySQL flexible server but it is not possible to establish connection to that server from the MySQL Workbench client installed on my PC (Windows 11). I have gone through the documentation to troubleshoot this type of connectivity issue and read the existing threads but the issue still persists. Note that I have done a series of pings to test the availability of that MySQL Server:
- They all fail when executed from my laptop's command line tool using psping or telnet, or from my laptop's PowerShell client using psping.
- BUT they succeed when executed from the Azure environment with Azure Cloud Shell using the mysql command.
You will find below all the details about the setup of this server and how the connection was defined in MySQL Workbench. Can you please advise? Thanks, GK
> ------
>
> Service : Azure database for MySQL flexible server
> Server name : devop-myserver1.mysql.database.azure.com
> Server admin login name : devopadmin
> Server features :
>
> 1) Compute & storage :
> - Standard_B1ms is the compute resource.
> - MySQL version : 5.7
> - The server is ON
>
> 2) Networking :
> - Public access is enabled and the firewall rule allows connections from all IP addresses (from 0.0.0.0 to 255.255.255.255)
> - Public access from any Azure service within Azure to this server : ON
>
> 3) Server parameters :
> - max_user_connections : 1
> - require_secure_transport : ON
> - tls_version : TLSV1.2
> - connect_timeout : 60 seconds (rather than 10 seconds)
>
> -----
>
> My Laptop : Personal computer (PC) equipped with Windows 11
> The firewall is disabled on this computer and the antivirus firewall was disabled during the tests.
> So there are no restrictions for inbound and outbound connections from this machine.
>
> -----
>
> MySQL Workbench version installed on my laptop : 8.0
> Connection details:
> - Connection name : devopConnection
> - Connection method : Standard (TCP/IP)
> - Connections parameters :
> * Hostname : devop-myserver1.mysql.database.azure.com
> * Port : 3306
> * Username : devopadmin
> * Password : ********* (obfuscated)
> - SSL tab:
> * Use SSL : "Require"
> * SSL CA File : C:\Users\Unknown\Desktop\DigiCertGlobalRootCA.crt.pem
>
> -----
>
> ```
Azure Database for MySQL
{count} votes
-
GeethaThatipatri-MSFT 29,542 Reputation points Microsoft Employee Moderator2023-08-14T18:06:20.69+00:00 Hi, @GkM-1383 Welcome to Microsoft Q&A thanks for posting your question
I hope the MySQL Workbench client is configured correctly and there are no network issues. what is the error you are getting can you share some screenshots from Workbench?
Regards
Geetha
-
GkM-1383 0 Reputation points
2023-08-16T11:02:59.84+00:00 Hello @GeethaThatipatri-MSFT , thanks for your reply.
Please find below two screenshots of the error I get in MySQL Workbench - I am attaching 2 screenshots so as to let you review how I configured the Parameters tab and the SSL tab in Workbench. This error message pops up when I am hitting the "Test Connection" button.
The other configuration details are described in my first post.
Thanks,
-
GeethaThatipatri-MSFT 29,542 Reputation points Microsoft Employee Moderator
2023-08-16T13:22:59.55+00:00 @GkM-1383 Thanks for sharing the screenshot, I hope you added the firewall too, Just for the testing can you try connecting from Azure Data Studio if you have ADS installed? so we can debug more on this.
Extension for Azure Mysql https://learn.microsoft.com/en-us/sql/azure-data-studio/extensions/mysql-extension?view=sql-server-ver16
Regards
Geetha
-
GkM-1383 0 Reputation points
2023-08-16T20:13:56.2666667+00:00 Hi @GeethaThatipatri-MSFT , thanks for the advice.
- First of all, here is a screenshot of the current firewall rule implemented on the server (in the networking tab):
As you can see, this inbound rule authorizes all existing IP addresses.
- Second, I have downloaded Azure Data Studio. Here are the details of the MySQL connection I tried to create:
Then, when hitting the "Connect" button, I got the following window after a few seconds:
I could then add my account successfully and was then suggested 2 options to add a firewall rule:
- I first attempted to "Add my client IP", but got the following error message after hitting "ok":
- And tried then to "Add my subnet IP range", but got the same error message after hitting the "ok" button:
What is the interpretation of these errors?
Best regards,
-
GkM-1383 0 Reputation points
2023-08-17T14:11:47.53+00:00 I eventually managed to find the root cause of this issue:
In addition to the firewall rules implemented at the Windows and/or the antivirus level, there is also a firewall integrated in the offer of the Internet services provider that needs to be adjusted.
To connect successfully to a remote MySQL server, this firewall has to be configured to authorize all the outbound connections.
These firewall rules come in addition to the ones defined at the Windows and/or antivirus level, and to the ones defined at the Azure MySQL flexible server level.
Many thanks for your support along the past days,
Best regards.
-
GeethaThatipatri-MSFT 29,542 Reputation points Microsoft Employee Moderator
2023-08-22T13:41:53.05+00:00 @GkM-1383 Thats good to know that your issue is now resolved
Thanks for visiting Microsoft Q&A Community have a great day!
Regards
Geetha
Sign in to comment
Sign in to answer