Logging and monitoring

‘audit_log_enabled’ configuration is set to ‘OFF’ for MySQL Database Server

Description

Azure Database for MySQL Single Server is a fully managed database service designed for minimal customization. It was detected that the 'audit_log_enabled' of My SQL database {AzureMySqlDbServer} set to Off. Enabling audit_log_enabled helps MySQL Database to log items such as connection attempts to the server, DDL/DML access, and more. Log data can be used to identify, troubleshoot, and repair configuration errors and suboptimal performance.
  • Recommended Mitigation

    It is recommended to enable audit log for MySQL database server. For more information: <a href="https://learn.microsoft.com/en-us/azure/mysql/single-server/how-to-configure-audit-logs-portal" target="_blank" rel="noopener noreferrer">https://learn.microsoft.com/en-us/azure/mysql/single-server/how-to-configure-audit-logs-portal</a>