Charmed MySQL

  • By Canonical Data Platform
  • Cloud
Channel Revision Published Runs on
8.0/stable 240 20 Jun 2024
Ubuntu 22.04
8.0/candidate 240 17 Jun 2024
Ubuntu 22.04
8.0/beta 240 17 Jun 2024
Ubuntu 22.04
8.0/edge 253 12 Jul 2024
Ubuntu 22.04
8.0/edge 252 12 Jul 2024
Ubuntu 22.04
juju deploy mysql --channel 8.0/stable
Show information



How to manage related applications

:information_source: Hint: Use Juju 3. Otherwise replace juju integrate with juju relate for Juju 2.9.

New mysql_client interface:

Relations to new applications are supported via the “mysql_client” interface. To create a relation:

juju integrate mysql application

To remove a relation:

juju remove-relation mysql application

Legacy mysql interface:

We have also added support for the database legacy relation via the mysql interface. Please note that these interface is deprecated.

juju integrate mysql:mysql wordpress

Also extended permissions can be requested using mysql-root edpoint:

juju integrate mysql:mysql-root wordpress

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.

juju remove-relation application mysql
juju integrate application mysql

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 mysql/leader set-password password=<password>
  • To randomly generate a password for the operator user
juju run mysql/leader set-password

Help improve this document in the forum (guidelines). Last updated 10 months ago.