When Strapi tries to connect to MySQL , the below issue is being thrown. It was working perfectly fine for over a month.

error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client

I am unable to run the query that is widely provided to fix this issue.

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';

I get the error 'Error Code: 1524. Plugin 'mysql_native_password' is not loaded'.

Please help.