Question: how to rotate MySQL user passwords

[lah-wag]

Hi,

I have some databases, users and grant created with the provider. The passwordRef field is empty, so passwords are auto-generated.
How can I trigger a rotation of the passwords?

I'm running version 0.9

/Lasse

[Brightside56]

@lah-wag idea I'm currently considering is to rotate those using blue-green deployments (e.g. with Argo Rollouts)

[Brightside56]

Also MySQL does support dual passwords https://dev.mysql.com/doc/refman/9.1/en/password-management.html

RETAIN CURRENT PASSWORD

could be used with alter/set password to set new password, while keeping old password working (application can be restarted and old passwords can be expired by some background function)... @chlunde I'm wondering if it fine to add option to retain current password on mysql user updates?