Syntax error How to keep the connection alive in MySQL Workbench?

How to keep the connection alive in MySQL Workbench?



To keep connection alive in MySQL Workbench, you need to reach at the following location −

Edit -> Preferences -> SQL Editor

Here is the snapshot of all the options.

After clicking the “Edit” menu, we will select “Workbench Preferences” as shown below −

Now, select SQL Editor and set an interval. You can also set the below options to set the connection alive in MySQL Workbench.

  • DBMS connection Keep-alive interval
  • DBMS connection Read-timeout interval
  • DBMS connection Timeout interval

Here is the screenshot

Updated on: 2019-07-30T22:30:24+05:30

906 Views

Kickstart Your Career

Get certified by completing the course

Get Started
Advertisements