0 votes
1 view
in SQL by (20.3k points)

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 a long query.

Is there a way to increase the timeout value?

1 Answer

0 votes
by (40.3k points)

In the new version of MySQL WorkBench, you can change the specific timeouts.

For you, if it is under Edit → Preferences → SQL Editor → DBMS connection read time out (in seconds): 600

Then the value will be changed to 6000.

Also, uncheck the limit rows. If you are putting the limit every time then it will be difficult for you to search the whole data set.

Learn SQL with the help of this SQL Tutorial.

Related questions

0 votes
1 answer
0 votes
1 answer
asked Jul 9, 2019 in SQL by Tech4ever (20.3k points)
Welcome to Intellipaat Community. Get your technical queries answered by top developers !