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

Kamil Krauze (Student) 0 Reputation points
2023-01-23T19:30:35.1+00:00

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
User's image

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.

Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
714 questions
{count} votes

7 answers

Sort by: Most helpful
  1. Curtis Jackson 0 Reputation points
    2023-09-23T21:31:24.1833333+00:00

    I am currently experiencing the issue despite doing everything that you suggested + download and use the public key for the CA certificate

    0 comments No comments

  2. Curtis Jackson 0 Reputation points
    2023-09-23T21:41:26.4566667+00:00

    I was able to resolve this by allowing all IPs starting from 0.0.0.0 and ending at 255.255.255.255 to do what I had to do then afterward removing the range because of the danger it poses

    0 comments No comments