[mythtv-users] Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)

[Yan-Fa Li]

As Isaac keeps trying to tell you.  The mysql library looks at your
/etc/my.cnf for the value of 'socket'.  It is not hardcoded anywhere
in any client application of mysql which uses the standard
libmysqlclient.

If you point the library at loopback address for your mysql db it 
automatically tries to use a Unix instead of a TCP sockets as a 
performance optimization.

Please read the mysql documentation if you don't agree.

Greg Donald wrote:
> On Mon, 27 Sep 2004 15:51:39 -0400, Isaac Richards <ijr at po.cwru.edu> wrote:
> 
>>You don't tell it - that information is handled entirely by the mysql client
>>library, and has absolutely nothing to do with mythtv.
> 
> 
> So if my mysql.sock file is not in the non-default location
> /var/lib/mysql that mythtv seems to be hardcoded for, I cannot run the
> setup program at all?  Is there another way to get setup without
> running setup?
> 
> Surely I am not the first person to come along with vanilla MySQL
> installed from source using /tmp for the mysql.sock location.  This is
> the default location as per the MySQL manual..  Why on earth would
> anyone feel the need to hardcode it to some non-standard location is
> beyond reason.