OperationalError：（2002，“Can not connect to local MySQL server through socket”/var/run/mysqld/mysqld.sock“（2）”） [英] OperationalError: (2002, "Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)")

问题描述

当连接到Django中的mysql数据库时，我收到错误。

when connecting to mysql database in Django ,I get the error.

1. 我确定mysql服务器正在运行。

1. I'm sure mysql server is running.

/var/run/mysqld/mysqld.sock不存在。

/var/run/mysqld/mysqld.sock doesn't exist.

当我运行 $ find / -name * .sock -type s 时，我只得到/tmp/mysql.sock和其他一些不相关的输出。

When I run $ find / -name *.sock -type s, I only get /tmp/mysql.sock and some other irrelevant output.

我向/etc/my.cnf添加了 socket = /tmp/mysql.sock 。然后再安装mysql，退出django shell，并连接到mysql数据库。我仍然有相同的错误。

I added socket = /tmp/mysql.sock to /etc/my.cnf. And then restared mysql, exited django shell, and connected to mysql database. I still got the same error.

我搜索了很多，但我还是不知道该怎么做。

I searched a lot, but I still don't know how to do.

任何帮助都是greate。感谢提前。

Any help is greate. Thanks in advance.

嗯，我刚刚尝试了一些方法。它的工作原理
我做了如下。

Well, I just tried some ways. And it works. I did as follows.

1. 添加 socket = /tmp/mysql.sock。创建mysql服务器。


2. ln -s /tmp/mysql.sock /var/lib/mysqld/mysqld.sock



1. Add socket = /tmp/mysql.sock .Restart the mysql server.
2. ln -s /tmp/mysql.sock /var/lib/mysqld/mysqld.sock

今天遇到另一个问题。我无法登录到mysql。
我是新手的mysql。所以我猜mysql服务器和客户端使用相同的套接字进行通信。
我在my.cnf中添加 socket = /var/mysqld/mysqld.sock 到[mysqld] [client]块，并且它的wokrs。

I met an another problem today. I can't login to mysql. I'm newbie to mysql. So I guess mysql server and client use the same socket to communicate. I add socket = /var/mysqld/mysqld.sock to [mysqld] [client] block in my.cnf and it wokrs.

推荐答案

使用127.0.0.1而不是localhost

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',
   }
}

这篇关于OperationalError：（2002，“Can not connect to local MySQL server through socket”/var/run/mysqld/mysqld.sock“（2）”）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！