Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

lost connection to mysql

New versions of MySQL WorkBench have an option to change specific timeouts.

1.For me it was under Edit → Preferences → SQL Editor → DBMS connection read time out (in seconds): 600

Changed the value to 6000.
2. uncheck limit rows in in Edit → Preferences →SQL Queries

Also unchecked limit rows as putting a limit in every time I want to search the whole data set gets tiresome.
 
PREVIOUS NEXT
Tagged: #lost #connection #mysql
ADD COMMENT
Topic
Name
6+1 =