[mythtv-users] bind-address in MySQL

Aaron Pelly aaron at pelly.co
Sat Sep 13 15:24:35 UTC 2014


On 14/09/14 02:21, Leo Butler wrote:
> 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.
Also per user


More information about the mythtv-users mailing list