How to keep the connection alive in MySQL Workbench?

MySQLMySQLi Database

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

raja
Published on 21-Dec-2018 09:54:38
Advertisements