Support for log_error_suppression_list in MySQL8 Parameter Groups


MySQL 8.0.34 error log contains deprecation warnings when a client authenticates using the mysql_native_password authentication plugin. This is the default for previous MySQL versions on RDS, so I imagine many users upgrading will have a similar issue. Errors look like this:

2023-08-31T12:01:12.183036Z 19100582 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password'
is deprecated and will be removed in a future release. Please use caching_sha2_password instead'

On a busy server, this creates several MB of logs per minute. I'd like to update to the preferred caching_sha2_password, but doing so requires client library updates which will take some time and coordination.

In the mean time, I'd like to suppress the warning using the system variable, but this variable is not supported in MySQL 8 parameter groups.

I can fall back to suppressing ALL warnings by setting to 1 (instead of the default 2), but doing so turns off all warnings, which I would like to continue to see.

Can the RDS team add support for log_error_suppression_list in MySQL 8 parameter groups please? Or is there another solution to prevent logs from filling up with the deprecation warnings?

asked 25 days ago114 views
1 Answer

Also having the same issue after updating user credentials to use caching_sha2_password. I wonder if it's related to the rdsadmin account still being set to mysql_native_password, which I don't think we can update. It is unclear whether rdsadmin may be getting used by AWS for duplication, monitoring, etc.

answered 16 days ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions