CentOS 6.6 Can’t connect to local MySQL server through socket /var/lib/MySQL/MySQL.sock (error 2002)‏

Home » CentOS » CentOS 6.6 Can’t connect to local MySQL server through socket /var/lib/MySQL/MySQL.sock (error 2002)‏
CentOS 6 Comments

Hi

Total newby to CentOS I am currently assisting a community radio station set up in the Uk we are using a server based system for our playout software, unfortunately at the moment one of our client servers is experience the above error I came across the error on our main server a few weeks ago and found the solution just by reinstalling the MySQL db but I have tried to deploy the same fix on our client server otherwise known as studio-b client but unfortunately this has not solved the problem any assistance with this would be very much appreciated.

All the best Graham Wilman

6 thoughts on - CentOS 6.6 Can’t connect to local MySQL server through socket /var/lib/MySQL/MySQL.sock (error 2002)‏

  • Graham Wilman wrote:
    First question – did it ever work? If not, is selinux enforcing?

    mark “getenforce”

  • I cannot say if it ever worked I have inherited the sorting out of our servers at the radio station due to it being run by volunteers and as in all volunteer organisations people come and go I did do some research on the internet and tried various commands in the terminal but kept on getting MySQL does not exist yet when I tried the locate MySQL I did get an output with various directories and sub directories I did come across the getenforce command and when I typed it the output came back with disabled

  • Am 21.05.2015 um 22:43 schrieb Graham Wilman :

    # grep sock /etc/my.cnf socket=/var/lib/mysql/mysql.sock

  • Regarding “locate”, try running updatedb. It may be that after your predecessor got MySql set up updated was not run. That is what loads the strings into the DB for locate. The try locate again.

    HTH, Bill