Change Password Plugin 'mysql_native_password' for rdsrepladmin and rds_superuser_role Users

Question

In order to upgrade my RDS MySQL to 8.0.40 version I got some warnings, among them is the 'mysql_native_password', stating that it'll be deprecated in future versions, so I updated the plugin to 'caching_sha2_password' using the following query to all of my users

```
ALTER USER 'user'@'%' IDENTIFIED WITH caching_sha2_password BY 'mynewpassword';
```

But I got an Issue with 2 users:  rdsrepladmin and rds_superuser_role, because I don't have any access or connection with those ones. So before test the query showed previously, is it safe to change and update the password plugin for those default users or have I to change it in other way?

NetworkPitu · Answer

Basically rdsrepladmin and rds_superuser_role you should not edit manually. Those accounts are internal managed by AWS so automatically after upgrade they will change authentication plugin. Chaning those accounts may cause some issues with replications, backups or even in future upgrades. So you should leave those accounts as-is.

Change Password Plugin 'mysql_native_password' for rdsrepladmin and rds_superuser_role Users

Add your answer

Relevant content