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 https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_log_error_suppression_list system variable, but this variable is not supported in MySQL 8 parameter groups.
I can fall back to suppressing ALL warnings by setting https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_log_error_verbosity 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?
AWS OFFICIALUpdated a month ago
