By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post

RDS Aurora Error: Access denied for user 'rdsadmin'@'localhost'

0

June 25, 2024.

In order to modify the Aurora cluster parameter group, I restarted the RDS (only changing the binlog_format parameter from OFF to ROW).

But after RDS restarts, the error log contains the following errors:

Enter image description here

Every 10 seconds, the system user ‘rdsadmin’ attempts to log in but is rejected.

Using the show processlist command, you can see that the rdsadmin user has indeed logged in.

Enter image description here

How to locate the cause of this problem and eliminate errors?

I have done my best.

:(

Thanks.

Topics
Security, Identity, & ComplianceDatabaseAnalytics
Tags
AWS Identity and Access ManagementDatabaseAmazon AuroraAurora MySQLAmazon RDS Database Preview Environment
Language
English
Quanah
asked 2 months ago682 views
2 Answers
2

I think your at a point now where you need to log a support ticket with AWS

profile picture
EXPERT
Gary Mclean
answered 2 months ago
profile picture
EXPERT
Oleksii Bebych
reviewed 2 months ago
profile picture
EXPERT
Riku_Kobayashi
reviewed 2 months ago
0

Hi Quanah,

Thank you for posting your concern.

I'm sorry for the inconvenience. Could you please log a support case to assist with our investigation? That would be the best way to get this resolved.

AWS
YUTAKA_H
answered 2 months ago
  • Quanah
    a month ago

    Thank you for your suggestion. We have resolved this issue using blue-green deployment, although we have not found the specific cause.

Relevant content