Sentora Support Forums
mysql external access - Printable Version

+- Sentora Support Forums (https://senforums.mach-hosting.com)
+-- Forum: Sentora Forum Archives (https://senforums.mach-hosting.com/forumdisplay.php?fid=5)
+--- Forum: Sentora Public Support Forums v1.0.x (https://senforums.mach-hosting.com/forumdisplay.php?fid=32)
+---- Forum: General Support Forum v1.0.x (https://senforums.mach-hosting.com/forumdisplay.php?fid=36)
+---- Thread: mysql external access (/showthread.php?tid=560)

mysql external access - Nextus - 11-01-2014

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?

RE: mysql external access - 5050 - 11-01-2014

firewall in router ?
missing port forward ?

RE: mysql external access - Nextus - 11-01-2014

(11-01-2014, 04:10 AM)5050 Wrote: firewall in router ?
missing port forward ?
ive checked the firewall. its open
and the port is forwarded

RE: mysql external access - Castey - 11-01-2014

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

RE: mysql external access - Nextus - 11-01-2014

(11-01-2014, 05:57 AM)Castey Wrote: 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.

RE: mysql external access - Me.B - 11-01-2014

wan access is for sure routing port issue.

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

M B

RE: mysql external access - Nextus - 11-21-2014

(11-01-2014, 08:41 AM)Me.B Wrote: 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.