port 3306

14 Jul 2006 12:05 AM

ComputerTeacher

I'm trying to install MySQL on a Windows 2003 server. But port 3306 doesn't
seem to be open.
When I give the netstat -an command, I don't get any information about port
3306
There is no firewall running on the machine. So I'm assuming that port 3306
is being blocked by IIS 6.
Can anyone give me any suggestions as to how to unblock it?

Thanks,
Jeremy

14 Jul 2006 5:08 AM

Bernard Cheah [MVP]

How would IIS block it?
IIS has no mechanism to block any port. it however only bind to its services
port.
Say if you change the default http port 80 to 8080. then of coz other
program will not be able to bind on port 8080.

--
Regards,
Bernard Cheah
http://www.iis.net/
http://www.iis-resources.com/
http://msmvps.com/blogs/bernard/

"ComputerTeacher" <computerteacher-nospame@takemail.com> wrote in message

news:7dBtg.171815$IK3.103341@pd7tw1no...
Show quoteHide quote

> I'm trying to install MySQL on a Windows 2003 server. But port 3306
> doesn't seem to be open.
> When I give the netstat -an command, I don't get any information about
> port 3306
> There is no firewall running on the machine. So I'm assuming that port
> 3306 is being blocked by IIS 6.
> Can anyone give me any suggestions as to how to unblock it?
>
> Thanks,
> Jeremy
>

14 Jul 2006 6:53 AM

David Wang [Msft]

If netstat -an does not show port 3306 and MySQL, when running, is supposed
to be listening on it, then it means that you did not install/configure/run
MySQL properly.

When a firewall is running on the server, netstat -an will show the services
running and listening on various ports, but when anyone tries to contact
those ports, the firewall blocks it.

IIS is a web server, not a firewall or anything like that, so IIS cannot be
blocking what you think.

I suggest you contact MySQL support personel to figure out how to install
and run it properly.

--
//David
IIS
http://blogs.msdn.com/David.Wang
This posting is provided "AS IS" with no warranties, and confers no rights.
//

"ComputerTeacher" <computerteacher-nospame@takemail.com> wrote in message

news:7dBtg.171815$IK3.103341@pd7tw1no...
Show quoteHide quote

> I'm trying to install MySQL on a Windows 2003 server. But port 3306
> doesn't seem to be open.
> When I give the netstat -an command, I don't get any information about
> port 3306
> There is no firewall running on the machine. So I'm assuming that port
> 3306 is being blocked by IIS 6.
> Can anyone give me any suggestions as to how to unblock it?
>
> Thanks,
> Jeremy
>

14 Jul 2006 8:05 PM

ComputerTeacher

Thank you both for slapping some sense into me. I found some ideas on the
mysql website and now all is ok.
Show quoteHide quote

"David Wang [Msft]" <some***@online.microsoft.com> wrote in message
news:OhtDMIxpGHA.3288@TK2MSFTNGP03.phx.gbl...
> If netstat -an does not show port 3306 and MySQL, when running, is
> supposed to be listening on it, then it means that you did not
> install/configure/run MySQL properly.
>
> When a firewall is running on the server, netstat -an will show the
> services running and listening on various ports, but when anyone tries to
> contact those ports, the firewall blocks it.
>
> IIS is a web server, not a firewall or anything like that, so IIS cannot
> be blocking what you think.
>
> I suggest you contact MySQL support personel to figure out how to install
> and run it properly.
>
> --
> //David
> IIS
> http://blogs.msdn.com/David.Wang
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> //
>
> "ComputerTeacher" <computerteacher-nospame@takemail.com> wrote in message
> news:7dBtg.171815$IK3.103341@pd7tw1no...
>> I'm trying to install MySQL on a Windows 2003 server. But port 3306
>> doesn't seem to be open.
>> When I give the netstat -an command, I don't get any information about
>> port 3306
>> There is no firewall running on the machine. So I'm assuming that port
>> 3306 is being blocked by IIS 6.
>> Can anyone give me any suggestions as to how to unblock it?
>>
>> Thanks,
>> Jeremy
>>
>
>