MySql: ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (111)

Tried several ways and finally solved it through the following way

sudo gksu gedit /etc/mysql/my.cnf
modified

#bind-address = 127.0.0.1

to

bind-address = localhost

or
if your MySQL server IP is 65.55.55.2 then entire block should be look like as follows:
bind-address = 65.55.55.2

and restarted

sudo /etc/init.d/mysql restart
it worked

Rev :
http://stackoverflow.com/questions/5376427/cant-connect-to-local-mysql-server-through-socket-var-mysql-mysql-sock-38
http://www.cyberciti.biz/tips/how-do-i-enable-remote-access-to-mysql-database-server.html

(Visited 333 times, 1 visits today)
Spread the love