Announcement

Collapse
No announcement yet.

Lost connection to MySQL server during query

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Lost connection to MySQL server during query

    I’m a long term user of Navicat on Mac. Since upgrade to the latest version, I got error “Lost connection to MySQL server during query” when running long query. This happens on all servers. I didn’t change anything and never had this problem before.

  • #2
    You can follow the steps below to set the Socket Timeout option for your server:
    1. Close the connection. (Control-click your connection and choose Close Connection)
    2. Enable and set "Socket Timeout (sec)" to a large value. If you know how long the query you would run, it is better to set a large value (e.g. query runs 120s, then set the value to 40). Otherwise, you can set it to 0.
    3. Open the connection and run the query again.

    Comment

    Working...
    X