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

[Jarod Wilson]

On Tuesday 28 September 2004 05:06, Greg Donald wrote:
> On Mon, 27 Sep 2004 14:32:04 -0700, Yan-Fa Li <yanfali at best.com> wrote:
> > As Isaac keeps trying to tell you.  The mysql library looks at your
> > /etc/my.cnf for the value of 'socket'.
>
> Well mine isn't, how do I fix it?

I'm just guessing here, but I think the problem may be your qt-mysql package. 
Myth interfaces with mysql using qt-mysql, and the error message you're 
getting...

> because it's trying the wrong socket location:
> > ./setup
>
> Unable to connect to database!
> Driver error was [1/2002]:
> QMYSQL3: Unable to connect

...says QMYSQL3 was unable to connect, not Myth.

> Database error was:
> Can't connect to local MySQL server through socket
> '/var/lib/mysql/mysql.sock' (111)

Try rebuilding qt-mysql, looks like maybe its built against your distro's 
mysql, and *does* possibly hardcode the socket location, or more likely, has 
a hardcoded path to my.cnf, which might not be /etc/my.cnf (I'm not all that 
familiar with qt-mysql, dunno exactly how it gets that value). You might 
simply try searching for another instance of my.cnf on your system.

Or like someone else said, just symlink /var/lib/mysql/mysql.sock 
to /tmp/mysql.sock if you really don't want to mess with it anymore.

-- 
Jarod C. Wilson, RHCE
jcw at wilsonet.com

Got a question? Read this first...
     http://catb.org/~esr/faqs/smart-questions.html
MythTV, Fedora Core & ATrpms documentation:
     http://wilsonet.com/mythtv/
MythTV Searchable Mailing List Archive
     http://www.gossamer-threads.com/lists/mythtv/
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: not available
Url : http://mythtv.org/pipermail/mythtv-users/attachments/20040928/5a514b2d/attachment.pgp