Summary of several key points about mysql init_connect

Summary of several key points about mysql init_connect

The role of init_connect

init_connect is usually used to: when a connection comes in, do some operations, such as setting autocommit to 0, such as recording the current connection's IP source and user information into a new table as login log information

Notes on using init_connect

1 Only super accounts can set (super_priv permission)

2 The super account ignores the init_connect setting (that is, the init_connect setting has no effect on connections from the super account)

The above summary of several key points about mysql init_connect is all the content that the editor shares with you. I hope it can give you a reference. I also hope that you will support 123WORDPRESS.COM.

<<:  General Guide to Linux/CentOS Server Security Configuration

>>:  WeChat applet tab left and right sliding switch function implementation code

Recommend

Does MySql need to commit?

Whether MySQL needs to commit when performing ope...

HTML embedded in WMP compatible with Chrome and IE detailed introduction

In fact, there are many corresponding writing met...

A brief discussion on how to use slots in Vue

How to define and use: Use the slot tag definitio...

MySQL optimization strategy (recommended)

In summary: 1. Consider performance when designin...

Understanding MySQL clustered indexes and how clustered indexes grow

In this note, we briefly describe What is the B+T...

How to smoothly go online after MySQL table partitioning

Table of contents Purpose of the table For exampl...

CSS style writing order and naming conventions and precautions

The significance of writing order Reduce browser ...

JS asynchronous execution principle and callback details

1. JS asynchronous execution principle We know th...

Solve the problem of specifying udp port number in docker

When Docker starts a container, it specifies the ...

How to quickly build your own server detailed tutorial (Java environment)

1. Purchase of Server 1. I chose Alibaba Cloud...

CSS modular solution

There are probably as many modular solutions for ...

About MySQL 8.0.13 zip package installation method

MySQL 8.0.13 has a data folder by default. This f...

Let's talk about what JavaScript's URL object is

Table of contents Overview Hash Properties Host p...

Practice of dynamically creating dialog according to file name in vue+el-element

Table of contents background accomplish 1. Encaps...