how to check if port 3306 is open on windows

I’ve just found the easiest way to check if port 3306 on my localhost is blocked. Things are a bit different if you are working with Windows, and in particular Windows Server 2008. So, what you need to do first is run the netstat command:
netstat -a -n
What this will show you is a huge list of incoming connections.