It looks like weird happening, I've followed and fixed all the possible things but still MySQL port 3306 is not accessible remotely.
Here's my setup:
Machine: Windows Server 2012 R2
MySQL Server: 8.xx
Settings have been applied:
- In
my.inibind-addressdid to 0.0.0.0 and and thus after exec commandnetstat -anthis is what I getTCP 0.0.0.0:3306 0.0.0.0:0 LISTENING - From Windows Firewall I've enabled port
3306inbound/outbound both. and set that toallow edge traversalas well - From the MySQL server I've created a user with
%all host and then provided permission to all databases as well. which has been checked
I guess these are the actions I took afterward. But this is not working at all.
When I'm trying to do telnet server_ip 3306 error: Connecting To server_ip ...Could not open a connection to the host, on port 3306: Connect failed from other machines. The local host is working fine.
I don't see any other workaround could else may cause this issue?