Problem with mysql.sock

[sifro]

Hello,

i am getting several weird errors with mysql. When i try to connect from the CL with a particoular user (other users are OK) i get this error after doing a simple "show tables":

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111)

Mysql is clearly fu**ed up also because from the panel i can see that some databases are associated to -2 users (and are 0.00 kB big).

With the command "service mysqld restart" i can correctly restart mysql, and it looks like the sock file is on the right place...

root@vtswebservices:/tmp# ls | grep mysql.sock
mysql.sock
root@vtswebservices:/tmp# more mysql.sock
mysql.sock: No such device or address

Here is my /etc/my.cnf file:

[mysqld]
local-infile=0

Here is my /usr/local/directadmin/conf/my.cnf file:

[client]
user=da_admin
password=a-random-password

I tried adding "socket=/tmp/mysql.sock" to /etc/my.cnf without results...

What should i do?

THanks!

 

[sifro]

after some debug, i found that all the problems where caused by a broken DB (still don't know how it broke). Deleted & restored from backup, everything runs fine now.