init_connect | BestHub

Aikesheng Open Source Community

Jun 7, 2022 · Databases

Implementing MySQL Auditing with init_connect, MariaDB Audit Plugin, and McAfee Audit Plugin

This article explains three practical methods for adding audit capabilities to MySQL 5.7—using the init_connect parameter to log user connections, installing the MariaDB server_audit plugin for detailed event logging, and deploying the McAfee audit plugin—while providing step‑by‑step commands, configuration examples, code snippets, and a comparison of advantages and drawbacks.

AuditingMariaDBMcAfee

0 likes · 27 min read

Implementing MySQL Auditing with init_connect, MariaDB Audit Plugin, and McAfee Audit Plugin

Aikesheng Open Source Community

May 23, 2022 · Databases

Resolving MySQL “Server Has Gone Away” for a Read‑Only User: The Impact of init_connect and SUPER Privilege

The article explains why a newly created read‑only MySQL 5.7 user receives a “MySQL server has gone away” error, analyzes the role of the init_connect variable and SUPER privilege, and provides a step‑by‑step fix by correcting the init_connect setting.

Read-Only UserSUPER privilegeTroubleshooting

0 likes · 10 min read

Resolving MySQL “Server Has Gone Away” for a Read‑Only User: The Impact of init_connect and SUPER Privilege

Aikesheng Open Source Community

Jul 21, 2020 · Databases

Auditing MySQL Operations with init_connect and Binlog Analysis

This article demonstrates how to audit MySQL user actions by configuring init_connect, creating an audit log table, enabling binlog, and analyzing binlog entries to identify the user and IP responsible for accidental table deletions.

AuditingDatabase Operationsbinlog

0 likes · 8 min read

Auditing MySQL Operations with init_connect and Binlog Analysis