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

2

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...)

posta 4 mesi fa10998 visualizzazioni
3 Risposte
1
Risposta accettata

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.

Joseph
con risposta 4 mesi fa
profile pictureAWS
ESPERTO
verificato 4 mesi fa
1

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.

con risposta 3 mesi fa
  • Hi Bruno, the accounts are system accounts I do not have rights to do ALTER USER on.

0

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 ?

con risposta 3 mesi fa

Accesso non effettuato. Accedi per postare una risposta.

Una buona risposta soddisfa chiaramente la domanda, fornisce un feedback costruttivo e incoraggia la crescita professionale del richiedente.

Linee guida per rispondere alle domande