Re: mysqld in hosts.allow / hosts.deny ?

[Michael Shuler <michael@pbandjelly.org>]

On 09/06/2007 05:43 AM, Pratchaya Chatuphian wrote:
> Now, Can i use tcpwrapper with mysql on debian ?

Yes (this is how I do a quick check on a binary w/o going to find
compiled options):

$ ldd /usr/sbin/mysqld | grep wrap
        libwrap.so.0 => /lib/libwrap.so.0 (0xb7ec7000)

> If it can be used.
> Which config. that i correct ?
> ( If i want to only allow from my LAN ( 192.168.2.x netmask 255.255.255.0 )

It is the *daemon* that you wish to wrap that is the first argument in
hosts.[allow,deny] - in this case mysqld.  Your network/netmask looks
fine.  'man hosts.allow'

> 1.
> hosts.allow
> #########
> mysqld: 192.168.2.0/255.255.255.0
> 
> 
> hosts.deny
> #########
> mysqld: ALL

-- 
Kind Regards,
Michael Shuler