This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](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(44.800000000000004, 90%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
I have created a web app with a MySQL database (web app + database in Azure Marketplace), and everything is working fine. I have successfully deployed a PHP "Hello World" code. Now, I want to connect to the MySQL database using MySQL Workbench. So, I went to the flexible server and clicked on "Connect" to determine the connection parameters.
I went to the "Networking" section to download the SSL certificate as instructed (for your information, in the Networking section, everything is grayed out, and I am unable to add anything as shown in the image).
I have configured the connection with MySQL Workbench.
When I try to connect, I receive the famous error message.
I'm not sure why it's still trying to connect to localhost despite entering the server name as indicated in Azure (in the Connect section).
However, I'm open to exploring alternative solutions to connect to my MySQL database and explore it myself, as well as for developers.
thanks for your help.
Thank you for your quick response. Yes, I watched the video, and that's exactly what I did. Creating the database automatically with the web app was part of the process. I forgot what options I chose or what was selected. However, as mentioned in my screenshots above, if I go to the "Networking" section of my flexible server, everything is grayed out, and I cannot make any changes or additions, i can juste download SSL certificate
![](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(51.2, 79%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKP%3C/text%3E%3C/svg%3E)
Yes - I think this is the problem (I'm having as well). When you create a Web App + Database, it no longer allows you to select Public Access. A few months ago, you were able to edit the database in Networking and add an IP that it would allow to connect to it.
Ok, I found a workaround for the time being:
This is less than ideal but will work for now
I want to let you know that it works when I create a new Azure Database for MySQL flexible server independently of the Web App, and I have access to the Networking of the database to add my IP address to the firewall, enable external connections, etc. So, I'm not sure why it doesn't work when it's created directly with the Web App.
![](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(220.8, 4%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
Hi Morsi •,
Welcome to Microsoft Q&A forum and thanks for using Azure Services.
As I understand, you could not open Azure Database for MySQL through MySQL Workbench.
Could you please let us know what Network configuration is selected while creation of this flexible server?
Also refer to the below mentioned Youtube video for reference if this helps:
Connect & Query Azure Database for MySQL Flexible Server using MySQL Workbench
Thanks