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.ini
bind-address
did to 0.0.0.0 and and thus after exec commandnetstat -an
this is what I getTCP 0.0.0.0:3306 0.0.0.0:0 LISTENING
- From Windows Firewall I've enabled port
3306
inbound/outbound both. and set that toallow edge traversal
as 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?