django 链接mysql时 提示2002错误

[touch]

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

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

[cloudzhou]

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

[touch]

@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]

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

[touch]

@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]

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


和报错的地址不一样

[cloudzhou]

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

[skydiver]

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