无法连接到MYSQL， mysqld.sock问题

Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

Posted by:  Martín Colodrero ()

Date: July 14, 2012 04:20PM

ok so the error is easy go to /etc/mysql/my.cnf comment the line 

#bind-address = xxx

if you want that read all interfaces, or in case you want only localhost set it as 

bind-address		= 127.0.0.1

now try again: 

Quote

service mysql stop
rm /var/run/mysqld/*
rm /var/log/mysql/*
service mysql start

then check if exists the socket: 

ls /var/run/mysqld | grep mysqld.sock

if not exists go to: 

cat /var/log/mysql/error.log

and see what happen