<tfoot id='mjOVH'></tfoot>
  • <legend id='mjOVH'><style id='mjOVH'><dir id='mjOVH'><q id='mjOVH'></q></dir></style></legend>
  • <small id='mjOVH'></small><noframes id='mjOVH'>

        • <bdo id='mjOVH'></bdo><ul id='mjOVH'></ul>

        <i id='mjOVH'><tr id='mjOVH'><dt id='mjOVH'><q id='mjOVH'><span id='mjOVH'><b id='mjOVH'><form id='mjOVH'><ins id='mjOVH'></ins><ul id='mjOVH'></ul><sub id='mjOVH'></sub></form><legend id='mjOVH'></legend><bdo id='mjOVH'><pre id='mjOVH'><center id='mjOVH'></center></pre></bdo></b><th id='mjOVH'></th></span></q></dt></tr></i><div id='mjOVH'><tfoot id='mjOVH'></tfoot><dl id='mjOVH'><fieldset id='mjOVH'></fieldset></dl></div>
      1. 无法通过 socket '/tmp/mysql.sock 连接到本地 MySQL 服务器

        时间:2023-06-03
          • <bdo id='PjSdN'></bdo><ul id='PjSdN'></ul>
            <legend id='PjSdN'><style id='PjSdN'><dir id='PjSdN'><q id='PjSdN'></q></dir></style></legend>

            <small id='PjSdN'></small><noframes id='PjSdN'>

                <tbody id='PjSdN'></tbody>
            • <i id='PjSdN'><tr id='PjSdN'><dt id='PjSdN'><q id='PjSdN'><span id='PjSdN'><b id='PjSdN'><form id='PjSdN'><ins id='PjSdN'></ins><ul id='PjSdN'></ul><sub id='PjSdN'></sub></form><legend id='PjSdN'></legend><bdo id='PjSdN'><pre id='PjSdN'><center id='PjSdN'></center></pre></bdo></b><th id='PjSdN'></th></span></q></dt></tr></i><div id='PjSdN'><tfoot id='PjSdN'></tfoot><dl id='PjSdN'><fieldset id='PjSdN'></fieldset></dl></div>
            • <tfoot id='PjSdN'></tfoot>

                  本文介绍了无法通过 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 服务器的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持跟版网!

                  上一篇:如何获取 MySQL 中所有表的所有列的名称? 下一篇:MySQL 不正确的日期时间值:'0000-00-00 00:00:00'

                  相关文章

                    • <bdo id='7tpID'></bdo><ul id='7tpID'></ul>
                  1. <tfoot id='7tpID'></tfoot>

                    1. <i id='7tpID'><tr id='7tpID'><dt id='7tpID'><q id='7tpID'><span id='7tpID'><b id='7tpID'><form id='7tpID'><ins id='7tpID'></ins><ul id='7tpID'></ul><sub id='7tpID'></sub></form><legend id='7tpID'></legend><bdo id='7tpID'><pre id='7tpID'><center id='7tpID'></center></pre></bdo></b><th id='7tpID'></th></span></q></dt></tr></i><div id='7tpID'><tfoot id='7tpID'></tfoot><dl id='7tpID'><fieldset id='7tpID'></fieldset></dl></div>

                      <small id='7tpID'></small><noframes id='7tpID'>

                    2. <legend id='7tpID'><style id='7tpID'><dir id='7tpID'><q id='7tpID'></q></dir></style></legend>