Getting rid of warning: "Plugin mysql_native_password reported: ''mysql_native_password' is deprecated..."

Question

I recently migrated from mysql 5.7 to mysql 8. In my error log, I see a constant stream of lines like:

```
2024-01-16T19:20:00.890049Z 16491 [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'
```

All my user accounts have been switched to use 'caching_sha2_password"

The only accounts using mysql_native_password are:

rdsrepladmin (likely created when I did a Blue/Green migration with associated replication)
mysql.sys

As far as I know, I have no way to change those two system generated accounts.

How can I get rid of those error messages, either by fixing the underlying issue or by suppressing the warnings? They make it very hard to scan the logs for other errors (of which there are currently none...)

Accepted Answer

Hi,

This is known issue. Looks like AWS is aware of it and is working on it but no ETA provided. There is already a plan in place to have "default_authentication_plugin" modifiable in the future. Please check the answers to this [question](https://repost.aws/questions/QUc_APXlzaTY6Ml73KEjRZwg/support-for-log-error-suppression-list-in-mysql8-parameter-groups).

Answer

I tested locally and simply updating the user worked for me.

ALTER USER 'user'@'%' IDENTIFIED WITH caching_sha2_password BY 'password';

Just be careful when applying this to production.

Answer

hello i am facing issue since two months that my DB is taking to much time to Sending to client and it happens randomly any one knows what will be the issue ?

Getting rid of warning: "Plugin mysql_native_password reported: ''mysql_native_password' is deprecated..."

関連するコンテンツ