Unable to connect to MySQL flexible server on Azure on MySQL Workbench on PC.

Question

As the title says, I am unable to connect to the MySQL database that is hosted on Azure through the MySQL workbench app installed on my PC. I always get the error "Could connect to localhost" which is odd

Like I followed all of the steps provided on the "Connect" tab of the DB server, as you know by now, it does not connect.

Answer 1

Hi, @Kamil Krauze (Student) Welcome to the Microsoft Q&A platform, thanks for posting the question

I understand you are facing an issue while trying to connect the Azure Mysql server from the Mysql workbench.

1. Are you connecting from Azure (like Azure VM etc) or outside Azure?
2. Are you able to connect using MySQL command line client or mysql.exe? for your reference Connect to the server by using mysql.exe
3. Did you checked if the public IP of the client where your workbench is installed is whitelisted in em-nonprod-mysql-server-flex server?  Firewalls prevent all access to your database server until you specify which computers have permission. The firewall grants access to the server based on the originating IP address of each request. To configure a firewall, create firewall rules that specify ranges of acceptable IP addresses. You can create firewall rules at the server level. Firewall rules - Azure Database for MySQL | Microsoft Learn
   Regards Geetha

Answer 2

I am facing the same issue, Checked all the steps mentioned above

But still having the same error

Answer 3

Hi @GeethaThatipatri-MSFT - I'm facing the same issue/error. Also checked above input, but still no luck. Any other idea? Thanks! Levien

Answer 4

Comment deleted.

Answer 5

I have been having the same issue for the last 2 weeks connecting to our new Azure MySQL Flexible servers. I can use command line just fine to connect, but workbench errors out in both versions 8.0.33 and 8.0.34. Test connections are also successful, but actual connections get this error. I just tried 8.0.32 and it did work.