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 the root user, run the get-password action on the leader unit as follows:

VM

juju run mysql/leader get-password

K8s

juju run mysql-k8s/leader get-password

To retrieve credentials for a different user:

VM

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

K8s

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

Juju 2.9 users

Remember that juju run <action name> becomes juju run-action <action name> --wait.

See also: Breaking changes between Juju 2.9 and 3

Set password

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

VM

juju run mysql/leader set-password

K8s

juju run mysql-k8s/leader set-password

To set a manual password for the root user:

VM

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

K8s

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

To set a manual password for another user:

VM

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

K8s

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