Why can't I connect to mysql database on azure from home computer?

Question

I have a MYSQL database setup on azure. I have set the networking up for public access and opened it up for any IP to access (for testing).

I can access it by logging into Azure without issue.

I have a LAMP server running on my home computer. I configured the phpmyadmin to access the MYSQL database on Azure using the connection string and creds provided. But it will not connect.

Can anyone assist with this? Is this something I can do?

I also tried using the same creds to connect from my work computer with mysql workbench...did not work.

I was thinking that the WAMP and LAMP servers were conflicting with port 3306. Could that be the issue? Also, my work firewall may be an issue...have to deal with corporate for that. But home system should have worked.

Any and all assistance is greatly appreciated.

Regards,

Mike

Answer 1

Michael Eller

Thank you for posting your solution so that others experiencing the same thing can easily reference this!

Since the Microsoft Q&A community has a policy that "The question author cannot accept their own answer. They can only accept answers by others ", I'll repost your solution in case you'd like to "Accept " the answer. Accepted answers show up at the top, resulting in improved discoverability for others.

Issue: Unable to connect to my Azure MYSQL flex sever from home computer

Solution: "It turns out it was the firewall setting. I had my corporate guys make a rule for the required port and everything connected right up."

If your issue remains unresolved or have further questions, please let us know in the comments how we can assist. We are here to help you and strive to make your experience better and greatly value your feedback.

Regards,

Oury