Django + XAMPP on Mac (2002, "Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)")

Question

I am following this tutorial to build a Django app with MySQL.

I am using XAMPP-VM for Mac. I set up my Database settings for Django as so:

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.mysql',
        'NAME': 'djangoproject',
        'USER': 'root',
        'PASSWORD': '',
        'HOST': 'localhost',
        'PORT': '8080',
    }
}

And I have started MySQL on XAMPP but when I run python manage.py migrate I get:

django.db.utils.OperationalError: (2002, "Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)")

Thank you for your help!

Possible duplicate of [Can't connect to local MySQL server through socket '/var/mysql/mysql.sock' (38)](https://stackoverflow.com/questions/5376427/cant-connect-to-local-mysql-server-through-socket-var-mysql-mysql-sock-38) — Tobias F., Nov 15 '18 at 07:41

score 1 · Answer 1 · edited Mar 24 '19 at 17:12

1

Just change HOST from localhost to the ip 127.0.0.1. This will resolve your problem.

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.mysql',
        'NAME': 'djangoproject',
        'USER': 'root',
        'PASSWORD': '',
        'HOST': '127.0.0.1',
        'PORT': '8080',
    }
}

edited Mar 24 '19 at 17:12

Vadim

8,701
4
43
50

answered Mar 24 '19 at 16:21

Hank Moody

51
8

Demeter Szabolcs · Answer 2 · 2019-03-25T08:49:01.670

0

The mysql client tries to connect through the /tmp/mysql.sock by default. You just have to point it to XAMPP's socket with a symbolic link.

ln -s /Applications/MAMP/tmp/mysql/mysql.sock /tmp/mysql.sock

edited Mar 25 '19 at 08:49

answered Mar 23 '19 at 11:35

Demeter Szabolcs

1
1

Can you please explain? – Rot-man Mar 23 '19 at 11:57

score 0 · Answer 3 · answered Mar 24 '19 at 15:50

I would try changing your HOST from 'localhost' to '127.0.0.1'. This usually rectifies it on my end.

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.mysql',
        'NAME': 'djangoproject',
        'USER': 'root',
        'PASSWORD': '',
        'HOST': '127.0.0.1',
        'PORT': '8080',
    }
}

score 0 · Answer 4 · edited Aug 14 '19 at 16:54

0

I got same error in mysql latest version, so I downgraded to mysql 5.7.0 and it's working fine.

edited Aug 14 '19 at 16:54

ejderuby

710
5
21

answered Aug 14 '19 at 16:26

Shobhit Goel

59
1
4

score 0 · Answer 5 · answered Jan 27 '20 at 19:19

0

This is probably due to XAMPP-VM being installed and not the local XAMPP. Uninstall XAMPP-VM and install XAMPP.

answered Jan 27 '20 at 19:19

user2559949

1

Django + XAMPP on Mac (2002, "Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)")

5 Answers5