Bug #15739 Lost connection to server when Firewall active

• Submitted: 14 Dec 2005 14:09
• Modified: 14 Dec 2005 14:38
• Reporter: Franz Schwanzer
• Status: Not a Bug
• Category: MySQL Server
• Severity: S2 (Serious)
• Version: 5..0.11-beta
• OS: Windows (Window XP SP2)
• Assigned to: Aleksey Kishkin
• CPU Architecture: Any

[14 Dec 2005 14:09] Franz Schwanzer

Description:
I installed MySQL on my PC. Except of the Windows Firewall there is the Norton Firewall active. When I start a query, e. g."mysqladmin -u root -h localhost -p", I get the answer: "Lost connection to MySQL server during query" .

If I deactive the Norton Firewall, all answers of MySQL are correct, but every 10 seconds the Norton Firewall reminds me, that the protection is not alive, and I have to click the message, so that I can continue.

What can I do?

How to repeat:
Try with the firewalls.

Suggested fix:
?

[14 Dec 2005 14:37] Aleksey Kishkin

Franz,

'-h localhost' on windows means mysql will try to connect to mysql server by TCP/IP (127.0.0.1 address), so if you have a firewall, you have to setup it that mysql could use 3306 port..

In any case it's not a mysql bug .

as an workaround I'dd suggest to connect without '-h localhost' option, it this case mysql will connect to server over named pipe and firewall will not be able to block it.

[14 Dec 2005 14:37] Valeriy Kravchuk

Thank you for a problem report. You may have to add rules to your firewall to allow packages to and from port 3306 (or whatever TCP port do you use for MySQL) on you machine. Please, try and inform about the results.