Troubleshooting Windows Firewall and MySQL
I am trying to install a local copy of MySQL on my Vista Home Premium (SP2) laptop and getting odd behaviours from Windows Firewall. Could do with some assist on diagnosing.
MySQL installs OK but attempting to connect to it results in a "Connecting Server mysql@localhost (MySQL): Can't connect to MySQL server on 'localhost' (10060)" error message.
I have tried setting up Port exceptions for 3306 (MySQL default port) for both TCP & UDP but the connection is still blocked - I have also added MySQLD.exe as an exception.
Tasklist shows: mysqld.exe 3328 MySQL
Netstat shows: TCP 0.0.0.0:3306 0.0.0.0:0 LISTENING
3328
TCP [::]:3306 [::]:0
LISTENING 3328
Firewall log shows:
2011-04-14 17:10:34 DROP TCP 127.0.0.1 127.0.0.1 51207 3306 52 S 2679069017 0 8192 - - - RECEIVE
The only oddity I can see is that netstat shows 0.0.0.0 and the log shows 127.0.0.1. My limited understanding is that these are, in some way, equivalent but I don't understand precisely how.
The only way to enable connection seems to be to stop both the Windows Firewall service
and the Base Filtering Engine - stopping the Windows Firewall Service alone does not enable connections.
I have reached the end of my knowledge/imagination and could do with some help on how and where to look for a solution
April 15th, 2011 4:19am