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

[Martín Colodrero]

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

Edited 1 time(s). Last edit at 07/14/2012 04:22PM by Martín Colodrero.