[mythtv-users] Indoor HD antenna question

[Stephen Worthington]

On Wed, 18 Apr 2018 23:17:15 +0000, you wrote:

>On Wed, Apr 18, 2018 at 5:20 PM John Pilkington <johnpilk222 at gmail.com>
>wrote:
>
>> On 18/04/18 21:38, Ashu Desai wrote:
>>
>> > I did the following on my remote frontend:
>> >
>> > mysql -h backend_ip -D mythconverg -u mythtv -p
>>
>> How about:
>>
>> mysql  -umythtv -pmythtv -h localhost mythconverg
>>
>
>I don't understand this - why am I trying to get in from my backend box? It
>already works. - the only thing not working is from the remote frontend.
>Unless I am misunderstanding this?
>
>Anyways - tried it and doesn't work (since i dont think there is mariadb on
>the frontend)

The default install for MySQL and MariaDB is to only bind to
localhost.  So you probably need to change the settings in /etc/mysql
to allow binding of your external network interfaces.  This command
will show you what interfaces MySQL or MariaDB are bound to:

netstat -lp | grep mysql

Find all the "bind-address" lines in the config files and see what is
uncommented:

cd /etc/mysql
grep -ir "bind-address" *

If there is more than one that is not commented out, it can be
difficult to work out which one is read last and is the one that
works.  To work out what order they are read in, you need to look at
all the config files starting with /etc/mysql/my.cnf and find any
"!includedir" lines.  Config files are read from any included
directory in alphabetical order at the time the "!includedir" line is
read.

You need to either change the bind-address line that works to:

bind-address=::

or add a new bind-address line that will be read after that one.

A bind address of :: allows binding to all interfaces using IPv4 and
IPv6.  A bind address of 0.0.0.0 allows binding to all interfaces
using IPv4 only.

I recommend only having one uncommented "bind-address" line - comment
out or delete the others.