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

[Joseph A. Caputo]

On Tuesday 28 September 2004 08:06, Greg Donald wrote:
> On Mon, 27 Sep 2004 14:32:04 -0700, Yan-Fa Li <yanfali at best.com> 
wrote:
> My /etc/my.cnf looks like this:
> > cat /etc/my.cnf
>
> [mysqld]
> socket=/tmp/mysql.sock
>
> So the setup application isn't getting the wrong information from
> there.

I don't think that's the line you're necessarily interested in.... that 
controls where the mysqld daemon *creates* the socket.  The line that 
controls where clients *look* for the socket would be (from my /etc/
my.cnf):

# The following options will be passed to all MySQL clients
[client]
port            = 3306
socket          = /tmp/mysql.sock

If there is no 'socket' entry in the [client] section, then I'd guess it 
would fall back to whatever is defined in the mysql code.

Also, did you/do you have another version of MySQL installed at any 
point that perhaps wasn't completely uninstalled?  Check to make sure 
Qt is linked against the correct MySQL library, like so:

ldd ${QTDIR}/plugins/sqldrivers/libqsqlmysql.so | grep -i mysql

gives me:
  libmysqlclient.so.10 => /usr/lib/libmysqlclient.so.10 (0x40026000)

HTH,

JAC