django 链接mysql时提示2002错误

› Django Project

› Django REST Framework

This topic created in 5007 days ago, the information mentioned may be changed or developed.

OperationalError: (2002, "Can't connect to local MySQL server through socket '/var/run/mysql' (111)")

我在django中设置是 'HOST': '/var/run/mysqld', 为什么还是会去/var/run/mysql 中找sock文件

var

run

MySQL

7 replies • 1970-01-01 08:00:00 +08:00

cloudzhou

Sep 21, 2012

给出所有的settings信息，特别是数据库配置那一层

touch

Sep 21, 2012

@cloudzhou

4 'ENGINE': 'django.db.backends.mysql', # Add 'postgresql_psycop g2', 'mysql', 'sqlite3' or 'oracle'.
15 'NAME': 'mysql', # Or path to database fi le if using sqlite3.
16 'USER': 'root', # Not used with sqlite3.
17 'PASSWORD': '123456', # Not used with sqlite3 .
18 'HOST': '/var/run/mysqld', # Set to empty string for localhost. Not used with sqlite3.
19 'PORT': '',

napoleonu

Sep 21, 2012

走TCP连接MySQL，即使是本地的MySQL。即：HOST用IP。

touch

Sep 21, 2012

@napoleonu

改ip还是2002错误
4 'ENGINE': 'django.db.backends.mysql', # Add 'postgresql_psycop g2', 'mysql', 'sqlite3' or 'oracle'.
15 'NAME': 'mysql', # Or path to database fi le if using sqlite3.
16 'USER': 'root', # Not used with sqlite3.
17 'PASSWORD': '123456', # Not used with sqlite3 .
18 'HOST': '127.0.0.1', # Set to empty strin g for localhost. Not used with sqlite3.
19 'PORT': '3306', # Set to empty string for default. Not used with s

直接运用mysql又没问题

touch

Sep 21, 2012

看了下my.cnf中的配置sock
是 socket = /var/run/mysqld/mysqld.sock

和报错的地址不一样

cloudzhou

Sep 21, 2012

@touch 现在的2002错误是否和之前一样？如果配置了正确的sock地址之后呢？

skydiver

Sep 21, 2012

注释里面写着呢， Set to empty string for localhost

django 链接mysql时 提示2002错误

django 链接mysql时提示2002错误