[mythtv-users] 0.25 to 0.26 upgrade issue with MYSQL

[Michael Watson]

On 4/08/2013 7:53 AM, Steve Greene wrote:
> On Sat, 2013-08-03 at 19:36 +0000, Gary Buhrmaster wrote:
>> On Sat, Aug 3, 2013 at 6:39 PM, Steve Greene <sgreene59 at verizon.net> wrote:
>> ...
>>> Yep, set to my local IP subnet. It's behaving as if "skip-networking"
>>> were set.  I can set myth to "localhost" as the hostname and it
>>> connects. I'm about ready to restore my backup, if I can't figure this
>>> out.
>> If you newly installed your system, by any chance did your
>> (new) installation set firewall filters that would (likely by
>> default) block incoming mysql connections?
>>
>> Gary
>> _______________________________________________
>> mythtv-users mailing list
>> mythtv-users at mythtv.org
>> http://www.mythtv.org/mailman/listinfo/mythtv-users
> No firewall set and I did change mythconverg permissions to allow access
> from my subnet.  I'm mystified. At this point, I'm restoring my backup,
> rather than spend the whole weekend with this. It certainly is behaving
> like it's only granting access to localhost.
>
> I'll be interested if anyone else has encountered something similar.
>
> Thanks.
>
> Steve
>
Running "netstat -ltpn|grep -i mysql" will easily tell you if 
bind-address is the culprit.
If so, then check /etc/mysql/conf.d/mythtv.cnf and adjust bind-address 
to suit.  Set  to "bind-address=::" to listen on all interfaces