This forum uses cookies
This forum makes use of cookies to store your login information if you are registered, and your last visit if you are not. Cookies are small text documents stored on your computer; the cookies set by this forum can only be used on this website and pose no security risk. Cookies on this forum also track the specific topics you have read and when you last read them. Please confirm whether you accept or reject these cookies being set.

A cookie will be stored in your browser regardless of choice to prevent you being asked this question again. You will be able to change your cookie settings at any time using the link in the footer.

mysql external access
#1
mysql external access
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?
Reply
Thanks given by:
#2
RE: mysql external access
firewall in router ?
missing port forward ?
Reply
Thanks given by:
#3
RE: mysql external access
(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
Reply
Thanks given by:
#4
RE: mysql external access
MySQL User have rights to connect from any ip? Do you have commented skip-networking?
Reply
Thanks given by:
#5
RE: mysql external access
(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.
Reply
Thanks given by:
#6
RE: mysql external access
wan access is for sure routing port issue.

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

M B
No support using PM (Auto adding to IGNORE list!), use the forum. 
How to ask
Freelance AWS Certified Architect & SysOps// DevOps

10$ free to start your VPS
Reply
Thanks given by:
#7
RE: mysql external access
(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.
Reply
Thanks given by:


Possibly Related Threads…
Thread Author Replies Views Last Post
SSH Access rsthomas 2 4 ,936 01-06-2021, 12:14 AM
Last Post: rsthomas
MySQL Database user prefix MosleyCale 1 4 ,866 10-17-2020, 09:11 PM
Last Post: Ron-e
No access after reinstall brucecy92 1 3 ,540 10-10-2020, 01:50 PM
Last Post: Jettaman

Forum Jump:


Users browsing this thread: 1 Guest(s)