Error Code: 2013. Lost connection to MySQL server during query after a few seconds









up vote
0
down vote

favorite












I am having trouble when running a query in MySQL Workbench:
the query is interrupted because of lost connection, and this happens after only 8 seconds...



I have checked the usual sources of problems, namely:



  • Changing DBMS connection timeout

  • Changing interactive_timeout, read_timeout, ...

After relaunching the server, I see the query was successfully run though.



Running on MacOS



Any ideas on how to get around this ?
Many Thanks !










share|improve this question

























    up vote
    0
    down vote

    favorite












    I am having trouble when running a query in MySQL Workbench:
    the query is interrupted because of lost connection, and this happens after only 8 seconds...



    I have checked the usual sources of problems, namely:



    • Changing DBMS connection timeout

    • Changing interactive_timeout, read_timeout, ...

    After relaunching the server, I see the query was successfully run though.



    Running on MacOS



    Any ideas on how to get around this ?
    Many Thanks !










    share|improve this question























      up vote
      0
      down vote

      favorite









      up vote
      0
      down vote

      favorite











      I am having trouble when running a query in MySQL Workbench:
      the query is interrupted because of lost connection, and this happens after only 8 seconds...



      I have checked the usual sources of problems, namely:



      • Changing DBMS connection timeout

      • Changing interactive_timeout, read_timeout, ...

      After relaunching the server, I see the query was successfully run though.



      Running on MacOS



      Any ideas on how to get around this ?
      Many Thanks !










      share|improve this question













      I am having trouble when running a query in MySQL Workbench:
      the query is interrupted because of lost connection, and this happens after only 8 seconds...



      I have checked the usual sources of problems, namely:



      • Changing DBMS connection timeout

      • Changing interactive_timeout, read_timeout, ...

      After relaunching the server, I see the query was successfully run though.



      Running on MacOS



      Any ideas on how to get around this ?
      Many Thanks !







      mysql timeout connection workbench






      share|improve this question













      share|improve this question











      share|improve this question




      share|improve this question










      asked Nov 9 at 12:38









      A.Pilette

      1




      1



























          active

          oldest

          votes











          Your Answer






          StackExchange.ifUsing("editor", function ()
          StackExchange.using("externalEditor", function ()
          StackExchange.using("snippets", function ()
          StackExchange.snippets.init();
          );
          );
          , "code-snippets");

          StackExchange.ready(function()
          var channelOptions =
          tags: "".split(" "),
          id: "1"
          ;
          initTagRenderer("".split(" "), "".split(" "), channelOptions);

          StackExchange.using("externalEditor", function()
          // Have to fire editor after snippets, if snippets enabled
          if (StackExchange.settings.snippets.snippetsEnabled)
          StackExchange.using("snippets", function()
          createEditor();
          );

          else
          createEditor();

          );

          function createEditor()
          StackExchange.prepareEditor(
          heartbeatType: 'answer',
          convertImagesToLinks: true,
          noModals: true,
          showLowRepImageUploadWarning: true,
          reputationToPostImages: 10,
          bindNavPrevention: true,
          postfix: "",
          imageUploader:
          brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
          contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
          allowUrls: true
          ,
          onDemand: true,
          discardSelector: ".discard-answer"
          ,immediatelyShowMarkdownHelp:true
          );



          );













           

          draft saved


          draft discarded


















          StackExchange.ready(
          function ()
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53225863%2ferror-code-2013-lost-connection-to-mysql-server-during-query-after-a-few-secon%23new-answer', 'question_page');

          );

          Post as a guest



































          active

          oldest

          votes













          active

          oldest

          votes









          active

          oldest

          votes






          active

          oldest

          votes















           

          draft saved


          draft discarded















































           


          draft saved


          draft discarded














          StackExchange.ready(
          function ()
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53225863%2ferror-code-2013-lost-connection-to-mysql-server-during-query-after-a-few-secon%23new-answer', 'question_page');

          );

          Post as a guest














































































          Popular posts from this blog

          Use pre created SQLite database for Android project in kotlin

          Darth Vader #20

          Ondo