无法通过 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.
相关文章