Share via

Cannot connect to MySQL Server installed in Ubuntu 18.04, Firewall port 3306 opened globally

Akshay 1 Reputation point
2020-07-08T10:24:29.437+00:00

Cannot connect to MySQL Server installed in Ubuntu 18.04, Firewall port 3306 opened, IP address added and get: ERROR 2005

ERROR 2003 (HY000): Can't connect to MySQL server on 'IP address' (110)

Azure Virtual Machines
Azure Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.
7,242 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. vipullag-MSFT 24,636 Reputation points
    2020-07-08T10:47:37.853+00:00

    @Akshay-8028
    To check if the port is accessible from on public IP, can you try this link and check if the port is open.

    And if you see that the 3306 port is open, then please check the IP binding in /etc/mysql/my.cnf, you should bind the server external IP address and not the local bind-address 127.0.0.1

    Please 'Accept as answer' if the provided information is helpful, so that it can help others in the community looking for help on similar topics.

    0 comments