Azure-docs: Unable to connect Azure MySql via terminal or mysql client

Created on 15 Nov 2018  Â·  7Comments  Â·  Source: MicrosoftDocs/azure-docs

I have followed the official tutorial to create azure mysql database
https://docs.microsoft.com/en-us/azure/mysql/quickstart-create-mysql-server-database-using-azure-cli
, the server has created but i am unable to connect it from my pc via terminal or workbench. Following is the error that i am receiving.
ERROR 2003 (HY000): Can't connect to MySQL server on 'xxxxxxxx.mysql.database.azure.com' (60)
Can you please tell me any workaround for this ? Thank you.


Document Details

⚠ Do not edit this section. It is required for docs.microsoft.com ➟ GitHub issue linking.

cxp in-progress mysql-databassvc mysqsvc product-question triaged

Most helpful comment

@ajlam I just talked to our network guy, seems like it is because of our corporate network and firewall. I was able to connect outside of our work network.

Maybe you can include this as a notice in the tutorial.

All 7 comments

@omeraslam305 Thank you for your question. We are investigating the issue.

@omeraslam305 Do you have a firewall rule in place to allow traffic from the PublicIP address your PC has currently been issues? You can use a service such as: https://www.whatismyip.com/ to identify what your PublicIP address is, and add that to your firewall rules.

If you navigate to the Connection security blade for your MySQL instance, you can then add the PublicIP address where you are attempting to connect from:

screenshot 3

@omeraslam305 We will now proceed to close this thread. If there are further questions regarding this matter, please comment and we will gladly continue the discussion.

I am having the same issue. Followed the tutorial, added firewall rule and all. But no luck.

@metin, is the error message the same as the original poster's? Also, is SSL enabled or disabled on the server?

@ajlam I just talked to our network guy, seems like it is because of our corporate network and firewall. I was able to connect outside of our work network.

Maybe you can include this as a notice in the tutorial.

@metin, thanks for the feedback. Will look to see how we can improve the quickstart with a warning/notice.

Was this page helpful?
0 / 5 - 0 ratings

Related issues

DeepPuddles picture DeepPuddles  Â·  3Comments

JeffLoo-ong picture JeffLoo-ong  Â·  3Comments

spottedmahn picture spottedmahn  Â·  3Comments

jebeld17 picture jebeld17  Â·  3Comments

mrdfuse picture mrdfuse  Â·  3Comments