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