Bug #57930 mysqld doesn't honor # in hosts.deny file

• Submitted: 2 Nov 2010 13:16
• Modified: 3 Nov 2010 10:26
• Reporter: Stefan Priebe
• Status: Not a Bug
• Category: MySQL Server
• Severity: S2 (Serious)
• Version: 5.1.51
• OS: Linux
• CPU Architecture: Any
• Tags: hosts.deny, MySQL, server

[2 Nov 2010 13:16] Stefan Priebe

Description:
MySQL Server doesn't detect inline comments and tries to ignore wrong hosts.

How to repeat:
I've added a line to my /etc/hosts.deny like this:
ALL : IP # local detection

now MySQL denies all access to localhost - by removing the word local from the comment it is working again.

Suggested fix:
no idea

[3 Nov 2010 10:26] Sveta Smirnova

Thank you for taking the time to write to us, but this is not a bug. Please double-check the documentation available at http://dev.mysql.com/doc/ and the instructions on
how to report a bug at http://bugs.mysql.com/how-to-report.php

Linux man page says (http://linux.die.net/man/5/hosts.deny): "Blank lines or lines that begin with a # character are ignored. This permits you to insert comments and whitespace so that the tables are easier to read." There is no word about inline comments are allowed.