CODEWITHSUNDEEP
mysqlmacosfirewall
zaolian
zaolian

Reputation: 1197

Why is my port 3306 closed even though I do not have bind-address and skip-networking line at all?

I have a web service with mysql running on a Mac OS X VMware Fusion image inside of a Mac OS X host. Both Macs are showing Firewall:Off under Security & Privacy.

When I do telnet localhost 3306 or telnet 127.0.0.1 3306, I am able to connect. However if I do telnet SERVERDOMAIN 3306, it is not reachable.

On the Mac there are no bind-address or skip-networking line in .cnf file at all. In mysql -help -verbose, bind-address is showing as * and skip-networking is FALSE;

In mysql.user I only see localhost under host column and I have already used GRANT to grant access to both root and another user. (Since telnet to 3306 is failing, I don't think we are there yet.)

What else are we missing that could cause me not able to connect to the mysql remotely?

Upvotes: 0

Views: 558

Answers (1)

Jacques Amar
Jacques Amar

Reputation: 1833

For a general view of connecting to MySQL:

Connect to MySQL from external machine

In your case, you are on the same subnet, so you can forget the routers/internet part.

Upvotes: 1

Related Questions