Azure Database for MySQL now provides preview support for using audit logs to record database activity and events such as connections, queries, etc. These logs are integrated with Azure Monitor Diagnostic Logs to allow users to retain logs in Azure Storage, perform analysis with Azure Monitor Logs, and integrate with third-party tools via Event Hubs.
Read the audit logs documentation to learn more.