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

MySQL 20 high-performance architecture design principles (worth collecting)

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

Solution:

MySQL 20 high-performance architecture design principles (worth collecting)

Embedded transplant docker error problem (summary)

Detailed graphic explanation of sqlmap injection

Nginx operation and maintenance domain name verification method example

How to use nginx as a load balancer for mysql

Detailed example of deploying Nginx+Apache dynamic and static separation

MySQL performance optimization index pushdown

Upgrade Docker version of MySQL 5.7 to MySQL 8.0.13, data migration

Summary of common commands for Ubuntu servers

Javascript operation mechanism Event Loop

Recommend

MySQL Optimization: Cache Optimization

Detailed explanation of Mysql function call optimization

How to use HTML form with multiple examples

CSS Viewport Units for Fast Layout

The simplest form implementation of Flexbox layout

Solution to ERROR 1054 (42S22) when changing password in MySQL 5.7

Solve the problem after adding --subnet to Docker network Create

How to Dockerize a Python Django Application

How to find out uncommitted transaction information in MySQL

How to find websites with SQL injection (must read)

MySQL 8.0.13 installation and configuration method graphic tutorial

Solve the problem of starting two ports that occupy different ports when docker run

Detailed process of compiling and installing Storm on Kylin V10 server

Solution to automatically submitting the form and jumping to other pages after pressing Enter on the web page

Solution to forgetting mysql database password