MySQL Server

Once MySQL is configured to deliver events to EventTracker Manager; alerts, dashboards and reports can be configured into EventTracker.

Some of the Knowledge Packs available in EventTracker are listed below. For more information please refer Integration Guide.

Alerts

MySQL: Privilege change- This alert is generated when administrator grant or revoke the privileges to the user.
MySQL: User password reset- This alert is generated when administrator reset the user password.

Reports

MySQL-Privileges management: This report provides information related to privilege management when administrator has granted or revoked the privileges from the particular user. It consist of columns LogTime, Computer, User Name, Client Host, Privileges, Database, User Details, Privileges On and Query Executed.

Alerts

MySQL: User created- This alert is generated when administrator creates the user.

Reports

MySQL-User authentication success: This report provides the information related to authentication success when user connects the database with valid credentials. It consists of columns LogTime, Computer, User Name, Client Host and Database.
MySQL-User management: This report provides the information related to user management when administrator creates, drops and rename the user details. It consists of columns LogTime, Computer, User Name, Client Host, Action, User Details, Database and Query Executed.

Alerts

MySQL: Service down- This alert is generated when MySQL service is shutdown by the administrator.
MySQL: User authentication failed- This alert is generated when user enters wrong credentials to connect MySQL database.
MySQL: Delete database- This alert is generated when administrator deletes the database.
MySQL: Delete table- This alert is generated when administrator deletes the table.

Reports

MySQL-Authentication failure: This report provides the information related to authentication failure when user enters the wrong credentials and failed to connect the database. It consists of columns LogTime, Computer, User Name, Client Host, Action and Database.
MySQL-Database management: This report provides information related to database management when user creates and drops the database. It consists of columns LogTime, Computer, Client Host, User Name, Action and Database Name.
MySQL-Table management: This report provides information related to table management when user creates, drops, rename, update, insert and alter the table. It consists of LogTime, Computer, Client Host, User Name, Database, Action and Table Name.

The configuration details are consistent with EventTracker Enterprise version 7.x and later,MySQL 5.7, MariaDB 10.1 and Percona MySQL 5.6.31.

For more information please refer to the Integration guide