Can't connect to local mysql server through socket '/tmp/mysql.sock'.

Question

Problem :

I am very new to MySQL Server. I am newly assigned to this MySQL Server project. If I try to connect with the local MySQL server during my assigned test suite it shows me the below error:

 "Can't connect to local MySQL server through socket '/tmp/mysql.sock'”.

But still I can connect to the MySQL by running a command line MySQL program. The following command ps aux | grep mysql informs that my server is running also the below command stat /tmp/mysql.sock validate that my socket exists. Additionally if I try to open my debugger in except clause related to that exception I can connect with my exact same parameters.

I am very confused about above error. Can some expert help me in fixing it?

Answer 1

I know such errors are very annoying. I had faced this error earlier and was able to fix it.

The below command helped me.

sudo /usr/local/mysql/support-files/mysql.server start

If above command does not work for you then you need to make sure that the mysqld is running and then you can try connecting it again.

If still not working then you can try below process.

At your terminal you need to run below command

mysql_config –socket

Above command will provide you with your path to the sock file. You need to take that path and then you can use it in your DATABASES HOST paramater.

You need to do below in your DATABASES HOST parameter:

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.mysql',
        'NAME': 'test',
        'USER': 'test',
        'PASSWORD': 'test',
        'HOST': '/Applications/MAMP/tmp/mysql/mysql.sock',
        'PORT': '',
    },
}

It will surely fix the problem.