How to manage passwords

Charmed MySQL user credentials are managed with Juju’s get-password and set-password actions.

See also

Users

Get password

To retrieve user credentials for a MySQL user, run the get-password action on the leader unit as follows:

VM

juju run mysql/leader get-password username=<username>

K8s

juju run mysql-k8s/leader get-password username=<username>

Set password

To change a MySQL user’s password to a new, randomized password:

VM

juju run mysql/leader set-password username=<username>

K8s

juju run mysql-k8s/leader set-password username=<username>

To set a manual password for a MySQL user:

VM

juju run mysql/leader set-password username=<username> password=<password>

K8s

juju run mysql-k8s/leader set-password username=<username> password=<password>