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 345 times, 1 visits today)