[mythtv-users] Problem with Ubuntu upgrade

[Jason Chambers]

On 22/10/2010 17:20, Damian wrote:
> On 22/10/2010 01:05, Greg Oliver wrote:
>> Either way, if that still does not work, in /etc/my.conf (changes per
>> distro), mythtv may be setup to only listen on localhost.  I believe
>> it ships that way, but mythtv distros enable the network if you
>> specify more than one machine.  I'm not 100% sure what yours is set to
>> though..
>>
>> http://www.mythtv.org/docs/mythtv-HOWTO-6.html  has good info.
>> -Greg
>>
>>>>> Damian
>>>
> 
> I found the my.conf file in /etc/mysql/my.conf
> 
> What am i looking for? in there? I did a search for 'localhost' and
> found this.
> 
> # Instead of skip-networking the default is now to listen only on
> # localhost which is more compatible and is not less secure.
> bind-address        = 127.0.0.1
> #
> 
> Is this the problem?

That would be a problem as it wouldn't be listening on the external IP
addresses making it impossible to connect from other boxes.

Comment it out, restart mysql and try reconnecting again.

However I'm surprised that you get the "Access denied for user
'mythtv'@'MythBox' (using password: YES)" rather than a "Can't connect
to MySQL server on '...' (111)" error with that setting in effect.

-- 
Regards,
Jason