[mythtv-users] bind-address in MySQL

[Leo Butler]

Stephen Worthington <stephen_agent at jsw.gen.nz> writes:

> On Sat, 13 Sep 2014 11:18:32 +0200, you wrote:
>
>>Hello,
>>
>>Maybe this is not a MythTv problem, but I want to configure the
>>backend mysql server to bind just to my network addresses.
>>
>>I try this:
>>
>># cat /etc/mysql/my.cnf | grep bind
>>bind-address            = 192.168.1.0/24
>>
>>But it does not work, it doesn't start the service. I want to bind
>>just to my network frontends (192.168.1.0/24), how could I configure
>>it?
>>
>>Thanks for your help.
>>
>>Best regards.
>
> There is no netmask on a bind address.  It is just a single address,
> not a network or subnet.


I think Josu can use /etc/hosts.allow and /etc/hosts.deny to control
access to mysqld.

In /etc/hosts.allow:
mysqld: 192.168.1.0/24

In /etc/hosts.deny:
mysqld: ALL

man hosts.allow will give more information.

Leo