mysql external access

[Nextus]

ok i have the port open for mysql. i can access it from another machine within the network, but when i try to access it from a wan/ external ip, it state that the port is closed. it is pointed to the correct device. any clue?

[5050]

firewall in router ?
missing port forward ?

[Nextus]

firewall in router ?
missing port forward ?

ive checked the firewall. its open
and the port is forwarded

[Castey]

MySQL User have rights to connect from any ip? Do you have commented skip-networking?

[Nextus]

MySQL User have rights to connect from any ip? Do you have commented skip-networking?

That's all been checked. I did a port scan. On 80 443 3306

All show open accept for that one.

As stated I can connect from local host and another PC that is within the network. Just not anything outside.

[Me.B]

wan access is for sure routing port issue.

Check again & again your router config to route port 3306 to mysql machine.

M B

[Nextus]

wan access is for sure routing port issue.

Check again & again your router config to route port 3306 to mysql machine.

M B

OK. Well doing a bit more research, I would have assumed that the mysql server would be listening for anything else other than itself. Its set to only listen to 127.0.0.1. Change that to a * and problem was solved.