无法通过 socket '/tmp/mysql.sock 连接到本地 MySQL 服务器

问题描述

当我在测试套件期间尝试连接到本地 MySQL 服务器时，它失败并出现错误:

When I attempted to connect to a local MySQL server during my test suite, it fails with the error:

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

但是，我始终可以通过运行命令行连接到 MySQLmysql 程序.一个 ps aux |grep mysql 显示服务器正在运行，并且stat/tmp/mysql.sock 确认套接字存在.此外，如果我打开一个该异常的 except 子句中的调试器，我能够可靠地连接具有完全相同的参数.

However, I'm able to at all times, connect to MySQL by running the command line mysql program. A ps aux | grep mysql shows the server is running, and stat /tmp/mysql.sock confirm that the socket exists. Further, if I open a debugger in except clause of that exception, I'm able to reliably connect with the exact same parameters.

此问题的重现相当可靠，但似乎不是 100%，因为每隔一次，我的测试套件实际上在没有遇到这个错误.当我尝试使用 sudo dtruss 运行时，它没有重现.

This issue reproduces fairly reliably, however it doesn't appear to be 100%, because every once in a blue moon, my test suite does in fact run without hitting this error. When I attempted to run with sudo dtruss it did not reproduce.

所有客户端代码都是用 Python 编写的，但我不知道这有什么关系.

All the client code is in Python, though I can't figure how that'd be relevant.

切换到使用主机 127.0.0.1 产生错误:

Switching to use host 127.0.0.1 produces the error:

DatabaseError: Can't connect to MySQL server on '127.0.0.1' (61)

推荐答案

sudo /usr/local/mysql/support-files/mysql.server start 

这对我有用.但是，如果这不起作用，请确保 mysqld 正在运行并尝试连接.

This worked for me. However, if this doesnt work then make sure that mysqld is running and try connecting.

这篇关于无法通过 socket '/tmp/mysql.sock 连接到本地 MySQL 服务器的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持跟版网！