[Django]-OperationalError: (2002, "Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)")

71👍

✅

Use “127.0.0.1”, instead of “localhost”

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

👤Md. Ibrahim

[Django]-Django: Query Group By Month

1👍

For me this worked
add OPTIONS attribute with read_default_file and give it the path of my.cnf file

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.mysql',
        'NAME': 'dbname',
        'USER': 'root',
        'PASSWORD': '',
        'HOST': 'localhost',
        'PORT': '3306',
        'OPTIONS': {
            'read_default_file': '/opt/lampp/etc/my.cnf',
        }
    }
}

👤AkshayJ

1👍

You need to change your HOST from 'localhost' to '127.0.0.1' and check your django app 🙂

👤Muhammadalive

0👍

in flask, you may use that

app=Flask(__name__)

app.config["MYSQL_HOST"]="127.0.0.1
app.config["MYSQL_USER"]="root"…

👤Can Okan Taşkıran

0👍

I faced this problem when connecting MySQL with Django when using Docker.

Try 'PORT':'0.0.0.0'.