1. Login to AWS Management Console: Go to the AWS Management Console and log in with your credentials.
2. Navigate to RDS Service: Click on the “Services” dropdown menu at the top left corner of the console, then select “RDS” under the Database category.
3. Select the Aurora Database: From the list of RDS instances, locate and select the MySQL Aurora database for which you want to enable logs.
4. Enable Enhanced Monitoring: In the RDS dashboard for the selected instance, navigate to the left-hand side menu and click on “Logs & events”.
5. Enable Audit Log: Under the “Logs & events” section, you will find the option to enable different types of logs such as Audit log, Error log, Slow query log, etc. Click on “Modify” next to the Audit log.
6. Enable Audit Log: In the “Modify DB instance” window, find the “Audit log” section and set the “Enable audit log” toggle to “Yes”.
7. Set Log Retention Period: Optionally, you can set the retention period for the logs. By default, logs are retained for 7 days. You can adjust this as per your requirements.
8. Save Changes: Scroll down to the bottom of the page and click on the “Continue” button.
9. Apply Changes: Review the changes you are about to make and click on the “Modify DB instance” button to apply the changes.
10. Verify Log Enablement: Once the modification is complete, go back to the RDS dashboard and check the status of the Audit log to ensure that it is now enabled for the MySQL Aurora database.

​

1. Enable Enhanced Logging: Enable enhanced logging for your Aurora MySQL RDS instance. This will allow you to access the query and error logs.

aws rds modify-db-instance --db-instance-identifier <your-db-instance-identifier> --enable-enhanced-monitoring --monitoring-role-arn <your-monitoring-role-arn> --monitoring-interval 60

2. Enable Query and Error Logs: Enable the query and error logs for your Aurora MySQL RDS instance.

aws rds modify-db-instance --db-instance-identifier <your-db-instance-identifier> --enable-cloudwatch-logs-exports '["audit","error","general","slowquery"]'

3. Verify the Configuration: Check if the configuration has been applied successfully by describing your RDS instance.

aws rds describe-db-instances --db-instance-identifier <your-db-instance-identifier> --query 'DBInstances[*].[DBInstanceArn,DBInstanceStatus]'

1. Import the necessary Python libraries:

import boto3

2. Connect to the AWS RDS service using the Boto3 library:

client = boto3.client('rds')

3. Identify the RDS instance for which you want to enable MySQL Aurora logs:

db_instance_identifier = 'your_rds_instance_identifier'

4. Enable the MySQL Aurora logs for the identified RDS instance:

response = client.modify_db_instance(
    DBInstanceIdentifier=db_instance_identifier,
    EnableCloudwatchLogsExports=['error','general','slowquery']
)

5. Verify that the MySQL Aurora logs have been successfully enabled for the RDS instance:

response = client.describe_db_instances(DBInstanceIdentifier=db_instance_identifier)
logs_enabled = response['DBInstances'][0]['EnabledCloudwatchLogsExports']
if 'error' in logs_enabled and 'general' in logs_enabled and 'slowquery' in logs_enabled:
    print("MySQL Aurora logs have been successfully enabled for the RDS instance.")
else:
    print("Failed to enable MySQL Aurora logs for the RDS instance.")