How to manage related applications
Modern mysql_client interface:
Relations to new applications are supported via the “mysql_client” interface. To create a relation:
juju relate mysql-k8s application
To remove a relation:
juju remove-relation mysql-k8s application
Legacy mysql interface:
This charm also supports the legacy relation via the mysql interface. Please note that these interface is deprecated.
juju relate mysql-k8s:mysql wordpress-k8s
Also extended permissions can be requested using mysql-root endpoint:
juju relate mysql-k8s:mysql-root wordpress-k8s
Rotate applications password
To rotate the passwords of users created for related applications, the relation should be removed and related again. That process will generate a new user and password for the application, while retaining the requested database and data.
juju remove-relation application mysql-k8s
juju add-relation application mysql-k8s
Internal operator user
The operator user is used internally by the Charmed MySQL Operator, the set-password action can be used to rotate its password.
- To set a specific password for the operator user
juju run-action mysql-k8s/leader set-password password=<password> --wait
- To randomly generate a password for the operator user
juju run-action mysql-k8s/leader set-password --wait