Lost connection to server executing ALTER TABLE
Change specific timeouts value to 6000 it's available in all new versions of MySQL Workbench.


  Open Edit → Preferences → SQL Editor → DBMS connection read time out
  (in seconds): 600
  
  Changed the value to 6000.


Also unchecked limit rows as putting a limit in every time I want to search the whole data set gets tiresome.