MySQL Forums
Forum List  »  Newbie

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		=

now try again:


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.

Options: ReplyQuote

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.