I will try to explain what I have done:
The previous version of MySQL had some different directory
structure. The .pid and .sock files were placed in /var/run/mysqld/, so
instead of changing this after the upgrade I attempted to change my
/etc/my.cnf file to reflect this. There was a [client] group in that file
which I pointed the socket to /var/run/mysqld/mysqld.sock. For some reason
this would only work with root (in retrospect, perphaps the "my.cnf" file is
not readable to regular users, hence the skip -- just checked, that is the
case). I took out those lines and let it put the .sock and .pid files in
the default locations and all is working fine now.
Michael
-----Original Message-----
From: Nestor Florez [mailto:[EMAIL PROTECTED]
Sent: Thursday, 10 February, 2005 12:14
To: Dean,Michael L USAATC
Subject: Re: Error 2002
I was getting that on my Mac OSX and I had to start mysql
Nestor :-)
-----Original Message-----
From: "Dean, Michael L USAATC" <[EMAIL PROTECTED]>
Sent: Feb 10, 2005 9:02 AM
To: "'mysql@lists.mysql.com'" <mysql@lists.mysql.com>
Subject: Error 2002
I have upgraded my Debian box from MySQL version 3.23 to version 4.19.
Everything works perfectly fine except on the local box. Therefore I'm sure
it has something to do with sockets. When I am logged in as root I can
connect to the server fine, when I am logged in as a user I get this error
messsage:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (111)
My /tmp directory has these permissions:
drwxrwxrwt 5 root root 4096 Feb 10 11:46 tmp/
and mysql.sock has these permissions:
srwxrwxrwx 1 mysql mysql 0 Feb 9 11:36 mysql.sock=
I'm not quite sure what is going on, it seems like a permissions issue, but
permissions seem to be ok.
Michael
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
