当我在测试套件期间尝试连接到本地 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 服务器的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持跟版网!