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

Use HTML and CSS to create your own warm man "Dabai"

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

Solution:

Use HTML and CSS to create your own warm man "Dabai"

A brief discussion on the implementation of fuzzy query using wildcards in MySQL

Solution to Workbench not connecting to MySQL on Alibaba Cloud Server Ubuntu (tested)

A brief discussion on the difference between src and href in HTML

CentOS 7 set grub password and single user login example code

Solution to 1290 error when importing file data in mysql

Detailed explanation of CSS margin overlap and solution exploration

Complete steps to quickly configure HugePages under Linux system

How to query json in the database in mysql5.6 and below

CSS solves the misalignment problem of inline-block

Recommend

Introduction and tips for using the interactive visualization JS library gojs

A brief discussion on the role of HTML empty links

MySQL 5.5.56 installation-free version configuration method

Example analysis of mysql non-primary key self-increment usage

Introduction to the use of em in elastic layout in CSS3: How many pixels is 1em?

Implementing a table scrolling carousel effect through CSS animation

9 code optimization tips to improve website usability that webmasters should pay attention to

Complete steps for Nginx proxy front-end and back-end separation projects with the same domain name

Implementation of master-slave replication in docker compose deployment

How to install the green version of MySQL Community Server 5.7.16 and implement remote login

MySQL 5.7.21 winx64 free installation version configuration method graphic tutorial

Vue Element-ui table realizes tree structure table

Docker container exits after running (how to keep running)

abbr mark and acronym mark

Web page image optimization tools and usage tips sharing