[mythtv-users] Latest 0.26 Ubuntu updates and mythtv

[Steve Malenfant]

My bind-address in my.cnf is 127.0.0.1. But if I look at netstat it is
bound to my 192.168.1.x address.

me at ubuntu:~$ grep bind /etc/mysql/my.cnf
bind-address            = 127.0.0.1

me at ubuntu:~$ netstat -an | grep 3306
tcp        0      0 192.168.1.x:3306        0.0.0.0:*               LISTEN



On Tue, Dec 4, 2012 at 9:14 AM, Mike Perkins
<mikep at randomtraveller.org.uk>wrote:

> On 04/12/12 13:46, Steve Malenfant wrote:
>
>> I upgraded my packages last night and lost mythweb in the process. Looks
>> like my credentials are OK when I use "localhost" to connect to Mysql, but
>> not when specifying 127.0.0.1. I changed my settings in
>> /etc/mythtv/config.xml from 127.0.0.1 to localhost but didn't seem to have
>> any effect on it. Anybody having the same problem? I can't seem to be able
>> to override the "127.0.0.1" with all the location I tried.
>>
>> root at ubuntu:~/.mythtv# mysql -h 127.0.0.1 -umythtv -p mythconverg
>> Enter password:
>> ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (111)
>>
>> root at ubuntu:~/.mythtv# mysql -h localhost -umythtv -p mythconverg
>> Enter password:
>> Reading table information for completion of table and column names
>> You can turn off this feature to get a quicker startup with -A
>>
>> Welcome to the MySQL monitor.  Commands end with ; or \g.
>> Your MySQL connection id is 185
>> Server version: 5.5.28-0ubuntu0.12.04.2 (Ubuntu)
>>
>> Copyright (c) 2000, 2012, Oracle and/or its affiliates. All rights
>> reserved.
>>
>> Oracle is a registered trademark of Oracle Corporation and/or its
>> affiliates. Other names may be trademarks of their respective
>> owners.
>>
>> Type 'help;' or '\h' for help. Type '\c' to clear the current input
>> statement.
>>
>> mysql> quit
>>
>>  See if your mysql configuration has overwritten "bind-address".
>
> --
>
> Mike Perkins
>
> ______________________________**_________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://www.mythtv.org/mailman/**listinfo/mythtv-users<http://www.mythtv.org/mailman/listinfo/mythtv-users>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.mythtv.org/pipermail/mythtv-users/attachments/20121204/957b1677/attachment.html>