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

Joseph A. Caputo jcaputo1 at comcast.net
Wed Sep 29 11:39:21 EDT 2004

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> 
> 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/

# The following options will be passed to all MySQL clients
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)



More information about the mythtv-users mailing list