Solution to navicat automatically disconnecting from the database after a period of time

This is because the database server is set to automatically disconnect the connection after a period of inactivity to avoid too many connections.

Solution:

1. Select a database and right-click to open the connection properties

Select Advanced and set Keepalive Interval (240) -- automatically send heartbeat data every 4 minutes, so that the connection can be maintained.

Supplement: Things to note when Navicat gets stuck when importing SQL script files

Pay attention!

Do not set the max_allowed_packet = 64M parameter in the mysql.ini file too large.

The above is my personal experience. I hope it can give you a reference. I also hope that you will support 123WORDPRESS.COM. If there are any mistakes or incomplete considerations, please feel free to correct me.

You may also be interested in:

How to remotely connect to MySQL database with Navicat Premium
How to use Navicat to create a database and connect with JDBC
How to remotely connect to the cloud server database using Navicat
When Navicat Premium connects to the database, the error message appears: 2003 Can't connect to MySQL server on''localhost''(10061)
Detailed explanation of the 10061 unknown error when using Navicat to connect to a remote Linux MySQL database
Solution to the problem "MySql database does not support remote connection" when connecting to NaviCat
How to connect Intellij IDEA to Navicat database

<<: Style trigger effect of web page input box

>>: About the difference between js typeof and instanceof in judging data types and their development and use

Encapsulate the navigation bar component with Vue

Solution to navicat automatically disconnecting from the database after a period of time

Solution:

Encapsulate the navigation bar component with Vue

Detailed explanation of the implementation principle of transaction isolation level in MySQL

Vue3 implements CSS infinite seamless scrolling effect

Do you know how to optimize loading web fonts?

Vue implements mobile phone verification code login

Detailed explanation of webpage screenshot function in Vue

Solve the problem that element edit form el-radio cannot be selected after echoing

Detailed explanation of the WeChat applet request pre-processing method

Correct use of Vue function anti-shake and throttling

Example of how to deploy Spring Boot using Docker

Recommend

Use CSS to achieve 3D convex and concave effects on images (convex out of the frame or concave in the frame)

Detailed explanation of how to access MySQL database remotely through Workbench

Examples of correct use of maps in WeChat mini programs

About Generics of C++ TpeScript Series

Example code of CSS layout at both ends (using parent's negative margin)

Implementation of importing and exporting vue-element-admin projects

Detailed explanation of MySQL file storage

Detailed explanation of memory management of MySQL InnoDB storage engine

How to create a table by month in MySQL stored procedure

CSS realizes corner cutting + border + projection + content background color gradient effect

Experience in designing a layered interface in web design

React useMemo and useCallback usage scenarios

Install multiple versions of PHP for Nginx on Linux

How to use Gitlab-ci to continuously deploy to remote machines (detailed tutorial)

How to change apt-get source in Ubuntu 18.04