Propagate updates to secrets. Rotate root password

[lukasmu]

Is your feature request related to a problem? Please describe. When I update a secret, e.g. the password of a database user, this does not seem to be propagated to the database. Hence, I cannot login to the database using the new password.

Describe the solution you'd like I would like that updates to secrets are propagated to the database. Hence, I would like to login to the database using the new password. This would allow to easily rotate database user passwords and can be used to improve security.

Describe alternatives you've considered n/a

Environment details:

• Kubernetes version: v1.28.5+k3s1
• Kubernetes distribution: k3s
• mariadb-operator version: 0.24.0
• Install method: helm & static manifests
• Install flavor: minimal

Additional context n/a