How do I change the Authentication Plugin for users mysql.sys, mysql.session, etc, on AWS RDS MySQL?

Question

I'm facing [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'
Moreover, several access denied error message. I have checked the parameter: select @@default_authentication_plug: mysql_native_password
How to properly fix this issue?

Oleksii Bebych · Answer

> Amazon RDS doesn't currently support the following MySQL features: Authentication Plugin

https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/MySQL.Concepts.FeatureSupport.html

> RDS for MySQL version 8.0.34 and higher use the mysql_native_password plugin. You can't change the default_authentication_plugin setting.

https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/MySQL.KnownIssuesAndLimitations.html#MySQL.Concepts.KnownIssuesAndLimitations.authentication-plugin

try to execute the following command:

```
ALTER USER 'your_username'@'%' IDENTIFIED WITH caching_sha2_password BY 'your_new_password';
```

How do I change the Authentication Plugin for users mysql.sys, mysql.session, etc, on AWS RDS MySQL?

Relevant content