How do you increase timeout in a workbench?

How do you increase timeout in a workbench?

1 Answer

1. In the new version of MySQL WorkBench, you can change the specific timeouts.
2. For you, if it is under Edit → Preferences → SQL Editor → DBMS connection read time out (in seconds): 600.
3. Then the value will be changed to 6000.
4. Also, uncheck the limit rows.

How do I change timeout in MySQL?

Change the MySQL timeout on a server

1. Log in to your server by using Secure Shell® (SSH).
2. Use the sudo command to edit my.
3. Locate the timeout configuration and make the adjustments that fit your server.
4. Save the changes and exit the editor.

When do I get the lost connection to MySQL error?

I got the Error Code: 2013. Lost connection to MySQL server during query error when I tried to add an index to a table using MySQL Workbench. I noticed also that it appears whenever I run long query. Is there away to increase the timeout value?

When do I get the error code 2013 in MySQL?

If you spend time running lots of MySQL queries, you might come across the Error Code: 2013. Lost connection to MySQL server during query. This article offers some suggestions on how to avoid or fix the problem. This error appears when the connection between your MySQL client and database server times out.

What causes MySQL server to drop a connection?

This error appears when the connection between your MySQL client and database server times out. Essentially, it took too long for the query to return data so the connection gets dropped. Most of my work involves content migrations.

Why is MySQL server not connecting to remote clients?

MySQL: Lost connection to MySQL server at ‘reading initial communication packet’ At some point, it was impossible for remote clients to connect to the MySQL server. The client (some application on a Windows platform) gave a vague description like Connection unexpectedly terminated .