Re: [tlug] Socket error when connecting to MySQL

["Josh Glover" <jmglov@example.com>]

On 13/07/06, Dave M G <martin@example.com> wrote:

> One of my applications, Zend Studio, returns the following error when I
> try to connect to my MySQL server:
>
> Can't connect to local MySQL server through socket /tmp/mysql.sock
[...]
> Based on the information I saw, it seemed that what I needed to do was
> edit /etc/mysql/my.cnf to make sure that it had the following lines
> included:
>
> [client]
> port        = 3306
> socket        = /var/lib/mysql/mysql.sock

Did you try changing the socket line to:

socket        = /tmp/mysql.sock

If Zend Studio is trying to connect to MySQL through /tmp/mysql.sock,
and your MySQL config file sets the socket up on
/var/lib/mysql/mysql.sock, that ain't ever gonna work. You need to
either reconfigure Zend Studio to connect to
/var/lib/mysql/mysql.sock, or configure MySQL to listen on
/tmp/mysql.sock.

-Josh