The following editor will bring you a summary of several key points aboutmysqlinit_connect. The editor thinks it’s pretty good, so I’ll share it with you now and give it as a reference. Let’s follow the editor and take a look.
The role of init_connect
init_connect is usually used to do some operations when a connection comes in, For example, set autocommit to 0, or record the current connected IP source and user information into a new table as login log information
Notes on using init_connect
1 Only the super account can set it (super_priv permission)
2 The super account ignores the init_connect setting (that is, the init_connect setting does not take effect on connections from the super account)
【Related recommendations】
2.Detailed examples of adding new user permissions in MySQL
3.Detailed examples of changing passwords and access restrictions in MySQL
4.Details of examples of replacing content in the database with regular expressionsSolution
5.Detailed explanation of examples of php storing images in mysql
The above is the detailed content of Detailed example of init_connect method in mysql. For more information, please follow other related articles on the PHP Chinese website!