Tencent Cloud provides database audit capabilities for TDSQL-C for MySQL, which can record accesses to databases and executions of SQL statements to help you manage risks and improve the database security.
Enabling SQL Audit Service
1. Log in to the TDSQL-C for MySQL console, select Database Audit on the left sidebar, select a region at the top, click the Audit Instance tab, and click Disabled to filter instances whose audit is disabled.
Alternatively, in Audit Instance on the Audit Log tab, directly search for instances whose audit is disabled and then enable audit.
2. On the Audit Instance tab, click the ID of the target instance to enter the enablement page, select a log retention period, and click Enable.
You can select 7 days, 30 days, 3 months, 6 months, 1 year, 3 years, or 5 years as the audit log retention period. You can also modify it in the console after enabling audit. For more information, see Modifying Log Retention Period.
In order to meet the security compliance requirements for the retention period of SQL logs, we recommend you select 180 days or above.
Viewing Audit Log
After enabling audit, you can view SQL audit logs on the Audit Log tab. For more information, see Viewing Audit Log.