Example operation MySQL short link

Example operation MySQL short link

How to set up a MySQL short link

1. Check the mysql connection number statement command:

2. First, log in to MYSQL as a super user. Note that you must be a super user, otherwise you will be prompted that you do not have permission to modify.

3. Press the Enter key to execute and the current timeout will be displayed:

4. The default timeout period is displayed, which is 8 hours (in seconds). Now reset the parameter, for example, we want to set the timeout period to 10 hours.

5. Press Enter to execute the displayed result:

6. You can re-use show global variables like 'wait_timeout' to verify.

This method is more intuitive, and the set parameters take effect immediately.

The above steps are very simple. Thank you for reading and supporting 123WORDPRESS.COM.

You may also be interested in:
  • Problems and solutions of error 08001 when linking to MySQL in IDEA and no table display after successful connection
  • After installing Navicat in MySQL, 2059 appears, Authentication plugin and local link virtual machine docker, remote link server
  • Python pymysql link database query results converted to Dataframe instance
  • Detailed explanation of MySQL multi-table query examples [link query, subquery, etc.]
  • Summary of the installation process of MySql 8.0.11 and the problems encountered when linking with Navicat
  • Detailed explanation of the use of MySQL group links
  • MySql uses skip-name-resolve to solve the problem of slow external network connection client
  • How to use ssh tunnel to connect to mysql server
  • How to view MySQL links and kill abnormal links

<<:  Summary of some practical little magic in Vue practice

>>:  Summary of Linux sftp command usage

Recommend

SQL implementation of LeetCode (183. Customers who have never placed an order)

[LeetCode] 183.Customers Who Never Order Suppose ...

Example of how nginx implements dynamic and static separation

Table of contents Deploy nginx on server1 Deploy ...

Mini Programs enable product attribute selection or specification selection

This article shares the specific code for impleme...

Implementing a random roll caller based on JavaScript

This article shares the specific code of JavaScri...

MySQL Database Basics SQL Window Function Example Analysis Tutorial

Table of contents Introduction Introduction Aggre...

Implementation idea of ​​left alignment of the last row of flex box layout

Using flex layout, if it is a nine-square grid, i...

MySQL solution for creating horizontal histogram

Preface Histogram is a basic statistical informat...

Native JS to achieve special effects message box

This article shares with you a special effect mes...

A brief discussion on Yahoo's 35 rules for front-end optimization

Abstract: Whether at work or in an interview, opt...

How to install Maven automatically in Linux continuous integration

Unzip the Maven package tar xf apache-maven-3.5.4...

Docker custom network detailed introduction

Table of contents Docker custom network 1. Introd...